[ 
https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740388#action_12740388
 ] 

Ning Zhang commented on HIVE-734:
---------------------------------

Thanks for the pointer Zheng. We certainly can use JavaVoidObjecInspector for 
NULL. However it turns out NULL is more complicated than what it sounds like 
(see http://en.wikipedia.org/wiki/Null_(SQL) ). NULL has to be handled not only 
in this simple select cause, but also in much more complex cases in the 
where-clause and joins. Let's have a talk.



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

Reply via email to