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

Reply via email to