[FLINK-21774] Display result of all the SHOW command in tableau format

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Nicholas Jiang
• Reporter: Jark Wu
• Created: 13/Mar/21 14:22
• Updated: 17/Mar/21 11:10
• Resolved: 17/Mar/21 11:10

Description

Currently, all the SHOW command result in SQL Client deosn't in tableau format. We should unify the behavior and display in tableau format.

show catalogs;
c1
default_catalog
!ok

==>

show catalogs;
+-----------------+
|    catalog name |
+-----------------+
|              c1 |
| default_catalog |
+-----------------+
2 rows in set
!ok

Besides, SQL Client will display column names even if the return set is empty:

SHOW MODULES;
+-------------+
| module name |
+-------------+
0 row in set
!ok

In mature databases, e.g. MySQL, they only show "Empty Set" instead of column names:

mysql> show tables;
Empty set (0.00 sec)

We can improve this by simply omit the column names header.

Issue Links

• links to: GitHub Pull Request #15213