Toshihiko Uchida created HIVE-22453:
---------------------------------------

             Summary: Describe table unnecessarily fetches partitions
                 Key: HIVE-22453
                 URL: https://issues.apache.org/jira/browse/HIVE-22453
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.3.6, 3.1.2
            Reporter: Toshihiko Uchida


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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to