[ https://issues.apache.org/jira/browse/HIVE-22601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16993686#comment-16993686 ]
Hive QA commented on HIVE-22601: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12988500/HIVE-22601.2.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 17755 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19874/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19874/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19874/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12988500 - PreCommit-HIVE-Build > Some columns will be lost when a UDTF has multiple aliases in some cases > ------------------------------------------------------------------------ > > Key: HIVE-22601 > URL: https://issues.apache.org/jira/browse/HIVE-22601 > Project: Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 3.1.2 > Reporter: okumin > Assignee: okumin > Priority: Major > Attachments: HIVE-22601.1.patch, HIVE-22601.2.patch, HIVE-22601.patch > > > Only one column will be retained when putting UDTFs with multiple aliases and > a top-level UNION together. > For example, the result of the following SQL should have three columns, c1, > c2 and c3. > {code:java} > SELECT stack(1, 'a', 'b', 'c') AS (c1, c2, c3) > UNION ALL > SELECT stack(1, 'd', 'e', 'f') AS (c1, c2, c3); > {code} > However, It's only the c3 column which I can get. > {code:java} > +---------+ > | _u1.c3 | > +---------+ > | c | > | f | > +---------+ > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)