hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Wilfong (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2901) Hive union with NULL constant and string in same column returns all null
Date Sat, 24 Mar 2012 01:55:25 GMT
Hive union with NULL constant and string in same column returns all null
------------------------------------------------------------------------

                 Key: HIVE-2901
                 URL: https://issues.apache.org/jira/browse/HIVE-2901
             Project: Hive
          Issue Type: Bug
            Reporter: Kevin Wilfong
            Priority: Critical


select x from (select value as x from src union all select NULL as x from src)a;

This query produces all nulls, where value is a string column.

Notably, 
select x from (select key as x from src union all select NULL as x from src)a;
where key is a string, but can be cast to a double, the query returns correct results.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message