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

TAB_COL_STATS table has no index on db/table name

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4.0, 3.1.0, 4.0.0
    • Component/s: Metastore
    • Labels:
      None

      Description

      The TAB_COL_STATS table is missing an index on (CAT_NAME, DB_NAME, TABLE_NAME). The getTableColumnStatistics call queries based on this tuple. This makes those queries take a significant amount of time in large metastores since they do a full table scan.

        Attachments

        1. HIVE-19605.01.patch
          15 kB
          Vihang Karajgaonkar
        2. HIVE-19605.02.patch
          15 kB
          Vihang Karajgaonkar
        3. HIVE-19605.03-branch-2.patch
          10 kB
          Vihang Karajgaonkar
        4. HIVE-19605.04-branch-2-addendum.patch
          4 kB
          Vihang Karajgaonkar

          Issue Links

            Activity

              People

              • Assignee:
                vihangk1 Vihang Karajgaonkar
                Reporter:
                tlipcon Todd Lipcon
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: