[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17768567#comment-17768567 ] Stamatis Zampetakis commented on HIVE-19770: The missing lineage information due to constant folding reported [in a comment above|https://issues.apache.org/jira/browse/HIVE-19770?focusedCommentId=16498684=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-16498684] is tracked under HIVE-27726. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Fix For: 4.0.0-alpha-1 > > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch, HIVE-19770.8.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16561238#comment-16561238 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12933524/HIVE-19770.8.patch {color:green}SUCCESS:{color} +1 due to 3 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 14815 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12932/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12932/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12932/ 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: 12933524 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch, HIVE-19770.8.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16561223#comment-16561223 ] Hive QA commented on HIVE-19770: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 23s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 8s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 42s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 14s{color} | {color:blue} ql in master has 2297 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 2s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 29s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 6s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 6s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 41s{color} | {color:red} ql: The patch generated 13 new + 199 unchanged - 1 fixed = 212 total (was 200) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 0s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 44s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-12932/dev-support/hive-personality.sh | | git revision | master / 2183424 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-12932/yetus/diff-checkstyle-ql.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-12932/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch, HIVE-19770.8.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16560707#comment-16560707 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12933444/HIVE-19770.7.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 14813 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12917/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12917/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12917/ 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: 12933444 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16560691#comment-16560691 ] Hive QA commented on HIVE-19770: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 46s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 9s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 43s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 14s{color} | {color:blue} ql in master has 2297 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 1s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 27s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 43s{color} | {color:red} ql: The patch generated 13 new + 199 unchanged - 1 fixed = 212 total (was 200) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 36s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 25m 45s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-12917/dev-support/hive-personality.sh | | git revision | master / 188f4ea | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-12917/yetus/diff-checkstyle-ql.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-12917/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16560637#comment-16560637 ] Ashutosh Chauhan commented on HIVE-19770: - [~vgarg] Can you add test case from HIVE-20215 in this patch now that this patch incorporates it. Also, can you create follow-up jiras for perf issues. +1 pending tests. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, > HIVE-19770.6.patch, HIVE-19770.7.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16552211#comment-16552211 ] Vineet Garg commented on HIVE-19770: [~ashutoshc] [~jcamachorodriguez] Can you take a look? Review Board: https://reviews.apache.org/r/68011/ TestMiniDruidCliDriver is unrelated (HIVE-19636) > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, HIVE-19770.6.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551655#comment-16551655 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12932496/HIVE-19770.6.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 14674 tests executed *Failed tests:* {noformat} TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=192) [druidmini_dynamic_partition.q,druidmini_expressions.q,druidmini_test_alter.q,druidmini_test1.q,druidmini_test_insert.q] {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12762/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12762/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12762/ 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 Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12932496 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, HIVE-19770.6.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551639#comment-16551639 ] Hive QA commented on HIVE-19770: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 28s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 5s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 40s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 0s{color} | {color:blue} ql in master has 2280 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 0s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 26s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 40s{color} | {color:green} ql: The patch generated 0 new + 171 unchanged - 1 fixed = 171 total (was 172) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 13s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 24m 31s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-12762/dev-support/hive-personality.sh | | git revision | master / e569ef0 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-12762/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, HIVE-19770.6.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551271#comment-16551271 ] Vineet Garg commented on HIVE-19770: Earlier patch removed the same column restriction from CBO path and added ambiguity check (same as non-cbo path). But it turns out that ambiguity check is too restrictive e.g. queries like {code:sql} select count(*) from (select key, key from src) subq {code} is not allowed with this check. There are also queries which were successfully planned by CBO but now with this check are not allowed e.g. {code:sql} select count(*) from (select t1.key, t2.key from src t1 inner join src t2 on t1.key=t2.key)subq {code} Therefore I have removed the ambiguity check for now and opened HIVE-20215 for fix this. Fixing this will require checking ambiguity during column reference instead of generating column list for select. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch, HIVE-19770.6.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551159#comment-16551159 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12932339/HIVE-19770.5.patch {color:green}SUCCESS:{color} +1 due to 3 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 14679 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[bucketsortoptimize_insert_4] (batchId=26) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_reflect2] (batchId=16) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_dynamic_partition_pruning_3] (batchId=187) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[vector_outer_join5] (batchId=188) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[ambiguous_col] (batchId=97) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[bucketsortoptimize_insert_4] (batchId=120) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12738/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12738/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12738/ 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 Tests exited with: TestsFailedException: 6 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12932339 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16551121#comment-16551121 ] Hive QA commented on HIVE-19770: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 10s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 10s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 41s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 6s{color} | {color:blue} ql in master has 2281 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 28s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 5s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 5s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 41s{color} | {color:green} ql: The patch generated 0 new + 171 unchanged - 1 fixed = 171 total (was 172) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 9s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 24m 30s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-12738/dev-support/hive-personality.sh | | git revision | master / 06a4f98 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-12738/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch, HIVE-19770.5.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16516493#comment-16516493 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12928135/HIVE-19770.4.patch {color:green}SUCCESS:{color} +1 due to 3 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 14 failed/errored test(s), 14456 tests executed *Failed tests:* {noformat} TestBeeLineExceptionHandling - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestBeeLineHistory - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestBeelineArgParsing - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestClientCommandHookFactory - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestHiveCli - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestHiveSchemaTool - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestIncrementalRows - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestShutdownHook - did not produce a TEST-*.xml file (likely timed out) (batchId=193) TestTableOutputFormat - did not produce a TEST-*.xml file (likely timed out) (batchId=193) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_mapjoin] (batchId=59) org.apache.hadoop.hive.cli.TestMiniDruidKafkaCliDriver.testCliDriver[druidkafkamini_basic] (batchId=257) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_mapjoin] (batchId=168) org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[vector_outer_join5] (batchId=186) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_decimal_mapjoin] (batchId=132) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/11902/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11902/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11902/ 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 Tests exited with: TestsFailedException: 14 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12928135 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16516464#comment-16516464 ] Hive QA commented on HIVE-19770: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 8s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 7s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 42s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 7s{color} | {color:blue} ql in master has 2280 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 28s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 42s{color} | {color:green} ql: The patch generated 0 new + 170 unchanged - 1 fixed = 170 total (was 171) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 24m 32s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-11902/dev-support/hive-personality.sh | | git revision | master / cf2e185 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-11902/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch, > HIVE-19770.3.patch, HIVE-19770.4.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16510315#comment-16510315 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12927393/HIVE-19770.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 14521 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=152) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[ambiguous_col] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure5] (batchId=96) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[bucketsortoptimize_insert_4] (batchId=119) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union_remove_22] (batchId=143) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/11739/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11739/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11739/ 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 Tests exited with: TestsFailedException: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12927393 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16510243#comment-16510243 ] Hive QA commented on HIVE-19770: | (/) *{color:green}+1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 6s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 2s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 39s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 4s{color} | {color:blue} ql in master has 2279 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 4s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 4s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 39s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 7s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 47s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-11739/dev-support/hive-personality.sh | | git revision | master / 230ae36 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-11739/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16508890#comment-16508890 ] Vineet Garg commented on HIVE-19770: Also found an existing bug (HIVE-19863) which is fixed by this patch. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1650#comment-1650 ] Vineet Garg commented on HIVE-19770: bq. One query has different (worse) plan (it now has cbo + vectorization) and new plan for some reason contains extra reducer. The root cause for this has yet to be determined but this should not introduce correctness issues. This query consist of group by + bunch of PTF operations. Earlier in non-cbo PTF was done on reduce side because mapper partition key was same as PTF key but now PTF is done in separate vertex/reducer because partition key is changed to contain all group by keys. Semantically this is correct but not optimized. I'll open a JIRA to track this. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch, HIVE-19770.2.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16502401#comment-16502401 ] Hive QA commented on HIVE-19770: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12926191/HIVE-19770.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 13 failed/errored test(s), 14466 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainanalyze_2] (batchId=171) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_join_transpose] (batchId=159) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_nonvec_part_all_primitive_llap_io] (batchId=175) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_nonvec_table] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_vec_part] (batchId=173) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_nonvec_table_llap_io] (batchId=172) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[varchar_udf1] (batchId=158) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_udf1] (batchId=169) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[ambiguous_col] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure5] (batchId=96) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[bucketsortoptimize_insert_4] (batchId=119) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union_remove_22] (batchId=143) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/11531/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11531/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11531/ 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 Tests exited with: TestsFailedException: 13 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12926191 - PreCommit-HIVE-Build > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16502350#comment-16502350 ] Hive QA commented on HIVE-19770: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 6m 37s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 55s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 39s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 26s{color} | {color:blue} ql in master has 2280 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 49s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 57s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 38s{color} | {color:red} ql: The patch generated 2 new + 647 unchanged - 0 fixed = 649 total (was 647) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 3m 37s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 48s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 11s{color} | {color:red} The patch generated 2 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 20m 33s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-11531/dev-support/hive-personality.sh | | git revision | master / 98982e6 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-11531/yetus/diff-checkstyle-ql.txt | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-11531/yetus/patch-asflicense-problems.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-11531/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19770) Support for CBO for queries with multiple same columns in select
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16498684#comment-16498684 ] Vineet Garg commented on HIVE-19770: Attached is first patch which provide CBO support for queries with multiple same column in select. Following are the known changes/effects: * Change in row schema: queries with multiple same column in select now has slightly different row scheme .e.g select c, c .. will have c, c_1 instead of c, c. I think this is probably because we losses the information about duplicate columns once calcite plan is rewritten to AST. This info is displayed in post hook of qtest and as far as I can tell it is a safe change. * One query has different (worse) plan (it now has cbo + vectorization) and new plan for some reason contains extra reducer. The root cause for this has yet to be determined but this should not introduce correctness issues. * Bunch of queries are missing lineage information (displayed in posthook). This is due to constant folding happening in CBO. e.g. insert into select a,b from t1 where b=1. column corresponding to B will have lineage info missing because reference to B is foled to 1. Not sure if this is acceptable/expected for lineage. > Support for CBO for queries with multiple same columns in select > > > Key: HIVE-19770 > URL: https://issues.apache.org/jira/browse/HIVE-19770 > Project: Hive > Issue Type: Improvement >Reporter: Vineet Garg >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19770.1.patch > > > Currently queries such as {code:sql} select a,a from t1 where b > 10 {code} > are not supported for CBO. -- This message was sent by Atlassian JIRA (v7.6.3#76005)