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

Support IF NOT EXISTS in alter table add columns

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • Impala 3.1.0
    • Impala 3.2.0
    • Frontend
    • 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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: