RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
operands to make equals work but that may not be true for IN. FWIW, this is me just speculating, I haven't looked at the code just yet. Perhaps, you could explicit casting to get around this? On Fri, Apr 5, 2013 at 7:36 AM, LUTTER, Steffen steffen.lut...@sap.commailto:steffen.lut...@sap.com

RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
, LUTTER, Steffen steffen.lut...@sap.commailto:steffen.lut...@sap.com wrote: Hi Mark, Correct, I just did some tests and the cast is the way to go. While for comparison operations (equal, diff, ...) implicit casts work, this is not the case for the IN clause. I think it should, as eventually

Syntax for filters on timstamp data type

2013-04-05 Thread LUTTER, Steffen
Hi, I have a question regarding filters on timestamps. The syntax seems to be UNIX_TIMESTAMP('-MM-dd hh:mm:ss'), is there another way to express a datetime type? The problem is that I get an exception when using the IN list syntax, while the equal comparison works without problems.

getTimestamp in hive jdbc

2013-02-25 Thread LUTTER, Steffen
Hi guys, Does anybody know if the methods getTimestamp(int columnIndex, Calendar cal) and getTimestamp(String columnName, Calendar cal) are going to be implemented in a future version? I am grateful that timestamp is now supported in 0.10.0 (thanks to the devs!!!) and for now I will create a