You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Bowen Li (Jira)" <ji...@apache.org> on 2019/11/14 21:32:00 UTC

[jira] [Closed] (FLINK-14687) Add database related ddl support to SQL Parser

     [ https://issues.apache.org/jira/browse/FLINK-14687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bowen Li closed FLINK-14687.
----------------------------
    Resolution: Fixed

master: 10d372e1293d3c8bcd109e5fc570bfb368959f2c

> Add database related ddl support to SQL Parser
> ----------------------------------------------
>
>                 Key: FLINK-14687
>                 URL: https://issues.apache.org/jira/browse/FLINK-14687
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API, Table SQL / Client
>            Reporter: Terry Wang
>            Assignee: Terry Wang
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.10.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> According to FLIP-69, we should introduce such following DDLs related to the database in the sql parser.
> 1. createDatabaseStatement:
> CREATE  DATABASE [ IF NOT EXISTS ] [ catalogName.] dataBaseName
> [ COMMENT database_comment ]
> [WITH ( name=value [, name=value]*)]
> 2. dropDatabaseStatement:
> DROP  DATABASE [ IF EXISTS ] [ catalogName.] dataBaseName
> [ (RESTRICT|CASCADE)]
> 3. alterDatabaseStatement:
> ALTER  DATABASE  [ catalogName.] dataBaseName SET
> ( name=value [, name=value]*)
> 4. useDatabaseStatement:
> USE [ catalogName.] dataBaseName 
> 5. showDatabasesStatement:
> SHOW DATABASES
> 6. descDatabaseStatement:
> DESCRIBE  DATABASE [ EXTENDED] [ catalogName.] dataBasesName 



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