You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Dawid Wysakowicz (Jira)" <ji...@apache.org> on 2020/05/28 19:49:00 UTC
[jira] [Commented] (FLINK-17183) the 'create table [if not exists]'
syntax is not supported
[ https://issues.apache.org/jira/browse/FLINK-17183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17119036#comment-17119036 ]
Dawid Wysakowicz commented on FLINK-17183:
------------------------------------------
How about we convert the issue to a "NEW FEATURE" instead of closing it? I think its a valid feature request. Also is something wrong with the approach suggested by the contributor? If there is could we help the contributor work on it instead of ditching it?
> 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)