[
https://issues.apache.org/jira/browse/FLINK-21774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu closed FLINK-21774.
---------------------------
Fix Version/s: 1.13.0
Resolution: Fixed
Fixed in master: 83d6698e39e606d817479bc90041476f71821d8f
> Display result of all the SHOW command in tableau format
> --------------------------------------------------------
>
> Key: FLINK-21774
> URL: https://issues.apache.org/jira/browse/FLINK-21774
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / Client
> Reporter: Jark Wu
> Assignee: Nicholas Jiang
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.13.0
>
>
> Currently, all the SHOW command result in SQL Client deosn't in tableau
> format. We should unify the behavior and display in tableau format.
> {code}
> show catalogs;
> c1
> default_catalog
> !ok
> {code}
> ==>
> {code}
> show catalogs;
> +-----------------+
> | catalog name |
> +-----------------+
> | c1 |
> | default_catalog |
> +-----------------+
> 2 rows in set
> !ok
> {code}
> Besides, SQL Client will display column names even if the return set is empty:
> {code}
> SHOW MODULES;
> +-------------+
> | module name |
> +-------------+
> 0 row in set
> !ok
> {code}
> In mature databases, e.g. MySQL, they only show "Empty Set" instead of column
> names:
> {code}
> mysql> show tables;
> Empty set (0.00 sec)
> {code}
> We can improve this by simply omit the column names header.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
