[jira] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Status: Patch Available (was: Open) > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Status: Open (was: Patch Available) > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Attachment: HIVE-21485.patch > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Attachment: (was: HIVE-21485.patch) > 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 > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Assignee: Qingxin Wu Status: Patch Available (was: Open) > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Attachment: HIVE-21485.patch > 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: 20m > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Attachment: (was: HIVE-21485.1.patch) > 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 > Time Spent: 20m > 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] [Updated] (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:all-tabpanel ] Qingxin Wu updated HIVE-21485: -- Attachment: HIVE-21485.1.patch > 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.1.patch > > Time Spent: 20m > 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] [Updated] (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:all-tabpanel ] ASF GitHub Bot updated HIVE-21485: -- Labels: pull-request-available (was: ) > 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 > > 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)