RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
, LUTTER, Steffen mailto: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 this just translates

RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
fferent is that equal can cast 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 mailto:steffen.lut..

RE: Syntax for filters on timstamp data type

2013-04-05 Thread LUTTER, Steffen
r [mailto:nitinpawar...@gmail.com] Sent: 05 April 2013 16:11 To: user@hive.apache.org Subject: Re: Syntax for filters on timstamp data type I am not sure IN clause supports executing functions in the query did it fail when you tried less than greater than type On Fri, Apr 5, 2013 at 7:36

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 syntax, while the equal comparison works without problems. Example: SE

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 wo