[Hive-user] hive-0.7.0 semantic analysis inside catalogs

On Thu, Aug 25, 2011 at 12:11 PM, Ayon Sinha wrote:

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 <http://www.flickr.com/photos/ayonsinha/>
Also check out my Blog for answers to commonly asked questions.<http://dailyadvisor.blogspot.com>

------------------------------
*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