hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Petter von Dolwitz (Hem)" <petter.von.dolw...@gmail.com>
Subject Usage of TIMESTAMP
Date Thu, 23 Jan 2014 14:20:00 GMT
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

Mime
View raw message