[
https://issues.apache.org/jira/browse/FLINK-21774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu updated FLINK-21774:
----------------------------
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.
{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.
was:
Currently, 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.
> 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
>
> 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)
