Laljo John Pullokkaran created HIVE-11919:
---------------------------------------------

             Summary: Hive Union Type Mismatch
                 Key: HIVE-11919
                 URL: https://issues.apache.org/jira/browse/HIVE-11919
             Project: Hive
          Issue Type: Bug
            Reporter: Laljo John Pullokkaran
            Assignee: Laljo John Pullokkaran


In Hive for union right most type wins out for most primitive types during plan 
gen. However when union op gets initialized the type gets switched.

This could result in bad data & type exceptions.

This happens only in non cbo mode.
In CBO mode, Hive would add explicit type casts that would prevent such type 
issues.

Sample Query: 
select cd/sum(cd) over() from(select cd from u1 union all select cd from u2 
union all select cd from u3)u4;



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

Reply via email to