[HIVE-9866] Changing a column's type doesn't change column stats type in metastore

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Assignee: Chaoyu Tang
• Reporter: Henry Robinson
• Created: 05/Mar/15 01:00
• Updated: 28/Jul/15 15:43
• Resolved: 13/Mar/15 18:57

Description

If I have a table at, with a column id of type DOUBLE, the metastore will have an entry in TAB_COL_STATS something like:

hive_ms=> select "TABLE_NAME", "COLUMN_NAME", "COLUMN_TYPE" from "TAB_COL_STATS" WHERE "TBL_ID" = 1341 AND "COLUMN_NAME" = 'id';
 TABLE_NAME | COLUMN_NAME | COLUMN_TYPE
------------+-------------+-------------
 at         | id          | DOUBLE

If in Hive I then do:

hive> alter table at change column id id int;

The COLUMN_TYPE column does not change in the metastore. This means that any subsequent attempts to change the column statistics through the metastore client via updateTableColumnStatistics() will silently fail.

Issue Links

• is related to: HIVE-9720 Metastore does not properly migrate column stats when renaming a table across databases.
• supercedes: HIVE-8734 Renaming tables leaves stat store in stale state