[ https://issues.apache.org/jira/browse/HIVE-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209634#comment-13209634 ]
Ashutosh Chauhan commented on HIVE-1054: ---------------------------------------- One problem there could be that all partition values are stored as string, so type info is completely lost in mysql. As a result partition filters cannot be pushed in mysql for any types other then string. This is also documented in listPartitionsByFilter() api of metastoreclient. Though, I don't find that this is enforced anywhere (that might itself be a bug). As a result, changing a type of partition column from string to int or vice-versa might result in change in behavior. > "CHANGE COLUMN" does not support changing partition column types. > ----------------------------------------------------------------- > > Key: HIVE-1054 > URL: https://issues.apache.org/jira/browse/HIVE-1054 > Project: Hive > Issue Type: Bug > Reporter: He Yongqiang > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira