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)
