Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-5949

DDL: Support ALTER TABLE DROP COLUMN

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.4
    • Component/s: sql
    • Labels:

      Description

      Ignite should support DROP COLUMN operation for ALTER TABLE command.

      Design considerations:
      1) Drop should only be possible on binary types without schema (see IGNITE-6611). Probably we will need a new option for CREATE TABLE command
      2) Drop should not block other operations for a long time. We should synchronously block the table, change meta, then release the lock and let operations continue.
      3) Actual data remove should be performed asynchronously in the same way we create index. During this time we should not allow any other modifications to the table
      4) Be careful with node stop - we do not want to wait for years for this command to complete.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                skalashnikov Sergey Kalashnikov
                Reporter:
                amashenkov Andrew Mashenkov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: