Hive
  1. Hive
  2. HIVE-7784

Created the needed indexes on Hive.PART_COL_STATS for CBO

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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");
      
      1. HIVE-7784.1.patch
        6 kB
        Mostafa Mokhtar
      2. HIVE-7784.2.patch
        8 kB
        Mostafa Mokhtar

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development