[
https://issues.apache.org/jira/browse/FLINK-14691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Terry Wang updated FLINK-14691:
-------------------------------
Description:
According to FLIP-69, we should support such following DDLs related to the
database in the TableEnvironment.
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
was:
According to FLIP-69, we should support such following DDLs related to the
database in the TableEnvironment.
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
> Support database related DDLs in TableEnvironment
> -------------------------------------------------
>
> Key: FLINK-14691
> URL: https://issues.apache.org/jira/browse/FLINK-14691
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Terry Wang
> Priority: Major
>
> According to FLIP-69, we should support such following DDLs related to the
> database in the TableEnvironment.
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
