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

MSSQL upgrade script alters the wrong column

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

    Description

      HIVE-20221 changes PARTITION_PARAMS, so the following command is modifying the wrong table:

      ALTER TABLE "SERDE_PARAMS" ALTER COLUMN "PARAM_VALUE" nvarchar(MAX);

      https://github.com/apache/hive/blob/d3b036920acde7bb04840697eb13038103b062b4/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql#L21

      Attachments

        1. HIVE-21404.1.patch
          1.0 kB
          David Lavati
        2. HIVE-21404.2.patch
          1.0 kB
          David Lavati
        3. HIVE-21404.3.patch
          3 kB
          David Lavati
        4. HIVE-21404.4.patch
          3 kB
          David Lavati
        5. HIVE-21404.4.patch
          3 kB
          Zoltan Haindrich
        6. HIVE-21404.4.patch
          3 kB
          David Lavati
        7. HIVE-21404.4.patch
          3 kB
          David Lavati
        8. HIVE-21404.4.patch
          3 kB
          David Lavati
        9. HIVE-21404.4.patch
          3 kB
          David Lavati
        10. HIVE-21404.4.patch
          3 kB
          Zoltan Haindrich
        11. HIVE-21404.4.patch
          3 kB
          David Lavati
        12. HIVE-21404.4.patch
          3 kB
          David Lavati

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

          People

            dlavati David Lavati Assign to me
            dlavati-hw David Lavati
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 50m
              50m

              Slack

                Issue deployment