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

External Table: Alter Table Change column is not supported.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • Hive
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ashutoshc Ashutosh Chauhan Assign to me
            dileep529 Dileep Kumar Chiguruvada

            Dates

              Created:
              Updated:

              Slack

                Issue deployment