[jira] [Commented] (HIVE-14959) Support distinct with windowing when CBO is disabled
[ https://issues.apache.org/jira/browse/HIVE-14959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15583107#comment-15583107 ] Ashutosh Chauhan commented on HIVE-14959: - +1 > Support distinct with windowing when CBO is disabled > > > Key: HIVE-14959 > URL: https://issues.apache.org/jira/browse/HIVE-14959 > Project: Hive > Issue Type: Bug >Affects Versions: 2.1.0 >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-14959.01.patch, HIVE-14959.patch > > > For instance, the following query with CBO off: > {code:sql} > select distinct last_value(i) over ( partition by si order by i ), > first_value(t) over ( partition by si order by i ) > from over10k limit 50; > {code} > will fail, with the following message: > {noformat} > SELECT DISTINCT not allowed in the presence of windowing functions when CBO > is off > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14959) Support distinct with windowing when CBO is disabled
[ https://issues.apache.org/jira/browse/HIVE-14959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15581548#comment-15581548 ] Jesus Camacho Rodriguez commented on HIVE-14959: [~ashutoshc], could you take a look? Thanks > Support distinct with windowing when CBO is disabled > > > Key: HIVE-14959 > URL: https://issues.apache.org/jira/browse/HIVE-14959 > Project: Hive > Issue Type: Bug >Affects Versions: 2.1.0 >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-14959.01.patch, HIVE-14959.patch > > > For instance, the following query with CBO off: > {code:sql} > select distinct last_value(i) over ( partition by si order by i ), > first_value(t) over ( partition by si order by i ) > from over10k limit 50; > {code} > will fail, with the following message: > {noformat} > SELECT DISTINCT not allowed in the presence of windowing functions when CBO > is off > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14959) Support distinct with windowing when CBO is disabled
[ https://issues.apache.org/jira/browse/HIVE-14959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15577407#comment-15577407 ] Hive QA commented on HIVE-14959: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12833456/HIVE-14959.01.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 10565 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[acid_globallimit] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[order_null] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_fast_stats] org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_bulk] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJarWithoutAddDriverClazz[0] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJar[0] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJar[1] org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthorization.testBlackListedUdfUsage {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1579/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1579/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-1579/ 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: 12833456 - PreCommit-HIVE-Build > Support distinct with windowing when CBO is disabled > > > Key: HIVE-14959 > URL: https://issues.apache.org/jira/browse/HIVE-14959 > Project: Hive > Issue Type: Bug >Affects Versions: 2.1.0 >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-14959.01.patch, HIVE-14959.patch > > > For instance, the following query with CBO off: > {code:sql} > select distinct last_value(i) over ( partition by si order by i ), > first_value(t) over ( partition by si order by i ) > from over10k limit 50; > {code} > will fail, with the following message: > {noformat} > SELECT DISTINCT not allowed in the presence of windowing functions when CBO > is off > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-14959) Support distinct with windowing when CBO is disabled
[ https://issues.apache.org/jira/browse/HIVE-14959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15575493#comment-15575493 ] Hive QA commented on HIVE-14959: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12833315/HIVE-14959.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 18 failed/errored test(s), 10523 tests executed *Failed tests:* {noformat} TestMiniLlapLocalCliDriver - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[acid_globallimit] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[distinct_windowing] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[order_null] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[reloadJar] org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union_fast_stats] org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_windowing_2] org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[windowing] org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[windowing] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJarWithoutAddDriverClazz[0] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJar[0] org.apache.hive.beeline.TestBeelineArgParsing.testAddLocalJar[1] org.apache.hive.jdbc.TestNoSaslAuth.org.apache.hive.jdbc.TestNoSaslAuth org.apache.hive.jdbc.authorization.TestHS2AuthzContext.org.apache.hive.jdbc.authorization.TestHS2AuthzContext org.apache.hive.jdbc.authorization.TestHS2AuthzSessionContext.org.apache.hive.jdbc.authorization.TestHS2AuthzSessionContext org.apache.hive.jdbc.authorization.TestJdbcMetadataApiAuth.org.apache.hive.jdbc.authorization.TestJdbcMetadataApiAuth org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthUDFBlacklist.testBlackListedUdfUsage org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthorization.org.apache.hive.jdbc.authorization.TestJdbcWithSQLAuthorization {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/1564/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/1564/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-1564/ 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: 18 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12833315 - PreCommit-HIVE-Build > Support distinct with windowing when CBO is disabled > > > Key: HIVE-14959 > URL: https://issues.apache.org/jira/browse/HIVE-14959 > Project: Hive > Issue Type: Bug >Affects Versions: 2.1.0 >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-14959.patch > > > For instance, the following query with CBO off: > {code:sql} > select distinct last_value(i) over ( partition by si order by i ), > first_value(t) over ( partition by si order by i ) > from over10k limit 50; > {code} > will fail, with the following message: > {noformat} > SELECT DISTINCT not allowed in the presence of windowing functions when CBO > is off > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)