[
https://issues.apache.org/jira/browse/HIVE-7971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14153943#comment-14153943
]
Lefty Leverenz commented on HIVE-7971:
--------------------------------------
Doc note: This belongs in the wiki's DDL doc with version information and
guidance (see previous comments).
* [DDL -- Alter Column |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn]
* [Gunther's doc comment |
https://issues.apache.org/jira/browse/HIVE-7971?focusedCommentId=14131948&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14131948]
* [Jason's comment (multiple partitions) |
https://issues.apache.org/jira/browse/HIVE-7971?focusedCommentId=14134238&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14134238]
> 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
> Labels: TODOC14
> Fix For: 0.14.0
>
> Attachments: HIVE-7971.1.patch, HIVE-7971.2.patch, HIVE-7971.3.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)
