[jira] [Created] (HIVE-20132) External Table: Alter Table Change column is not supported.

[Dileep Kumar Chiguruvada (JIRA)]

Dileep Kumar Chiguruvada created HIVE-20132:
-----------------------------------------------

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