technical solution-Hive Tutorial – 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions from Techmirrors

technical solution-Hive Tutorial – 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions from Techmirrors



This video tutorial talks about the unix timestamp functions in Hive.
The timestamp functions like, from_utc_timestamp(), to_utc_timestamp() are explained in details.

UNIX EPOCH explanation:

// Timezone specific

SELECT UNIX_TIMESTAMP();

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP());

SELECT from_utc_timestamp(‘2020-03-28 11:56:55’, ‘IST’);

SELECT to_utc_timestamp (”,’IST’);

// General Date functions

SELECT TO_DATE(‘2020-03-28 11:56:55’);

SELECT WEEKOFYEAR(‘2020-03-28 11:56:55’);

SELECT DATEDIFF(‘2020-03-28′,’2020-03-28’);

SELECT DATE_ADD(‘2020-03-28’, 5);

SELECT DATE_SUB(‘2020-03-28’, 5);

#Hive Functions – Extracting Information from Dates

SourceTechmirrors

Want to get daily Updated Corp to corp jobs
and also US Hotlist from thousands of active
Bench Sales recruiter on daily basis click below