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 "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/03/02 17:47:00 UTC
[jira] [Commented] (IMPALA-7832) Support IF NOT EXISTS in alter table add columns
[ https://issues.apache.org/jira/browse/IMPALA-7832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695841#comment-17695841 ]
ASF subversion and git services commented on IMPALA-7832:
---------------------------------------------------------
Commit 8b375a66a29cfea33a4e418b1fa3b9b5139cf907 in impala's branch refs/heads/master from xiabaike
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=8b375a66a ]
IMPALA-11565: Support IF NOT EXISTS in alter table add columns for kudu/iceberg table
Impala already supports IF NOT EXISTS in alter table add columns for
general hive table in IMPALA-7832, but not for kudu/iceberg table.
This patch try to add such semantics for kudu/iceberg table.
Testing:
- Updated E2E DDL tests
- Added fe tests
Change-Id: I82590e5372e881f2e81d4ed3dd0d32a2d3ddb517
Reviewed-on: http://gerrit.cloudera.org:8080/18953
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Wenzhe Zhou <wz...@cloudera.com>
> 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
> Assignee: Fredy Wijaya
> Priority: Minor
> Labels: ramp-up
> Fix For: Impala 3.2.0
>
>
> 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
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org