Hi Soham
Hive Supports pretty much all the primitive data types including INT. For a detaild list please refer https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-PrimitiveTypes The only draw back as in common is when you have the data type as String you cannot use it directly on Mathematical functions. Your requirement can easily be satisfied with a few date functions on String data itself. Regards Bejoy KS ________________________________ From: Soham Sardar <sohamsardart...@gmail.com> To: user@hive.apache.org; user <u...@sqoop.apache.org> Sent: Tuesday, June 26, 2012 2:23 PM Subject: date datatype in hive I have a native data type in mysql and i just imported it into hive and the data type of the column has now become string .. Now i would like to know if there is any native data type in hive and What are the pros and cons of using string type in hive rather than (int)(thats what i expect ) type And with the string type can i just run any type of queries like print the names of the person which has the maximum number of users between 1 PM and 3 PM and the table should have just name int(5) and login time (datetime ) {as per the mysql syntax}
