[ https://issues.apache.org/jira/browse/HIVE-16646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16007665#comment-16007665 ]
Hive QA commented on HIVE-16646: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12867633/HIVE-16646.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 10688 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[mapjoin2] (batchId=236) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_join30] (batchId=149) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3] (batchId=97) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3] (batchId=97) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5212/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5212/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5212/ 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: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12867633 - PreCommit-HIVE-Build > Alias in transform ... as clause shouldn't be case sensitive > ------------------------------------------------------------ > > Key: HIVE-16646 > URL: https://issues.apache.org/jira/browse/HIVE-16646 > Project: Hive > Issue Type: Bug > Components: hpl/sql > Reporter: Yibing Shi > Assignee: Yibing Shi > Attachments: HIVE-16646.1.patch, HIVE-16646.2.patch > > > Create a table like below: > {code:sql} > CREATE TABLE hive_bug(col1 string); > {code} > Run below query in Hive: > {code} > from hive_bug select transform(col1) using '/bin/cat' as (AAAA string); > {code} > The result would be: > {noformat} > 0: jdbc:hive2://localhost:10000> from hive_bug select transform(col1) using > '/bin/cat' as (AAAA string); > ...... > INFO : OK > +-------+--+ > | AAAA | > +-------+--+ > +-------+--+ > {noformat} > The output column name is *AAAA* instead of the lowercase aaaa. -- This message was sent by Atlassian JIRA (v6.3.15#6346)