[jira] [Commented] (FLINK-17183) the 'create table [if not exists]' syntax is not supported

["muzimusi (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-17183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172960#comment-17172960 ] 

muzimusi commented on FLINK-17183:
----------------------------------

Hi [~jark]！
This feature is not available in Flink1.11. Should we reopen it ? Thanks！ 

> the 'create table [if not exists]' syntax is not supported
> ----------------------------------------------------------
>
>                 Key: FLINK-17183
>                 URL: https://issues.apache.org/jira/browse/FLINK-17183
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / Hive, Table SQL / API
>    Affects Versions: 1.10.0
>            Reporter: muzimusi
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.11.0
>
>         Attachments: create_table_if_not_exists.png
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> The 'create table [if not exists]' syntax is not supported by FlinkSqlParserImpl. For example, the following example will throw an error:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS default_catalog.default_database.access_log_hive (
>      source_ip VARCHAR,
>      target_ip VARCHAR,
>      behavior VARCHAR,
>      comm VARCHAR,
>      ts TIMESTAMP(3)
>  ) WITH (
>      'key' = 'value',
>       ...
>  )
> {code}
> The error message is like this：
> {noformat}
> Caused by: org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered "NOT" at line 1, column 17.
>  Was expecting one of:
>  {{ <EOF> }}
>  {{ "WITH" ...}}
>  {{ "COMMENT" ...}}
>  {{ "PARTITIONED" ...}}
>  {{ "(" ...}}
>  {{ "." ...}}{noformat}
>  
>  
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)