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 17:47:14 GMT

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

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

BTW, I tried joins and it doesn't handle NULL semantics correctly. Here's the data and results:

Table:

Key       Value
-------     -------
NULL    325
18         NULL

Query:

select * from input4_cb a join input4_cb b on a.key = b.value;

Result:

NULL  325   18   NULL

The correct result should be empty set.

I guess the NULL vs. NULL comparison is incorrectly evaluated. 


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


Mime
View raw message