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

TAB_COL_STATS table has no index on db/table name

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0, 2.4.0, 4.0.0-alpha-1
    • Metastore
    • 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.04-branch-2-addendum.patch
          4 kB
          Vihang Karajgaonkar
        2. HIVE-19605.03-branch-2.patch
          10 kB
          Vihang Karajgaonkar
        3. HIVE-19605.02.patch
          15 kB
          Vihang Karajgaonkar
        4. HIVE-19605.01.patch
          15 kB
          Vihang Karajgaonkar

        Issue Links

          is blocked by

          Task - A task that needs to be done. HIVE-19323 Create metastore SQL install and upgrade scripts for 3.1

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-19310 Metastore: MetaStoreDirectSql.ensureDbInit has some slow DN calls which might need to be run only in test env

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: