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

Reply via email to