Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-20132

External Table: Alter Table Change column is not supported.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: Hive
    • Labels:
      None

      Description

      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"

      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)
      

      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.

        Attachments

          Activity

            People

            • Assignee:
              ashutoshc Ashutosh Chauhan
              Reporter:
              dileep529 Dileep Kumar Chiguruvada
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: