[ https://issues.apache.org/jira/browse/HIVE-7971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14147461#comment-14147461 ]
Gunther Hagleitner commented on HIVE-7971: ------------------------------------------ The patch looks good, but I added some follow up questions on rb. Maybe better here: - dynamic partition: You're saying that's not supported, is this at the parser level? did you enable the flag? - if that's not there, it will be hard to update all partitions (your decimal use case), but that could be another jira/time - default partition: You're saying this doesn't work. Without it you can't completely update the table though, right? Is this easy to add? - reordering has no effect: hm, this should be the serde that reconciles the difference between table and schema right? If that's broken altogether then probably just file another jira. I just want to make sure it's not just this patch not updating all fields. Are there any serdes that work? > Support alter table change/replace/add columns for existing partitions > ---------------------------------------------------------------------- > > Key: HIVE-7971 > URL: https://issues.apache.org/jira/browse/HIVE-7971 > Project: Hive > Issue Type: Bug > Reporter: Jason Dere > Assignee: Jason Dere > Attachments: HIVE-7971.1.patch, HIVE-7971.2.patch > > > ALTER TABLE CHANGE COLUMN is allowed for tables, but not for partitions. Same > for add/replace columns. > Allowing this for partitions can be useful in some cases. For example, one > user has tables with Hive 0.12 Decimal columns, which do not specify > precision/scale. To be able to properly read the decimal values from the > existing partitions, the column types in the partitions need to be changed to > decimal types with precision/scale. -- This message was sent by Atlassian JIRA (v6.3.4#6332)