), 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
-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
: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
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
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
?
** **
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