[ https://issues.apache.org/jira/browse/HIVE-20132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dileep Kumar Chiguruvada reassigned HIVE-20132: ----------------------------------------------- Assignee: Ashutosh Chauhan > External Table: Alter Table Change column is not supported. > ----------------------------------------------------------- > > Key: HIVE-20132 > URL: https://issues.apache.org/jira/browse/HIVE-20132 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 3.0.0 > Reporter: Dileep Kumar Chiguruvada > Assignee: Ashutosh Chauhan > Priority: Major > Fix For: 3.0.0 > > > External Table: Alter Table Change column is not supported.. > It fails with "ALTER TABLE can only be used for [ADDPROPS, DROPPROPS, > ADDCOLS] to a non-native table" > {code} > 0: jdbc:hive2://ctr-e138-1518143905142-404953> alter table calcs change > column key string int; > Error: Error while compiling statement: FAILED: SemanticException [Error > 10134]: ALTER TABLE can only be used for [ADDPROPS, DROPPROPS, ADDCOLS] to a > non-native table calcs (state=42000,code=10134) > {code} > This is very much required for upgraded clusters where managed tables(in 2.6 > clusters) automatically converted to external tables(in 3.0.0). > One such use case is Storagehandler Tables, where we might need to alter > columns. -- This message was sent by Atlassian JIRA (v7.6.3#76005)