Re: Syntax for filters on timstamp data type

2013-04-11 Thread Mark Grover
), CAST ('2009-01-08 00:00:00' AS timestamp) ) ** ** *From:* Mark Grover [mailto:grover.markgro...@gmail.com] *Sent:* 05 April 2013 18:43 *To:* user@hive.apache.org *Subject:* Re: Syntax for filters on timstamp data type ** ** Steffan, One thing that may be different

RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
-11 00:00:00' AS timestamp), CAST ('2009-01-08 00:00:00' AS timestamp) ) From: Mark Grover [mailto:grover.markgro...@gmail.com] Sent: 05 April 2013 18:43 To: user@hive.apache.org Subject: Re: Syntax for filters on timstamp data type Steffan, One thing that may be different is that equal can cast

Re: Syntax for filters on timstamp data type

2013-04-08 Thread Nitin Pawar
:00' AS timestamp) ) ** ** *From:* Mark Grover [mailto:grover.markgro...@gmail.com] *Sent:* 05 April 2013 18:43 *To:* user@hive.apache.org *Subject:* Re: Syntax for filters on timstamp data type ** ** Steffan, One thing that may be different is that equal can cast operands

RE: Syntax for filters on timstamp data type

2013-04-08 Thread LUTTER, Steffen
Exactly From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: 08 April 2013 16:06 To: user@hive.apache.org Subject: Re: Syntax for filters on timstamp data type great so can we assume that equals comparison can auto cast but not the in range statement ? On Mon, Apr 8, 2013 at 7:08 PM

Re: Syntax for filters on timstamp data type

2013-04-05 Thread Nitin Pawar
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 PM, LUTTER, Steffen steffen.lut...@sap.comwrote: Hi, ** ** I have a question regarding filters on timestamps. The syntax seems to be

Re: Syntax for filters on timstamp data type

2013-04-05 Thread Mark Grover
? ** ** Thanks for any thought in this, ** ** Steffen ** ** *From:* Nitin Pawar [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