[jira] Commented: (HIVE-1460) JOIN should not output rows for NULL values

["John Sichi (JIRA)" <ji...@apache.org>]

    [ 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.