[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790517#comment-16790517 ] Shawn Weeks commented on HIVE-20590: Isn't this a duplicate of HIVE-17061? > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch, HIVE-20590.05.patch, HIVE-20590.06.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648202#comment-16648202 ] Hive QA commented on HIVE-20590: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12943268/HIVE-20590.06.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15078 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14388/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14388/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14388/ 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: 12943268 - PreCommit-HIVE-Build > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch, HIVE-20590.05.patch, HIVE-20590.06.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16648135#comment-16648135 ] Hive QA commented on HIVE-20590: | (/) *{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} 7m 58s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 44s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 56s{color} | {color:blue} ql in master has 2319 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 22s{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 43s{color} | {color:green} ql: The patch generated 0 new + 617 unchanged - 13 fixed = 617 total (was 630) {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} ql generated 0 new + 2318 unchanged - 1 fixed = 2318 total (was 2319) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{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 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-14388/dev-support/hive-personality.sh | | git revision | master / 24f7d24 | | 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-14388/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch, HIVE-20590.05.patch, HIVE-20590.06.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16644754#comment-16644754 ] Hive QA commented on HIVE-20590: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12942978/HIVE-20590.05.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 3 failed/errored test(s), 15070 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stat_estimate_related_col] (batchId=43) org.apache.hadoop.hive.ql.exec.spark.TestSparkSessionTimeout.testMultiSessionSparkSessionTimeout (batchId=246) org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testKillQuery (batchId=252) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14346/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14346/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14346/ 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: 3 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12942978 - PreCommit-HIVE-Build > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch, HIVE-20590.05.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16644672#comment-16644672 ] Hive QA commented on HIVE-20590: | (/) *{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 15s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 6s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 44s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 46s{color} | {color:blue} ql in master has 2319 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 57s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 20s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 2s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 2s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 43s{color} | {color:green} ql: The patch generated 0 new + 617 unchanged - 13 fixed = 617 total (was 630) {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} ql generated 0 new + 2318 unchanged - 1 fixed = 2318 total (was 2319) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{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 40s{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-14346/dev-support/hive-personality.sh | | git revision | master / 90e1228 | | 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-14346/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch, HIVE-20590.05.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16642806#comment-16642806 ] Ashutosh Chauhan commented on HIVE-20590: - We need a clean run. So, you need to reattach a patch to get that. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16641569#comment-16641569 ] Miklos Gergely commented on HIVE-20590: --- Rest of the failing tests are unrelated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639208#comment-16639208 ] Hive QA commented on HIVE-20590: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12942403/HIVE-20590.04.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 15026 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.exec.spark.TestSparkSessionTimeout.testMultiSparkSessionTimeout (batchId=246) org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testKillQuery (batchId=252) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14243/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14243/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14243/ 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: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12942403 - PreCommit-HIVE-Build > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639179#comment-16639179 ] Hive QA commented on HIVE-20590: | (/) *{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 32s{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 42s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 59s{color} | {color:blue} ql in master has 2320 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 34s{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:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 46s{color} | {color:green} ql: The patch generated 0 new + 617 unchanged - 13 fixed = 617 total (was 630) {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 16s{color} | {color:green} ql generated 0 new + 2319 unchanged - 1 fixed = 2319 total (was 2320) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{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} 24m 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-14243/dev-support/hive-personality.sh | | git revision | master / f0434c5 | | 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-14243/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16639078#comment-16639078 ] Ashutosh Chauhan commented on HIVE-20590: - +1 pending tests. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch, > HIVE-20590.04.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16638051#comment-16638051 ] Hive QA commented on HIVE-20590: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12942298/HIVE-20590.03.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 15010 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[stat_estimate_related_col] (batchId=43) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udaf_histogram_numeric] (batchId=14) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[cttl] (batchId=154) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_into_default_keyword] (batchId=158) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14223/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14223/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14223/ 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: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12942298 - PreCommit-HIVE-Build > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16638005#comment-16638005 ] Hive QA commented on HIVE-20590: | (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 29s{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 46s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 57s{color} | {color:blue} ql in master has 2321 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 23s{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 45s{color} | {color:green} ql: The patch generated 0 new + 617 unchanged - 13 fixed = 617 total (was 630) {color} | | {color:red}-1{color} | {color:red} whitespace {color} | {color:red} 0m 0s{color} | {color:red} The patch has 2 line(s) that end in whitespace. Use git apply --whitespace=fix <>. Refer https://git-scm.com/docs/git-apply {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 4m 7s{color} | {color:green} ql generated 0 new + 2320 unchanged - 1 fixed = 2320 total (was 2321) {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} 24m 13s{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-14223/dev-support/hive-personality.sh | | git revision | master / e96ea66 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | whitespace | http://104.198.109.242/logs//PreCommit-HIVE-Build-14223/yetus/whitespace-eol.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14223/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch, HIVE-20590.03.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16636170#comment-16636170 ] Hive QA commented on HIVE-20590: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12942109/HIVE-20590.01.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 15006 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testKillQuery (batchId=252) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14184/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14184/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14184/ 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: 12942109 - PreCommit-HIVE-Build > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20590) Allow merge statement to have column schema
[ https://issues.apache.org/jira/browse/HIVE-20590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16636126#comment-16636126 ] Hive QA commented on HIVE-20590: | (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 32s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 4s{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 1s{color} | {color:blue} ql in master has 2321 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 58s{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:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 41s{color} | {color:red} ql: The patch generated 12 new + 150 unchanged - 8 fixed = 162 total (was 158) {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 6s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{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} 24m 16s{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-14184/dev-support/hive-personality.sh | | git revision | master / 499539f | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-14184/yetus/diff-checkstyle-ql.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14184/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Allow merge statement to have column schema > --- > > Key: HIVE-20590 > URL: https://issues.apache.org/jira/browse/HIVE-20590 > Project: Hive > Issue Type: Improvement > Components: Transactions >Reporter: Vineet Garg >Assignee: Miklos Gergely >Priority: Major > Attachments: HIVE-20590.01.patch > > > Currently MERGE statement doesn't let user specify column schema with INSERT > statements, therefore DEFAULT constraint are not applicable with it. -- This message was sent by Atlassian JIRA (v7.6.3#76005)