[FLINK-17111] Support SHOW VIEWS in Flink SQL

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.11.0
• Component/s: Table SQL / API, Table SQL / Planner
• Labels: pull-request-available
• Assignee: Zhenghua Gao
• Reporter: Zhenghua Gao
• Created: 13/Apr/20 07:33
• Updated: 16/Dec/20 07:03
• Resolved: 28/Apr/20 13:52

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 metadata of 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. 

Issue Links

• links to: GitHub Pull Request #11869