hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chaoyu Tang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-11786) Deprecate the use of redundant column in colunm stats related tables
Date Thu, 10 Sep 2015 14:07:45 GMT
Chaoyu Tang created HIVE-11786:
----------------------------------

             Summary: Deprecate the use of redundant column in colunm stats related tables
                 Key: HIVE-11786
                 URL: https://issues.apache.org/jira/browse/HIVE-11786
             Project: Hive
          Issue Type: Bug
          Components: Metastore
            Reporter: Chaoyu Tang
            Assignee: Chaoyu Tang


The stats tables such as TAB_COL_STATS, PART_COL_STATS have redundant columns such as DB_NAME,
TABLE_NAME, PARTITION_NAME since these tables already have foreign key like TBL_ID, or PART_ID
referencing to TBLS or PARTITIONS. 
These redundant columns violate database normalization rules and cause a lot of inconvenience
(sometimes difficult) in column stats related feature implementation. For example, when renaming
a table, we have to update TABLE_NAME column in these tables as well which is unnecessary.

This JIRA is first to deprecate the use of these columns at HMS code level. A followed JIRA
is to be opened to focus on DB schema change and upgrade.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message