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

Created the needed indexes on Hive.PART_COL_STATS for CBO

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 0.14.0
    • Component/s: CBO
    • Labels:
      None

      Description

      With CBO we need the correct set of indexes to provide an efficient Read/Write access.
      These indexes improve performance of Explain plan and Analyzed table by 60% and 300%.

      MySQL 
       CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME) USING BTREE;
      
      MsSQL
      CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME);
      
      Oracle 
      CREATE INDEX PART_COL_STATS_N50 ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME);
      
      Postgres
      CREATE INDEX "PART_COL_STATS_N50" ON "PART_COL_STATS" USING btree ("DB_NAME","TABLE_NAME","COLUMN_NAME");
      

        Attachments

        1. HIVE-7784.1.patch
          6 kB
          Mostafa Mokhtar
        2. HIVE-7784.2.patch
          8 kB
          Mostafa Mokhtar

          Activity

            People

            • Assignee:
              mmokhtar Mostafa Mokhtar
              Reporter:
              mmokhtar Mostafa Mokhtar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: