hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <>
Subject [jira] [Created] (HIVE-6190) redundant columns in metastore schema for stats
Date Mon, 13 Jan 2014 19:43:50 GMT
Sergey Shelukhin created HIVE-6190:

             Summary: redundant columns in metastore schema for stats
                 Key: HIVE-6190
             Project: Hive
          Issue Type: Bug
          Components: Metastore
            Reporter: Sergey Shelukhin
            Assignee: Sergey Shelukhin
            Priority: Minor

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

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.

This message was sent by Atlassian JIRA

View raw message