hadoop - Unable to add a column as part of hive query -

create external table old_events (day string, foo string, count string, internal_id string) row format delimited fields terminated '\t' location '${input}';;  create external table events (internal_id, foo string, count string) row format delimited fields terminated '\t' location '${output}';;  insert overwrite table events select internal_id, e2.foo, count(e1.foo) old_events e2 left outer join old_events e1 on e1.foo = e2.foo e1.event = 'event1' , e2.event = 'event2' group e2.foo; 

i following error, if internal_id part of select clause failed: error in semantic analysis: line 5:8 expression not in group key internal_id

in order avoid this, added internal_id group column , results in following error. failed: error in semantic analysis: column internal_id found in more 1 tables/subqueries

how past issue?

brisi e1, e2 both has column internal_id have point out column want eg:

insert overwrite table events select e2.internal_id, e2.foo, count(e1.foo) old_events e2 left outer join old_events e1 on e1.foo = e2.foo , e1.event = 'event1' e2.event = 'event2' group e2.internal_id, e2.foo;