[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15873012#comment-15873012 ] Hive QA commented on HIVE-15938: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853384/HIVE-15938.04.patch {color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 10246 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=133) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3641/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3641/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3641/ 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: 8 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12853384 - PreCommit-HIVE-Build > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.03.patch, HIVE-15938.04.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872989#comment-15872989 ] Hive QA commented on HIVE-15938: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853384/HIVE-15938.04.patch {color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 11 failed/errored test(s), 10246 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=140) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=133) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgress (batchId=211) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgressParallel (batchId=211) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3640/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3640/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3640/ 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: 11 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12853384 - PreCommit-HIVE-Build > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.03.patch, HIVE-15938.04.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872822#comment-15872822 ] Pengcheng Xiong commented on HIVE-15938: Thanks for [~sershe]'s efforts. The patch LGTM. I just have one doubt. If you try, you will find out that postgres actually supports select * from t order by 1. I am thinking that after HIVE-15160, supporting order by number in select * would be straight forward. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.03.patch, HIVE-15938.04.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872743#comment-15872743 ] Ashutosh Chauhan commented on HIVE-15938: - LGTM. [~pxiong] Can you please also take a look? > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.03.patch, HIVE-15938.04.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872708#comment-15872708 ] Sergey Shelukhin commented on HIVE-15938: - [~ashutoshc] it failed in 10s of the previous builds except one. It may have been the patch that fixed it that is not merged yet :) > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.03.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872701#comment-15872701 ] Ashutosh Chauhan commented on HIVE-15938: - create_view_failure has age 1. Likely related. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872688#comment-15872688 ] Sergey Shelukhin commented on HIVE-15938: - No, they are not related actually. I see they were failing for a while, e.g. https://builds.apache.org/job/PreCommit-HIVE-Build/3632/testReport/org.apache.hadoop.hive.cli/TestNegativeCliDriver/testCliDriver_create_external_acid_/history/ > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872656#comment-15872656 ] Ashutosh Chauhan commented on HIVE-15938: - Failed -ve test looks related. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872657#comment-15872657 ] Ashutosh Chauhan commented on HIVE-15938: - [~pxiong] Can you help review this? > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872613#comment-15872613 ] Hive QA commented on HIVE-15938: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853320/HIVE-15938.02.patch {color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 35 failed/errored test(s), 10245 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constant_prop_1] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[interval_arithmetic] (batchId=43) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union10] (batchId=10) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] (batchId=135) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_external_acid] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_not_acid] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure1] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[external1] (batchId=85) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=133) org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testAlterTable (batchId=194) org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testTransactionalValidation (batchId=194) org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testAlterTable (batchId=197) org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testTransactionalValidation (batchId=197) org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterTable (batchId=193) org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTransactionalValidation (batchId=193) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testAlterTable (batchId=191) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testTransactionalValidation (batchId=191) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testAlterTable (batchId=202) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testTransactionalValidation (batchId=202) org.apache.hadoop.hive.ql.security.TestMetastoreAuthorizationProvider.testSimplePrivileges (batchId=210) org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProvider.testSimplePrivileges (batchId=208) org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProviderWithACL.testSimplePrivileges (batchId=220) org.apache.hive.hcatalog.api.TestHCatClient.testBasicDDLCommands (batchId=170) org.apache.hive.hcatalog.api.TestHCatClient.testTransportFailure (batchId=170) org.apache.hive.hcatalog.listener.TestDbNotificationListener.createTable (batchId=221) org.apache.hive.service.cli.TestEmbeddedThriftBinaryCLIService.testExecuteStatementAsync (batchId=213) org.apache.hive.service.cli.thrift.TestThriftCLIServiceWithBinary.testExecuteStatementAsync (batchId=213) org.apache.hive.service.cli.thrift.TestThriftCLIServiceWithHttp.testExecuteStatementAsync (batchId=213) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3632/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3632/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3632/ 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: 35 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12853320 - PreCommit-HIVE-Build > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.02.patch, > HIVE-15938.patch > > > The problem is that the
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15872415#comment-15872415 ] Sergey Shelukhin commented on HIVE-15938: - union10 test was changed accidentally in the patch. Couple more tests failed that may be related, will take a look. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.01.patch, HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15871165#comment-15871165 ] Hive QA commented on HIVE-15938: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12853165/HIVE-15938.01.patch {color:green}SUCCESS:{color} +1 due to 5 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 39 failed/errored test(s), 10245 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constant_prop_1] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union10] (batchId=10) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=137) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr] (batchId=140) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=94) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_external_acid] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_not_acid] (batchId=86) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure1] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure2] (batchId=85) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[external1] (batchId=85) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=223) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] (batchId=223) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join31] (batchId=133) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union10] (batchId=100) org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testAlterTable (batchId=194) org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testTransactionalValidation (batchId=194) org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testAlterTable (batchId=197) org.apache.hadoop.hive.metastore.TestRemoteHiveMetaStore.testTransactionalValidation (batchId=197) org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterTable (batchId=193) org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTransactionalValidation (batchId=193) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testAlterTable (batchId=191) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyClient.testTransactionalValidation (batchId=191) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testAlterTable (batchId=202) org.apache.hadoop.hive.metastore.TestSetUGIOnOnlyServer.testTransactionalValidation (batchId=202) org.apache.hadoop.hive.ql.security.TestMetastoreAuthorizationProvider.testSimplePrivileges (batchId=210) org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProvider.testSimplePrivileges (batchId=208) org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProviderWithACL.testSimplePrivileges (batchId=220) org.apache.hive.beeline.TestBeeLineWithArgs.testQueryProgress (batchId=211) org.apache.hive.hcatalog.api.TestHCatClient.testBasicDDLCommands (batchId=170) org.apache.hive.hcatalog.api.TestHCatClient.testTransportFailure (batchId=170) org.apache.hive.hcatalog.listener.TestDbNotificationListener.createTable (batchId=221) org.apache.hive.service.cli.TestEmbeddedThriftBinaryCLIService.testExecuteStatementAsync (batchId=213) org.apache.hive.service.cli.thrift.TestThriftCLIServiceWithBinary.testExecuteStatementAsync (batchId=213) org.apache.hive.service.cli.thrift.TestThriftCLIServiceWithHttp.testExecuteStatementAsync (batchId=213) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/3614/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/3614/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-3614/ 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: 39 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12853165 - PreCommit-HIVE-Build > position alias in order by fails for union queries > -- > >
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870798#comment-15870798 ] Sergey Shelukhin commented on HIVE-15938: - Woops, actually the replacement code is completely screwed, creating ambiguous nodes. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870724#comment-15870724 ] Sergey Shelukhin commented on HIVE-15938: - Yeah, there's some weird issue with subqueries with union... the SA thinks newly added column names are ambiguous with something even though there's only one level and there was no ambiguity before. Looking. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15870344#comment-15870344 ] Ashutosh Chauhan commented on HIVE-15938: - seems like test for union-all + view is failing. > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15869628#comment-15869628 ] Hive QA commented on HIVE-15938: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12852963/HIVE-15938.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 86 failed/errored test(s), 10239 tests executed *Failed tests:* {noformat} TestDerbyConnector - did not produce a TEST-*.xml file (likely timed out) (batchId=235) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_partition_change_col] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_table_cascade] (batchId=80) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_1] (batchId=18) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[authorization_view_disable_cbo_1] (batchId=65) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_const] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_rp_auto_join1] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_union_view] (batchId=19) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[complex_alias] (batchId=16) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[concat_op] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constant_prop_1] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[create_view] (batchId=37) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_rdd_cache] (batchId=49) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_1_23] (batchId=72) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_sort_skew_1_23] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join31] (batchId=81) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[load_dyn_part13] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_2] (batchId=79) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_disablecbo_2] (batchId=41) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[merge4] (batchId=11) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[setop_subq] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp] (batchId=27) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_sort_array_by] (batchId=58) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union10] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union22] (batchId=13) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union37] (batchId=66) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_lateralview] (batchId=23) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_paren] (batchId=43) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_remove_15] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_remove_16] (batchId=67) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_remove_17] (batchId=63) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_remove_18] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_view] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionall_join_nullconstant] (batchId=36) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[unionall_unbalancedppd] (batchId=2) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_null_projection] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_cbo] (batchId=62) org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_join_with_different_encryption_keys] (batchId=159) org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_timestamp] (batchId=90) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=137) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[unionDistinct_1] (batchId=136) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_lineage2] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_unionDistinct_2] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage2] (batchId=149) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin1] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multiMapJoin2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multi_column_in] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[multi_column_in_single] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[ppd_union_view] (batchId=144) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez
[jira] [Commented] (HIVE-15938) position alias in order by fails for union queries
[ https://issues.apache.org/jira/browse/HIVE-15938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15869074#comment-15869074 ] Sergey Shelukhin commented on HIVE-15938: - [~ashutoshc] can you take a look? > position alias in order by fails for union queries > -- > > Key: HIVE-15938 > URL: https://issues.apache.org/jira/browse/HIVE-15938 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-15938.patch > > > The problem is that the query introduces a spurious ALLCOLREF -- This message was sent by Atlassian JIRA (v6.3.15#6346)