[HIVE-6190] redundant columns in metastore schema for stats

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 4.1.0
• Component/s: Metastore
• Assignee: Sergey Shelukhin
• Reporter: Sergey Shelukhin
• Created: 13/Jan/14 19:42
• Updated: 09/Apr/24 14:53
• Resolved: 09/Apr/24 14:53

Description

package.jdo has:

      <field name ="dbName">
        <column name="DB_NAME" length="128" jdbc-type="VARCHAR" allows-null="false"/>
      </field>
      <field name="tableName">
        <column name="TABLE_NAME" length="128" jdbc-type="VARCHAR" allows-null="false"/>
      </field>
      <field name="partitionName">
        <column name="PARTITION_NAME" length="767" jdbc-type="VARCHAR" allows-null="false"/>
      </field>
      <field name="partition">
        <column name="PART_ID"/>
      </field>

Only PART_ID is enough, the other fields are unnecessary and may potentially cause bugs; similarly for table stats. One could argue that they were intended for perf (denormalization), but stats retrieval currently is very slow on much deeper level so it's not really justified.

Issue Links

• is related to: HIVE-27725 Remove redundant columns in TAB_COL_STATS and PART_COL_STATS