hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14251) Union All of different types resolves to incorrect data
Date Thu, 21 Jul 2016 14:47:20 GMT

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

Ashutosh Chauhan commented on HIVE-14251:
-----------------------------------------

I have found Postgres & Oracle to be lot more closer to standard then mysql, so yes I
would follow their behavior. If that implies throwing exception here, that would be right
course of action.
Current behavior is erroneous we need not to be backward compatible with our erroneous behavior
: ) 

> Union All of different types resolves to incorrect data
> -------------------------------------------------------
>
>                 Key: HIVE-14251
>                 URL: https://issues.apache.org/jira/browse/HIVE-14251
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>    Affects Versions: 2.0.0
>            Reporter: Aihua Xu
>            Assignee: Aihua Xu
>         Attachments: HIVE-14251.1.patch
>
>
> create table src(c1 date, c2 int, c3 double);
> insert into src values ('2016-01-01',5,1.25);
> select * from 
> (select c1 from src union all
> select c2 from src union all
> select c3 from src) t;
> It will return NULL for the c1 values. Seems the common data type is resolved to the
last c3 which is double.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message