You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Terry Wang (Jira)" <ji...@apache.org> on 2019/11/10 05:48:00 UTC
[jira] [Created] (FLINK-14687) Add database related ddl support to
FLINK-SQL-Parser
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)