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

Support alter table change/replace/add columns for existing partitions

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

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.14.0
    • None
    • None

    Description

      ALTER TABLE CHANGE COLUMN is allowed for tables, but not for partitions. Same for add/replace columns.
      Allowing this for partitions can be useful in some cases. For example, one user has tables with Hive 0.12 Decimal columns, which do not specify precision/scale. To be able to properly read the decimal values from the existing partitions, the column types in the partitions need to be changed to decimal types with precision/scale.

      Attachments

        1. HIVE-7971.1.patch
          25 kB
          Jason Dere
        2. HIVE-7971.2.patch
          40 kB
          Jason Dere
        3. HIVE-7971.3.patch
          47 kB
          Jason Dere
        4. HIVE-7971.branch-13.patch
          52 kB
          Jason Dere

        Issue Links

        Activity

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

          People

            jdere Jason Dere Assign to me
            jdere Jason Dere
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment