See Bejoy and Everyone , I have two tables one users_info and one users_audit in hive ..
hive> desc users_audit; OK id int userid int logtime string hive> desc users_info; OK id int name string age int country string gender string bday string now i have given the description of the tables in hive my goal is to find: the maximum number of users loging - in at between a certain time frame say 1PM to 2PM- belonging to a specific country for example in between 1PM to 2PM there are 10000 users loging into and 5500 are from africa , then i need to print the names of all the users who are logged in between the time stamp and who are from africa .. the logtime in the users_audit table gives the login time and the names and country are from the users_info table . Can someone help me out with this . I am a new user in hive so would like some ones help !!!!!! Thanks in advance!! :) On Tue, Jun 26, 2012 at 6:53 PM, Bejoy Ks <bejoy...@yahoo.com> wrote: > > > 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}
