Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-38939

Support ALTER TABLE ... DROP [IF EXISTS] COLUMN .. syntax

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.2.0, 3.2.1, 3.3.0
    • 3.3.0
    • SQL
    • None

    Description

      Currently `ALTER TABLE ... DROP COLUMN(s) ...` syntax will always throw error if the column doesn't exist. We would like to provide an (IF EXISTS) syntax to provide better user experience for downstream handlers (such as Delta) that support it, and make consistent with some other DMLs such as `DROP TABLE (IF EXISTS)`

      Attachments

        Activity

          People

            jackierwzhang Jackie Zhang
            jackierwzhang Jackie Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: