You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues-all@impala.apache.org by "Thomas Tauber-Marshall (JIRA)" <ji...@apache.org> on 2018/11/07 22:50:00 UTC

[jira] [Created] (IMPALA-7832) Support IF NOT EXISTS in alter table add columns

Thomas Tauber-Marshall created IMPALA-7832:
----------------------------------------------

             Summary: Support IF NOT EXISTS in alter table add columns
                 Key: IMPALA-7832
                 URL: https://issues.apache.org/jira/browse/IMPALA-7832
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
    Affects Versions: Impala 3.1.0
            Reporter: Thomas Tauber-Marshall


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.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org