Daily Archives: June 23, 2015

Hive Date Functions 9

HIVE Date Functions from_unixtime: This function converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a STRING that represents the TIMESTAMP of that moment in the current system time zone in the format of “1970-01-01 00:00:00”. The following example returns the current date including the time.

from_utc_timestamp This function assumes that the string in the first expression is UTC and then, converts that ┬ástring to the […]