HIVE - group by date function

date hadoop group-by hive

This might be because to_date returns null when it's applied on a unix time.
According to the Hive manual:

to_date(string timestamp):
Returns the date part of a timestamp string: to_date("1970-01-01 00:00:00") = "1970-01-01"

Use from_unixtime instead to get back the correct date parts.

Note:
I assume Hex2Dec UDF is taken from the core library of HIVE-1545

CodeHunter