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

Upgrading SQL server backed metastore when changing data type of a column with constraints

    XMLWordPrintableJSON

    Details

    • Target Version/s:
    • Hadoop Flags:
      Reviewed

      Description

      SQL server does not allow changing data type of a column which has a constraint or an index on it. The constraint or the index needs to be dropped before changing the data type and needs to be recreated after that. Metastore upgrade scripts aren't doing this and thus upgrade fails.

        Attachments

        1. HIVE-21462.02.patch
          13 kB
          Ashutosh Bapat
        2. HIVE-21462.01.patch
          13 kB
          Ashutosh Bapat

          Issue Links

            Activity

              People

              • Assignee:
                ashutosh.bapat Ashutosh Bapat
                Reporter:
                ashutosh.bapat Ashutosh Bapat
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h
                  24h
                  Remaining:
                  Time Spent - 0.5h Remaining Estimate - 23.5h
                  23.5h
                  Logged:
                  Time Spent - 0.5h Remaining Estimate - 23.5h
                  0.5h