[HIVE-8734] Renaming tables leaves stat store in stale state

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Metastore
• Assignee: Unassigned
• Reporter: Ryan Pridgeon
• Created: 04/Nov/14 22:01
• Updated: 28/Jul/15 15:43
• Resolved: 28/Jul/15 15:43

Description

Renaming tables does not alter the data stored in the TAB_COL_STATS. So if a user renames table1 to table2 they will also need to re-compute statistics against this table.

This is an inconvenience and puts the metastore in an inconsistent state. It neither drops or updates TAB_COL_STATS.TABLE_NAME. So you will have an entry for both the old table name and the new table name.

This lingering data is also inherited by any table that assumes the previously used table name.

Issue Links

• is superceded by: HIVE-9720 Metastore does not properly migrate column stats when renaming a table across databases.
• is superceded by: HIVE-9866 Changing a column's type doesn't change column stats type in metastore