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

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

I wasn't able to get an example in HIVE. I tried to insert NULL to a table by 
modifying the test query input4_cb_delim.q (actually by only modifying the 
input data to be 

<value1>\002\012
\002<value2>\012

and run the query

select * from input4_cb where key is not null;

and both rows are returned. So either the NULL values are not inserted 
correctly, or the evaluation is not correct about NULL.

> 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