[ 
https://issues.apache.org/jira/browse/HIVE-8839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Szehon Ho updated HIVE-8839:
----------------------------
    Environment: 
















  was:


















Need to add this in 
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Describe|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Describe],
 and also explain the nuances

> 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)

Reply via email to