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)

Reply via email to