hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-22453) Describe table unnecessarily fetches partitions
Date Fri, 14 Feb 2020 01:18:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-22453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vineet Garg updated HIVE-22453:
-------------------------------
    Status: Open  (was: Patch Available)

> 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
>            Assignee: Toshihiko Uchida
>            Priority: Minor
>         Attachments: HIVE-22453.2.patch, HIVE-22453.2.patch, HIVE-22453.3.patch, HIVE-22453.patch
>
>
> 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)

Mime
View raw message