[ https://issues.apache.org/jira/browse/HIVE-11919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14942065#comment-14942065 ]
Hive QA commented on HIVE-11919: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12764527/HIVE-11919.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 9644 tests executed *Failed tests:* {noformat} org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5503/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/5503/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-5503/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12764527 - PreCommit-HIVE-TRUNK-Build > 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 > Attachments: HIVE-11919.1.patch, HIVE-11919.2.patch > > > 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)