Steve Carlin created HIVE-24926:
-----------------------------------
Summary: Correlated fields not detected if subquery has where and
group clauses.
Key: HIVE-24926
URL: https://issues.apache.org/jira/browse/HIVE-24926
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Steve Carlin
The following query is failing to compile:
{code:java}
SELECT id
FROM alltypestiny t1
WHERE EXISTS
(SELECT 1
FROM alltypestiny t2
WHERE t1.id = t2.id
GROUP BY t2.id
HAVING count(1) = 1);
{code}
The reason it fails is because there is a group by clause and because t1.id is
used in the where clause.
The failure can be traced to code within HiveFilter.traverseFilter, which
doesn't find the filter because it returns when it sees the HiveAggregate.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
