[
https://issues.apache.org/jira/browse/HIVE-8839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14215092#comment-14215092
]
Szehon Ho commented on HIVE-8839:
---------------------------------
'Cascade' keyword seems a reasonable protection, another flag is definitely
possible but seems excessive. Haven't heard back for a strong vote for another
flag, so will +1 this.
> 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
> Labels: TODOC15
> Fix For: 0.15.0
>
> Attachments: HIVE-8839.1.patch, HIVE-8839.2.patch, HIVE-8839.2.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)
