[HIVE-22453] Describe table unnecessarily fetches partitions

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.3.6, 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Toshihiko Uchida Assign to me
• Reporter: Toshihiko Uchida
• Created: 04/Nov/19 19:08
• Updated: 02/Apr/23 19:48
• Resolved: 28/Feb/20 19:49

Description

The simple describe table command without EXTENDED and FORMATTED (i.e., DESCRIBE table_name) fetches all partitions when no partition is specified, although it does not display partition statistics in nature.
The command should not fetch partitions since it can take a long time for a large amount of partitions.
For instance, in our environment, the command takes around 8 seconds for a table with 8760 (24 * 365) partitions.

Issue Links

• is related to: HIVE-24964 Backport HIVE-22453: Describe table unnecessarily fetches partitions
• is related to: HIVE-21485 Hive desc operation takes more than 100 seconds after upgrading from Hive 1.2.1 to 2.3.4
• is related to: HIVE-24965 Describe table partition stats fetch should be configurable
• relates to: HIVE-27211 Backport HIVE-22453: Describe table unnecessarily fetches partitions to branch-3
• links to: GitHub Pull Request #2140
• links to: GitHub Pull Request #2142