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 TO_T

RE: [Marketing Mail] Doubts related to Amazon EMR

2012-04-23 Thread Ladda, Anand
Once you have a Hive Job flow running on Amazon EMR, you'll have access to the file system on the underlying EC2 machines (you'll get the machine name, etc once the cluster is running). You can then move your data files on the EC2 machine file system and load it into HDFS/Hive. I am not sure abo