OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


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)