Panagiotis Garefalakis created HIVE-24478: ---------------------------------------------
Summary: Inner GroupBy with Distinct SemanticException: Invalid column reference Key: HIVE-24478 URL: https://issues.apache.org/jira/browse/HIVE-24478 Project: Hive Issue Type: Bug Reporter: Panagiotis Garefalakis {code:java} CREATE TABLE tmp_src1( `npp` string, `nsoc` string) stored as orc; INSERT INTO tmp_src1 (npp,nsoc) VALUES ('1-1000CG61', '7273111'); SELECT `min_nsoc` FROM (SELECT `npp`, MIN(`nsoc`) AS `min_nsoc`, COUNT(DISTINCT `nsoc`) AS `nb_nsoc` FROM tmp_src1 GROUP BY `npp`) `a` WHERE `nb_nsoc` > 0; {code} Issue: {code:java} org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Invalid column reference 'nsoc' at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanGroupByOperator1(SemanticAnalyzer.java:5405) {code} Query runs fine when we include `nb_nsoc` in the Select expression -- This message was sent by Atlassian Jira (v8.3.4#803005)