How do I set-up a filter constant for TIMESTAMP datatype. In Hive 0.7 since timestamps were represented as strings a query like this would return data
select * from LU_day where day_date ='2010-01-01 00:00:00'; But now with day_date as a TIMESTAMP column it doesn't. Is there some type of a TO_TIMESTAMP function in hive to convert the string constant into a TIMESTAMP one As a workaround I can do select * from LU_DAY where TO_DATE(day_date) = '2010-01-01' but that would be a problem for partitioning pruning, etc