[
https://issues.apache.org/jira/browse/HIVE-15757?focusedWorklogId=563484&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-563484
]
ASF GitHub Bot logged work on HIVE-15757:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 10/Mar/21 03:55
Start Date: 10/Mar/21 03:55
Worklog Time Spent: 10m
Work Description: kasakrisz merged pull request #2039:
URL: https://github.com/apache/hive/pull/2039
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 563484)
Time Spent: 40m (was: 0.5h)
> Allow EXISTS/NOT EXISTS correlated subquery with aggregates
> -----------------------------------------------------------
>
> Key: HIVE-15757
> URL: https://issues.apache.org/jira/browse/HIVE-15757
> Project: Hive
> Issue Type: Sub-task
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available, sub-query
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Currently HIVE doesn't allow correlated EXISTS/NOT EXISTS subqueries which
> has aggregate without group by e.g.
> {code} select *
> from src b
> where exists
> (select count(*)
> from src a
> where b.value = a.value and a.key = b.key and a.value > 'val_9'
> ) ;
> {code}
> Such queries could be rewritten to replace EXISTS/NOT EXISTS predicate with
> {{true}} or {{false}} based on aggregate.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
