[ https://issues.apache.org/jira/browse/HIVE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Harish Butani updated HIVE-5830: -------------------------------- Attachment: HIVE-5830.2.patch > 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)