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

MSSQL upgrade script alters the wrong column

    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
          David Lavati
        6. HIVE-21404.4.patch
          3 kB
          Zoltan Haindrich
        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
          David Lavati
        11. HIVE-21404.4.patch
          3 kB
          Zoltan Haindrich
        12. HIVE-21404.4.patch
          3 kB
          David Lavati

        Activity

          People

            dlavati David Lavati
            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