Hi,
I am stuck with what is probably a beginner's mistake, but I simply don't know what's wrong. I have two tables aux1 and aux2, with each two columns objname (STRING) and no_null (INT). I want to find all entries of objname appearing in both tables and gave hive the following statement: SELECT t1.objname, t1.no_null, t2.no_null, (t1.no_null + t2.no_null) AS null_sum FROM aux1 t1 JOIN aux2 t2 ON (t1.objname = t2.objname) GROUP BY t1.objname SORT BY null_sum LIMIT 30; But I got the error message "Error in semantic analysis: line 1:19 Expression Not In Group By Key t1". I don't really understand what that means. Anyone can help me? Regards, Jan
