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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
Terry Wang created FLINK-14687:
----------------------------------

             Summary: Add database related ddl support to FLINK-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


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)