hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-734) problem in dealing with null
Date Fri, 07 Aug 2009 05:17:14 GMT

    [ 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 


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.

View raw message