hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bejoy KS" <>
Subject Re: date datatype in hive
Date Wed, 27 Jun 2012 06:32:01 GMT
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;

Bejoy KS

Sent from handheld, please excuse typos.

-----Original Message-----
From: Soham Sardar <>
Date: Wed, 27 Jun 2012 11:57:23 
To: <>; Bejoy Ks<>
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
<> 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 <> wrote:
>> Hi Soham
>> Hive Supports pretty much all the primitive data types including INT. For a detaild
list please refer
>> 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
>> Regards
>> Bejoy KS
>> ________________________________
>> From: Soham Sardar <>
>> To:; user <>
>> 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}
View raw message