[
https://issues.apache.org/jira/browse/DRILL-831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007673#comment-14007673
]
Aman Sinha commented on DRILL-831:
----------------------------------
The problem was in hash join when we were not executing the 'probe' phase if
the hash table was null (due to empty right side). Uploaded a patch for this.
> NOT-IN query returns wrong results if right side is empty
> ---------------------------------------------------------
>
> Key: DRILL-831
> URL: https://issues.apache.org/jira/browse/DRILL-831
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Aman Sinha
> Assignee: Aman Sinha
> Attachments:
> 0001-Fix-DRILL-831-Execute-the-probe-phase-for-outer-join.patch
>
>
> 0: jdbc:drill:zk=local> select count(*) from region r1 where r1.r_regionkey
> not in (select r2.r_regionkey from region r2 where r2.r_regionkey = 10);
> +--+
> | |
> +--+
> +--+
> No rows selected
> This correct result is 5 rows since right side of the NOT IN produces 0 rows.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
