[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967147#comment-16967147 ] Hive QA commented on HIVE-21485: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12963994/HIVE-21485.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19290/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19290/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19290/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Tests exited with: NonZeroExitCodeException Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ date '+%Y-%m-%d %T.%3N' 2019-11-05 01:37:24.321 + [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]] + export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + export 'MAVEN_OPTS=-Xmx1g ' + MAVEN_OPTS='-Xmx1g ' + cd /data/hiveptest/working/ + tee /data/hiveptest/logs/PreCommit-HIVE-Build-19290/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z master ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-11-05 01:37:24.324 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 164b78b HIVE-22429: Migrated clustered tables using bucketing_version 1 on hive 3 uses bucketing_version 2 for inserts (Ramesh Kumar Thangarajan, reviewed by Jesus Camacho Rodriguez) + git clean -f -d Removing ${project.basedir}/ Removing itests/${project.basedir}/ Removing standalone-metastore/metastore-server/src/gen/ + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 164b78b HIVE-22429: Migrated clustered tables using bucketing_version 1 on hive 3 uses bucketing_version 2 for inserts (Ramesh Kumar Thangarajan, reviewed by Jesus Camacho Rodriguez) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-11-05 01:37:26.794 + rm -rf ../yetus_PreCommit-HIVE-Build-19290 + mkdir ../yetus_PreCommit-HIVE-Build-19290 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-19290 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-19290/yetus + patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hiveptest/working/scratch/build.patch + [[ -f /data/hiveptest/working/scratch/build.patch ]] + chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh + /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch error: ql/src/java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: does not exist in index error: patch failed: ql/src/test/results/clientpositive/describe_table.q.out:388 Falling back to three-way merge... Applied patch to 'ql/src/test/results/clientpositive/describe_table.q.out' with conflicts. error: src/java/org/apache/hadoop/hive/conf/HiveConf.java: does not exist in index error: src/java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: does not exist in index error: src/test/queries/clientpositive/describe_table.q: does not exist in index error: src/test/results/clientpositive/describe_table.q.out: does not exist in index error: java/org/apache/hadoop/hive/conf/HiveConf.java: does not exist in index error: java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: does not exist in index error: test/queries/clientpositive/describe_table.q: does not exist in index error: test/results/clientpositive/describe_table.q.out: does not exist in index The patch does not appear to apply with p0, p1, or p2 + result=1 + '[' 1 -ne 0 ']' + rm -rf yetus_PreCommit-HIVE-Build-19290 + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12963994 - PreCommit-HIVE-Build > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Priority: Major >
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16803865#comment-16803865 ] Hive QA commented on HIVE-21485: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12963994/HIVE-21485.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15877 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16733/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16733/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16733/ 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: 12963994 - PreCommit-HIVE-Build > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16803850#comment-16803850 ] Hive QA commented on HIVE-21485: | (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 53s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 49s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 37s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 1s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 40s{color} | {color:blue} common in master has 63 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 36s{color} | {color:blue} ql in master has 2256 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 22s{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} 2m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 39s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 39s{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 1 new + 1 unchanged - 0 fixed = 2 total (was 1) {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} 5m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 14s{color} | {color:red} The patch generated 7 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 32m 8s{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-16733/dev-support/hive-personality.sh | | git revision | master / 1e58bd2 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-16733/yetus/diff-checkstyle-ql.txt | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-16733/yetus/patch-asflicense-problems.txt | | modules | C: common ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-16733/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > id
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16801458#comment-16801458 ] Qingxin Wu commented on HIVE-21485: --- Yes, that's what I implement in this patch. Adding following parameter to skip this expensive step. {code:java} hive.display.partitioned.table.stats=true/false {code} > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Assignee: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799248#comment-16799248 ] star commented on HIVE-21485: - You can set parameter like set hive.display.partitioned.table.stats=false to skip showing partition stats. > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Assignee: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798980#comment-16798980 ] Hive QA commented on HIVE-21485: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12963387/HIVE-21485.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16632/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16632/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16632/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Tests exited with: NonZeroExitCodeException Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit status 1 and output '+ date '+%Y-%m-%d %T.%3N' 2019-03-22 12:44:24.662 + [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]] + export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 + export PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games + export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m ' + ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m ' + export 'MAVEN_OPTS=-Xmx1g ' + MAVEN_OPTS='-Xmx1g ' + cd /data/hiveptest/working/ + tee /data/hiveptest/logs/PreCommit-HIVE-Build-16632/source-prep.txt + [[ false == \t\r\u\e ]] + mkdir -p maven ivy + [[ git = \s\v\n ]] + [[ git = \g\i\t ]] + [[ -z master ]] + [[ -d apache-github-source-source ]] + [[ ! -d apache-github-source-source/.git ]] + [[ ! -d apache-github-source-source ]] + date '+%Y-%m-%d %T.%3N' 2019-03-22 12:44:24.668 + cd apache-github-source-source + git fetch origin + git reset --hard HEAD HEAD is now at 2fa22bf HIVE-21473: Bumping jackson version to 2.9.8 (Peter Vary, reviewed by Marta Kuczora) + git clean -f -d Removing standalone-metastore/metastore-server/src/gen/ + git checkout master Already on 'master' Your branch is up-to-date with 'origin/master'. + git reset --hard origin/master HEAD is now at 2fa22bf HIVE-21473: Bumping jackson version to 2.9.8 (Peter Vary, reviewed by Marta Kuczora) + git merge --ff-only origin/master Already up-to-date. + date '+%Y-%m-%d %T.%3N' 2019-03-22 12:44:26.322 + rm -rf ../yetus_PreCommit-HIVE-Build-16632 + mkdir ../yetus_PreCommit-HIVE-Build-16632 + git gc + cp -R . ../yetus_PreCommit-HIVE-Build-16632 + mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-16632/yetus + patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hiveptest/working/scratch/build.patch + [[ -f /data/hiveptest/working/scratch/build.patch ]] + chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh + /data/hiveptest/working/scratch/smart-apply-patch.sh /data/hiveptest/working/scratch/build.patch error: patch failed: common/src/java/org/apache/hadoop/hive/conf/HiveConf.java:3140 error: repository lacks the necessary blob to fall back on 3-way merge. error: common/src/java/org/apache/hadoop/hive/conf/HiveConf.java: patch does not apply error: patch failed: ql/src/java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java:114 error: repository lacks the necessary blob to fall back on 3-way merge. error: ql/src/java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: patch does not apply error: patch failed: ql/src/test/queries/clientpositive/describe_table.q:27 error: repository lacks the necessary blob to fall back on 3-way merge. error: ql/src/test/queries/clientpositive/describe_table.q: patch does not apply error: patch failed: ql/src/test/results/clientpositive/describe_table.q.out:388 error: repository lacks the necessary blob to fall back on 3-way merge. error: ql/src/test/results/clientpositive/describe_table.q.out: patch does not apply error: src/java/org/apache/hadoop/hive/conf/HiveConf.java: does not exist in index error: src/java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: does not exist in index error: src/test/queries/clientpositive/describe_table.q: does not exist in index error: src/test/results/clientpositive/describe_table.q.out: does not exist in index error: java/org/apache/hadoop/hive/conf/HiveConf.java: does not exist in index error: java/org/apache/hadoop/hive/ql/ddl/table/DescTableOperation.java: does not exist in index error: test/queries/clientpositive/describe_table.q: does not exist in index error: test/results/clientpositive/describe_table.q.out: does not exist in index The patch does not appear to apply with p0, p1, or p2 + result=1 + '[' 1 -ne 0 ']' + rm -rf yetus_PreCommit-HIVE-Build-16632 + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12963387 - PreCommit-HIVE-Build > Hive desc operation takes more than 100 seconds a
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798901#comment-16798901 ] Qingxin Wu commented on HIVE-21485: --- Hi [~starphin], The reason why we keep so many partitions is due to important historical data. And I think we should deal with it properly. The patch was uploaded. Could you please take a look at it? > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Assignee: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798885#comment-16798885 ] Qingxin Wu commented on HIVE-21485: --- cc [~ashutoshc] > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Assignee: Qingxin Wu >Priority: Major > Labels: pull-request-available > Attachments: HIVE-21485.patch > > Time Spent: 40m > Remaining Estimate: 0h > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21485) Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
[ https://issues.apache.org/jira/browse/HIVE-21485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798594#comment-16798594 ] star commented on HIVE-21485: - Maybe table with so much partition is not a good practice. > Hive desc operation takes more than 100 seconds after upgrading from Hive > 1.2.1 to 2.3.4 > > > Key: HIVE-21485 > URL: https://issues.apache.org/jira/browse/HIVE-21485 > Project: Hive > Issue Type: Bug > Components: CLI, Hive >Affects Versions: 2.3.4 >Reporter: Qingxin Wu >Priority: Major > > Hive desc [formatted|extended] operation cost more than 100 seconds after > upgrading from Hive 1.2.1 to 2.3.4. This is mainly caused by showing stats > for partitioned tables which was introduced by HIVE-16098 when the > partitioned tables have a large amount of partitions. In our case, the number > of partition is 187221. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 115.342 seconds, Fetched: 42 row(s) > {code} > same operation executed in hive-1.2.1 and only cost 2 seconds. > {code:java} > hive> desc bus.kafka_data; > OK > idstring > ... > d map > stat_date string > log_idstring > # Partition Information > # col_namedata_type comment > stat_date string > log_idstring > Time taken: 2.037 seconds, Fetched: 42 row(s) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)