Hive Functions

 

String / Aggregate / Window / Date

Hive Functions

Hive Course: Hive-SQL - Video-tutorial

Hive All date functions in one-shot

Select

unix_timestamp(), 

from_unixtime(unix_timestamp()),

from_utc_timestamp( '2021-09-07 07:18:15', 'IST'), 

to_utc_timestamp('2021-09-07 07:18:15', 'IST'),

TO_Date('2021-09-07 07:18:15'),

WEEKOFYEAR('2021-09-07 07:18:15'), 

DateDiff('2021-09-07 07:18:15','2021-09-09 07:18:15'), 

Date_Add('2021-09-07 07:18:15',5), 

Date_sub('2021-09-07 07:18:15',5);