[
https://issues.apache.org/jira/browse/HIVE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887543#action_12887543
]
Zheng Shao commented on HIVE-1460:
----------------------------------
That's a good use case to consider.
I believe Hive currently does not support that (the condition after ON has to
be conjunctive), but it's good to keep it in mind.
> 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.
