Krisztian Kasa created HIVE-24929: ------------------------------------- Summary: Allow correlated exists subqueries with windowing clause Key: HIVE-24929 URL: https://issues.apache.org/jira/browse/HIVE-24929 Project: Hive Issue Type: Improvement Components: Query Planning Reporter: Krisztian Kasa Assignee: Krisztian Kasa Fix For: 4.0.0
Currently queries which has windowing clause with subqueries are not supported by Hive: Hive rewrites subqueries to joins and the rewritten plan would lead to incorrect results such cases. However this restriction can be lifted in case of Exists/Not exists subqueries since those cases we don not interested in the result of the window function call but the existence of any record. {code} select id, int_col from alltypesagg a where exists (select sum(int_col) over (partition by bool_col) from alltypestiny b where a.id = b.id); {code} {code} select id, int_col from alltypestiny t where not exists (select sum(int_col) over (partition by bool_col) from alltypesagg a where t.id = a.int_col); {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)