[
https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740650#action_12740650
]
Ning Zhang commented on HIVE-734:
---------------------------------
BTW, I tried joins and it doesn't handle NULL semantics correctly. Here's the
data and results:
Table:
Key Value
------- -------
NULL 325
18 NULL
Query:
select * from input4_cb a join input4_cb b on a.key = b.value;
Result:
NULL 325 18 NULL
The correct result should be empty set.
I guess the NULL vs. NULL comparison is incorrectly evaluated.
> problem in dealing with null
> ----------------------------
>
> Key: HIVE-734
> URL: https://issues.apache.org/jira/browse/HIVE-734
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: Zheng Shao
> Assignee: Ning Zhang
>
> This command fails with the following error:
> {code}
> hive/bin/hive -e "INSERT OVERWRITE LOCAL DIRECTORY 'abc' select null from
> zshao_tt"
> FAILED: Error in semantic analysis:
> java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for
> VOID
> {code}
> When 'null' is replaced by '' it works.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
