Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22453

Describe table unnecessarily fetches partitions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.2, 2.3.6
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

        1. HIVE-22453.patch
          4 kB
          Toshihiko Uchida
        2. HIVE-22453.2.patch
          4 kB
          Toshihiko Uchida
        3. HIVE-22453.2.patch
          4 kB
          Toshihiko Uchida
        4. HIVE-22453.3.patch
          4 kB
          Vineet Garg
        5. HIVE-22453.4.patch
          4 kB
          Toshihiko Uchida

          Issue Links

            Activity

              People

              • Assignee:
                touchida Toshihiko Uchida
                Reporter:
                touchida Toshihiko Uchida
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: