RE: FW: Filtering on TIMESTAMP data type

2012-05-28 Thread Ladda, Anand
...@tcs.com] Sent: Saturday, May 26, 2012 11:54 AM To: user@hive.apache.org Subject: Re: FW: Filtering on TIMESTAMP data type I guess it exist gotta check. btw...You can always go and write a udf Debarshi Basak Tata Consultancy Services Mailto: debarshi.ba...@tcs.commailto:debarshi.ba...@tcs.com

FW: Filtering on TIMESTAMP data type

2012-05-26 Thread Ladda, Anand
How do I set-up a filter constant for TIMESTAMP datatype. In Hive 0.7 since timestamps were represented as strings a query like this would return data select * from LU_day where day_date ='2010-01-01 00:00:00'; But now with day_date as a TIMESTAMP column it doesn't. Is there some type of a

Re: FW: Filtering on TIMESTAMP data type

2012-05-26 Thread Debarshi Basak
SolutionsOutsourcing-"Ladda, Anand" <lan...@microstrategy.com>wrote: - To: "user@hive.apache.org" user@hive.apache.org, "d...@hive.apache.org" d...@hive.apache.orgFrom: "Ladda, Anand" lan...@microstrategy.comDate: 05/26/2012 06:58PMSubject: FW: