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

Support "alter table .. add/replace columns cascade"

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1.0
    • Component/s: SQL
    • Labels:
      None

      Description

      We often run into some issues like HIVE-6131which is due to inconsistent column descriptors between table and partitions after alter table. HIVE-8441/HIVE-7971 provided the flexibility to alter table at partition level. But most cases we have need change the table and partitions at same time. In addition, "alter table" is usually required prior to "alter table partition .." since querying table partition data is also through table. Instead of do that in two steps, here we provide a convenient ddl like "alter table ... cascade" to cascade table changes to partitions as well. The changes are only limited and applicable to add/replace columns and change column name, datatype, position and comment.

        Attachments

        1. HIVE-8839.patch
          253 kB
          Chaoyu Tang
        2. HIVE-8839.1.patch
          255 kB
          Chaoyu Tang
        3. HIVE-8839.2.patch
          254 kB
          Chaoyu Tang
        4. HIVE-8839.2.patch
          254 kB
          Chaoyu Tang

          Issue Links

            Activity

              People

              • Assignee:
                ctang.ma Chaoyu Tang
                Reporter:
                ctang.ma Chaoyu Tang
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: