hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1460) JOIN should not output rows for NULL values
Date Mon, 12 Jul 2010 21:18:50 GMT

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

View raw message