hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ayon Sinha <ayonsi...@yahoo.com>
Subject Re: hive-0.7.0 semantic analysis inside catalogs
Date Thu, 25 Aug 2011 16:11:28 GMT
You need 
 select one.a, two.b from one join two on one.a=two.a group by one.a,two.b;
 
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.



________________________________
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@hive.apache.org
Sent: Thursday, August 25, 2011 8:16 AM
Subject: hive-0.7.0 semantic analysis inside catalogs


The parser can not handle certain queries inside catlogs.

[11:09:51] <ecapriolo> hive> create table one (a int,b int) fields terminated by
'\t';
[11:09:51] <ecapriolo> FAILED: Parse Error: line 1:31 mismatched input 'fields' expecting
EOF
[11:09:51] <ecapriolo> 
[11:09:51] <ecapriolo> hive> create table one (a int,b int) row format delimited
fields  terminated by '\t';
[11:09:51] <ecapriolo> OK
[11:09:51] <ecapriolo> Time taken: 0.459 seconds
[11:09:51] <ecapriolo> hive> create table two (a int,b int) row format delimited
fields  terminated by '\t';
[11:09:51] <ecapriolo> OK
[11:09:51] <ecapriolo> Time taken: 0.039 seconds
[11:09:51] <ecapriolo> hive> select one.a, two.b from one join two on one.a=two.a
group by one.a;

[11:09:51] <ecapriolo> FAILED: Error in semantic analysis: line 1:14 Expression Not
In Group By Key two


Is there a fix/workaround?

Edward
Mime
View raw message