[
https://issues.apache.org/jira/browse/CALCITE-4533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17300151#comment-17300151
]
Vladimir Ozerov commented on CALCITE-4533:
------------------------------------------
[~amaliujia], yes:
* {{IS NOT EXISTS}} is a no-op if the object already exists.
* {{REPLACE}} drops and re-creates the object.
> Fix handling of REPLACE and IF NOT EXISTS keywords for CREATE TABLE/SCHEMA
> commands
> -----------------------------------------------------------------------------------
>
> Key: CALCITE-4533
> URL: https://issues.apache.org/jira/browse/CALCITE-4533
> Project: Calcite
> Issue Type: Improvement
> Components: server
> Affects Versions: 1.26.0
> Reporter: Vladimir Ozerov
> Assignee: Vladimir Ozerov
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h
> Remaining Estimate: 0h
>
> Presently, the {{ServerDdlExecutor}} incorrectly process some keywords:
> # {{CREATE SCHEMA IF NOT EXISTS}} overwrites the existing schema
> # {{CREATE OR REPLACE TABLE}} doesn't replace the table if the table exists
> The goal of this ticket is to unify the handling of {{IF NOT EXISTS}} and
> {{REPLACE}} keywords for these two commands.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
