You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2019/06/20 00:00:55 UTC
[jira] [Commented] (HIVE-21898) Wrong result with IN correlated
subquery with aggregate in SELECT
[ https://issues.apache.org/jira/browse/HIVE-21898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16868126#comment-16868126 ]
Vineet Garg commented on HIVE-21898:
------------------------------------
Hive currently throw a runtime error for queries which are correlated, produces empty result set and contain COUNT aggregate in subquery. Above query should follow the same.
> Wrong result with IN correlated subquery with aggregate in SELECT
> -----------------------------------------------------------------
>
> Key: HIVE-21898
> URL: https://issues.apache.org/jira/browse/HIVE-21898
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.0.0, 4.0.0
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
>
> {code:sql}
> select
> p_size in
> (select min(p_size)
> from (select p_mfgr, p_size from part) a
> where a.p_mfgr = b.p_name
> ) from part b limit 1
> {code}
> Expected result: *null*
> Actual result: *false*
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)