[
https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740392#action_12740392
]
Zheng Shao commented on HIVE-734:
---------------------------------
We do handle NULL in the WHERE clause and "AND", "OR" functions using the
3-value booleans. I am not sure whether we ignore NULL in join/group-by but
that seems easy enough to do.
Do you have a specific example that the current Hive code breaks?
> 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.