Monthly Archives: June 2015

Creating Table in HIVE : [crayon-5e4e5dad3d673182952029/] Aggregated Functions and Normal Queries: [crayon-5e4e5dad3d680884412106/] SUM Returns the sum of the elements in the group or sum of the distinct values of the column in the group. [crayon-5e4e5dad3d684903211752/] Count count(*) – Returns the total number of retrieved rows, including rows containing NULL values; […]

Hive Aggregate Functions

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. [crayon-5e4e5dad3edcd141234501/] […]

Hive Date Functions