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 <edlinuxg...@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
