Henry Robinson created HIVE-9866: ------------------------------------ Summary: Changing a column's type doesn't change column stats type in metastore Key: HIVE-9866 URL: https://issues.apache.org/jira/browse/HIVE-9866 Project: Hive Issue Type: Bug Reporter: Henry Robinson
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: {code} 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 {code} 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)