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);




1 comment:
Write comments
  1. black titanium ring from the game "Black Tiger" - Titanium Art
    Black Tiger titanium hair trimmer as seen on tv is a table game that babylisspro nano titanium is played in multiple titanium bar stock forms in a traditional casino. The object of this titanium exhaust wrap game is to score points blue titanium cerakote by taking the number of points

    ReplyDelete

Please do not enter spam links

Meet US

Services

More Services