Hey bejoy thats the problem i am not able to run the group by query in hive i dunno whether i m making a mistake or some thing see my previoius reply to this same thread i put up the same issue ...
On Wed, Jun 27, 2012 at 12:02 PM, Bejoy KS <bejoy...@yahoo.com> wrote: > Hi Soham > > Rewrite your query with the columns in Group By included in Select as well. > Something like > > select country,name from users_info group by country; > > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > > -----Original Message----- > From: Soham Sardar <sohamsardart...@gmail.com> > Date: Wed, 27 Jun 2012 11:57:23 > To: <user@hive.apache.org>; Bejoy Ks<bejoy...@yahoo.com> > Reply-To: user@hive.apache.org > Subject: Re: date datatype in hive > > And btw does group by works in hive because the same wuery i am > running in mysql and its working fine but its failing in hive > > select name from users_info group by country; > > in mysql its working but whn i try to run it in hive its telling > > hive> select name from users_info group by country; > FAILED: Error in semantic analysis: Line 1:7 Expression not in GROUP > BY key 'name' > > I wanna know why is it failing > > > On Wed, Jun 27, 2012 at 10:19 AM, Soham Sardar > <sohamsardart...@gmail.com> wrote: >> 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}
