Timestamp stored in the hive column UPDT_DT in the table like, $ presto-cli –catalog hive –schema default presto:default> select updt_dt from HIVE_SRP_TEST_TBL limit 5; updt_dt ————— 1497961733000 1497961733000 1497961733000 1497961733000 1497961733000 (5 rows) ISSUE : When you simple convert to timestamp, the output would be like, presto:default> select from_unixtime(updt_dt)updt_dt from HIVE_SRP_TEST_TBL limit…
Read more
Get daily articles in your inbox for free.
Step:2 - Subscribe Softchief (Guru) Here and Press Bell icon then select All.
Step:3 - Subscribe Softchief (Xtreme) Here and Press Bell icon then select All.
Step:4 - subscribe SmarTechie channel here and Press Bell icon then select All.
After the above 4 steps. Give your email id below and get the answers document in your inbox.
Drop your contact information and our Experts will call you in les than a minute to discuss about your requirement.