Hi, I have a table where one column (ts) is of type TIMESTAMP. How am I supposed to use this in my query?
The following attempt does not give me a result.
SELECT * FROM mytable WHERE ts > "2014-01-23 00:00:00";
If I change it to the below it works:
SELECT * FROM mytable WHERE ts > cast("2014-01-23 00:00:00" as TIMESTAMP);
Shouldn't Hive (0.10) convert the string for me without the need of an
explicit cast?
Thanks,
Petter
