[ https://issues.apache.org/jira/browse/HIVE-8839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211871#comment-14211871 ]
Szehon Ho commented on HIVE-8839: --------------------------------- Thanks a lot for doing that Chaoyu! I left some minor question/comment on the review board. > Support "alter table .. add/replace columns cascade" > ---------------------------------------------------- > > Key: HIVE-8839 > URL: https://issues.apache.org/jira/browse/HIVE-8839 > Project: Hive > Issue Type: Improvement > Components: SQL > Environment: > Reporter: Chaoyu Tang > Assignee: Chaoyu Tang > Fix For: 0.15.0 > > Attachments: HIVE-8839.1.patch, HIVE-8839.patch > > > We often run into some issues like HIVE-6131which is due to inconsistent > column descriptors between table and partitions after alter table. > HIVE-8441/HIVE-7971 provided the flexibility to alter table at partition > level. But most cases we have need change the table and partitions at same > time. In addition, "alter table" is usually required prior to "alter table > partition .." since querying table partition data is also through table. > Instead of do that in two steps, here we provide a convenient ddl like "alter > table ... cascade" to cascade table changes to partitions as well. The > changes are only limited and applicable to add/replace columns and change > column name, datatype, position and comment. -- This message was sent by Atlassian JIRA (v6.3.4#6332)