[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984040#comment-16984040 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12986925/HIVE-22379.7.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 17750 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19644/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19644/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19644/ 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: 12986925 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, > HIVE-22379.6.patch, HIVE-22379.7.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16984010#comment-16984010 ] Hive QA commented on HIVE-22379: | (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:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 58s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 53s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 14s{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} 1m 19s{color} | {color:blue} standalone-metastore/metastore-server in master has 179 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 48s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 48s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 28s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 13s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 13s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 22s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 5 new + 379 unchanged - 2 fixed = 384 total (was 381) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 18s{color} | {color:red} itests/hive-unit: The patch generated 10 new + 120 unchanged - 8 fixed = 130 total (was 128) {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} 2m 15s{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:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 22s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19644/dev-support/hive-personality.sh | | git revision | master / 4535916 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19644/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19644/yetus/diff-checkstyle-itests_hive-unit.txt | | modules | C: standalone-metastore/metastore-server itests/hive-unit U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19644/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, > HIVE-22379.6.patch, HIVE-22379.7.patch > > >
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983180#comment-16983180 ] Rajesh Balamohan commented on HIVE-22379: - LGTM. +1. Plz remove commented out "msdb.getPartition" before check in. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, HIVE-22379.6.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16983086#comment-16983086 ] mahesh kumar behera commented on HIVE-22379: [~rajesh.balamohan] Can you please review the patch. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, HIVE-22379.6.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982939#comment-16982939 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12986752/HIVE-22379.6.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 17746 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19621/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19621/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19621/ 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: 12986752 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, HIVE-22379.6.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982857#comment-16982857 ] Hive QA commented on HIVE-22379: | (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:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 2m 8s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 12s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 16s{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} 1m 14s{color} | {color:blue} standalone-metastore/metastore-server in master has 179 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 46s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 31s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 12s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 12s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 25s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 5 new + 379 unchanged - 2 fixed = 384 total (was 381) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 19s{color} | {color:red} itests/hive-unit: The patch generated 10 new + 120 unchanged - 8 fixed = 130 total (was 128) {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} 2m 27s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 51s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19621/dev-support/hive-personality.sh | | git revision | master / 9c06b2c | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19621/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19621/yetus/diff-checkstyle-itests_hive-unit.txt | | modules | C: standalone-metastore/metastore-server itests/hive-unit U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19621/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch, HIVE-22379.6.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16980689#comment-16980689 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12986509/HIVE-22379.5.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 17715 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate (batchId=249) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19560/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19560/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19560/ 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: 12986509 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16980682#comment-16980682 ] Hive QA commented on HIVE-22379: | (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 1s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 2m 4s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 25s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 15s{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} 1m 22s{color} | {color:blue} standalone-metastore/metastore-server in master has 178 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 47s{color} | {color:blue} itests/hive-unit in master has 2 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:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 30s{color} | {color:blue} Maven dependency ordering for patch {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 22s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 22s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 22s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 5 new + 378 unchanged - 3 fixed = 383 total (was 381) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 21s{color} | {color:red} itests/hive-unit: The patch generated 10 new + 268 unchanged - 8 fixed = 278 total (was 276) {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} 2m 20s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 50s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19560/dev-support/hive-personality.sh | | git revision | master / d6ae486 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19560/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19560/yetus/diff-checkstyle-itests_hive-unit.txt | | modules | C: standalone-metastore/metastore-server itests/hive-unit U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19560/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch, HIVE-22379.5.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16977531#comment-16977531 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12986198/HIVE-22379.4.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 17707 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningInsert (batchId=249) org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate (batchId=249) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19494/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19494/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19494/ 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: 12986198 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16977495#comment-16977495 ] Hive QA commented on HIVE-22379: | (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:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 57s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 11s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 16s{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} 1m 15s{color} | {color:blue} standalone-metastore/metastore-server in master has 178 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 46s{color} | {color:blue} itests/hive-unit in master has 2 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 48s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 27s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 24s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 13s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 13s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 5 new + 378 unchanged - 3 fixed = 383 total (was 381) {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} itests/hive-unit: The patch generated 10 new + 120 unchanged - 8 fixed = 130 total (was 128) {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} 2m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 54s{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} 22m 50s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19494/dev-support/hive-personality.sh | | git revision | master / 44697f0 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19494/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19494/yetus/diff-checkstyle-itests_hive-unit.txt | | modules | C: standalone-metastore/metastore-server itests/hive-unit U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19494/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16965664#comment-16965664 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12984714/HIVE-22379.4.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), 17546 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningInsert (batchId=248) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19272/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19272/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19272/ 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: 12984714 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Assignee: mahesh kumar behera >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch, HIVE-22379.4.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16962013#comment-16962013 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12984237/HIVE-22379.3.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 17546 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testBootstrapReplLoadRetryAfterFailureForPartitions (batchId=261) org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testMoveOptimizationIncrementalFailureAfterCopy (batchId=261) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testBootstrapReplLoadRetryAfterFailureForPartitions (batchId=265) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testMoveOptimizationIncrementalFailureAfterCopy (batchId=265) org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate (batchId=248) org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.testDisableCompactionDuringReplLoad (batchId=248) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19190/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19190/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19190/ 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: 12984237 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961949#comment-16961949 ] Hive QA commented on HIVE-22379: | (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 34s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 26s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 21s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 8s{color} | {color:blue} standalone-metastore/metastore-server in master has 171 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 20s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 26s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 26s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 22s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 4 new + 375 unchanged - 3 fixed = 379 total (was 378) {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} 1m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 19s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 14m 26s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19190/dev-support/hive-personality.sh | | git revision | master / aceb8b6 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19190/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server U: standalone-metastore/metastore-server | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19190/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961877#comment-16961877 ] Rajesh Balamohan commented on HIVE-22379: - Uploaded revised patch. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch, > HIVE-22379.3.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961690#comment-16961690 ] Rajesh Balamohan commented on HIVE-22379: - Not sure why replication tests are failing in this case. \cc [~maheshk114] > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16957420#comment-16957420 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12983731/HIVE-22379.2.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 17 failed/errored test(s), 17545 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.parse.TestReplAcidTablesWithJsonMessage.testAcidTablesBootstrap (batchId=269) org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testBootstrapReplLoadRetryAfterFailureForPartitions (batchId=261) org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testMoveOptimizationIncrementalFailureAfterCopy (batchId=261) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=267) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcidTables.testAcidTablesBootstrap (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testBootstrapReplLoadRetryAfterFailureForPartitions (batchId=265) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testMoveOptimizationIncrementalFailureAfterCopy (batchId=265) org.apache.hadoop.hive.ql.parse.TestReplicationScenariosIncrementalLoadAcidTables.testAcidTableIncrementalReplication (batchId=272) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=256) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACID.testForParallelBootstrapLoad (batchId=254) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACID.testNonParallelBootstrapLoad (batchId=254) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACID.testRetryFailure (batchId=254) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACIDNoAutogather.testForParallelBootstrapLoad (batchId=255) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACIDNoAutogather.testNonParallelBootstrapLoad (batchId=255) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosACIDNoAutogather.testRetryFailure (batchId=255) org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningInsert (batchId=248) org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate (batchId=248) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19112/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19112/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19112/ 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: 17 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12983731 - PreCommit-HIVE-Build > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16957380#comment-16957380 ] Hive QA commented on HIVE-22379: | (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} 9m 8s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 28s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 24s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 13s{color} | {color:blue} standalone-metastore/metastore-server in master has 171 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 22s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 29s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 29s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 4 new + 375 unchanged - 3 fixed = 379 total (was 378) {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} 1m 23s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 21s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 15m 25s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19112/dev-support/hive-personality.sh | | git revision | master / f1e59e9 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19112/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server U: standalone-metastore/metastore-server | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19112/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch, HIVE-22379.2.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16956815#comment-16956815 ] Hive QA commented on HIVE-22379: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12983683/HIVE-22379.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 45 failed/errored test(s), 17542 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeDbName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeDbName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeTableName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeTableName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeValues[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionChangeValues[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionUnknownPartition[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionUnknownPartition[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeDbName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeDbName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeTableName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeTableName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeValues[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxChangeValues[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxUnknownPartition[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionWithEnvironmentCtxUnknownPartition[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeDbName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeDbName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeTableName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeTableName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeValues[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsChangeValues[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsUnknownPartition[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsUnknownPartition[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeDbName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeDbName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeTableName[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeTableName[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeValues[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxChangeValues[Remote] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxUnknownPartition[Embedded] (batchId=225) org.apache.hadoop.hive.metastore.client.TestAlterPartitions.testAlterPartitionsWithEnvironmentCtxUnknownPartition[Remote] (batchId=225) org.apache.hadoop.hive.ql.parse.TestReplAcidTablesWithJsonMessage.testAcidTablesBootstrap (batchId=269) org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testBootstrapReplLoadRetryAfterFailureForPartitions (batchId=261) org.apache.hadoop.hive.ql.parse.TestReplAcrossInstancesWithJsonMessageFormat.testMoveOptimizationIncrementalFailureAfterCopy (batchId=261)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16956789#comment-16956789 ] Hive QA commented on HIVE-22379: | (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 34s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 28s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 21s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 8s{color} | {color:blue} standalone-metastore/metastore-server in master has 171 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 20s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 30s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 26s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 26s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 4 new + 375 unchanged - 3 fixed = 379 total (was 378) {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} 1m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 19s{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} 14m 28s{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.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-19101/dev-support/hive-personality.sh | | git revision | master / 40cd40d | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-19101/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server U: standalone-metastore/metastore-server | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-19101/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Labels: performance > Attachments: HIVE-22379.1.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22379) Reduce db lookups during dynamic partition loading
[ https://issues.apache.org/jira/browse/HIVE-22379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16956622#comment-16956622 ] Rajesh Balamohan commented on HIVE-22379: - Observed 10+ second difference in local cluster setup with dynamic partition load. > Reduce db lookups during dynamic partition loading > -- > > Key: HIVE-22379 > URL: https://issues.apache.org/jira/browse/HIVE-22379 > Project: Hive > Issue Type: Improvement >Reporter: Rajesh Balamohan >Priority: Major > Attachments: HIVE-22379.1.patch > > > {{HiveAlterHandler::alterPartitions}} could lookup all partition details via > single call instead of multiple lookups. -- This message was sent by Atlassian Jira (v8.3.4#803005)