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