Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-19842 Informational Referential Integrity Constraints Support in Spark
  3. SPARK-21823

ALTER TABLE table statements such as RENAME and CHANGE columns should raise error if there are any dependent constraints.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Following ALTER TABLE DDL statements will impact the informational constraints defined on a table:

      ALTER TABLE name RENAME TO new_name
      ALTER TABLE name CHANGE column_name new_name new_type
      

      Spark SQL should raise errors if there are 
 informational constraints defined on the columns affected by the ALTER and let the user drop constraints before proceeding with the DDL. In the future we can enhance the ALTER to automatically fix up the constraint definition in the catalog when possible, and not raise error

      When spark adds support for DROP/REPLACE of columns they will impact informational constraints.

      ALTER TABLE name DROP [COLUMN] column_name
      ALTER TABLE name REPLACE COLUMNS (col_spec[, col_spec ...])
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                tsuresh Suresh Thalamati
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: