[
https://issues.apache.org/jira/browse/HIVE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887540#action_12887540
]
John Sichi commented on HIVE-1460:
----------------------------------
Note that something crazy like
ON a.key=b.key OR a.key IS NULL AND b.key IS NULL
actually does allow null values to meet the join condition, so it's not just a
matter of filtering them out before joining.
> JOIN should not output rows for NULL values
> -------------------------------------------
>
> Key: HIVE-1460
> URL: https://issues.apache.org/jira/browse/HIVE-1460
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: Zheng Shao
>
> We should filter out rows with NULL keys from the result of this query
> {code}
> SELECT * FROM a JOIN b on a.key = b.key
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
