Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-7832

Support IF NOT EXISTS in alter table add columns

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Impala 3.1.0
    • Fix Version/s: Impala 3.2.0
    • Component/s: Frontend
    • Labels:
    • Epic Color:
      ghx-label-6

      Description

      alter table <table_name> add [if not exists] columns (<name> <type> [, <name> <type>...])

      would add the column only if a column of the same name does not already exist

      Probably worth checking out what other databases do in different situations, eg. if the column already exists but with a different type, if "replace" is used instead of "add", etc.

        Attachments

        There are no Sub-Tasks for this issue.

          Activity

            People

            • Assignee:
              fredyw Fredy Wijaya
              Reporter:
              twmarshall Thomas Tauber-Marshall
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: