[ https://issues.apache.org/jira/browse/HIVE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13836875#comment-13836875 ]
Hive QA commented on HIVE-5830: ------------------------------- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12616595/HIVE-5830.2.patch {color:green}SUCCESS:{color} +1 4440 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/487/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/487/console Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12616595 > SubQuery: Not In subqueries should check if subquery contains nulls in > matching column > -------------------------------------------------------------------------------------- > > Key: HIVE-5830 > URL: https://issues.apache.org/jira/browse/HIVE-5830 > Project: Hive > Issue Type: Bug > Components: Query Processor > Reporter: Harish Butani > Assignee: Harish Butani > Fix For: 0.13.0 > > Attachments: HIVE-5830.2.patch > > > As pointed out by [~snarayanan] in HIVE-784 for not in when there are nulls > in the SubQuery's matching column the Outer Query should return no rows. -- This message was sent by Atlassian JIRA (v6.1#6144)