[
https://issues.apache.org/jira/browse/FLINK-17111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhenghua Gao updated FLINK-17111:
---------------------------------
Description:
SHOW TABLES and SHOW VIEWS are not SQL standard-compliant commands.
MySQL supports SHOW TABLES which lists the non-TEMPORARY tables(and views) in a
given database, and doesn't support SHOW VIEWS.
Oracle/SQL Server/PostgreSQL don't support SHOW TABLES and SHOW VIEWS. A
workaround is to query a system table which stores tables and views.
Hive supports both SHOW TABLES and SHOW VIEWS.
We follows the Hive style which lists all tables and views with SHOW TABLES and
lists only views with SHOW VIEWS.
> Support SHOW VIEWS in Flink SQL
> --------------------------------
>
> Key: FLINK-17111
> URL: https://issues.apache.org/jira/browse/FLINK-17111
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API, Table SQL / Planner
> Affects Versions: 1.10.0
> Reporter: Zhenghua Gao
> Priority: Major
> Fix For: 1.11.0
>
>
> SHOW TABLES and SHOW VIEWS are not SQL standard-compliant commands.
> MySQL supports SHOW TABLES which lists the non-TEMPORARY tables(and views) in
> a given database, and doesn't support SHOW VIEWS.
> Oracle/SQL Server/PostgreSQL don't support SHOW TABLES and SHOW VIEWS. A
> workaround is to query a system table which stores tables and views.
> Hive supports both SHOW TABLES and SHOW VIEWS.
> We follows the Hive style which lists all tables and views with SHOW TABLES
> and lists only views with SHOW VIEWS.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
