Hive Tutorial - 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions

Описание к видео Hive Tutorial - 16 : Hive Functions | Unix Timestamp Functions | Hive Timestamp Functions

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

Комментарии

Информация по комментариям в разработке

Похожие видео