[
https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated FLINK-31452:
----------------------------
Description:
flink show databases not support sorted function. I think we can add support
for these operations. So when returned results are large, user can locate
result easily. we can see mature engines such as mysql did support it.
Flink SQL> show databases;
+------------------+
| database name|
+------------------+
|default_database|
| test|
| sys|
| ca_db|
+------------------+
e.g. mysql
+--------------------+
|Database |
+--------------------+
|information_schema|
|mysql |
|performance_schema|
|sys |
|test |
|test_db |
+--------------------+
6 rows in set (0.01 sec)
was:
Currently TableEnv support return sorted views and tables.
But other operations such as show databases without sorted function. I think we
can add support for these operations. So when returned results are large, user
can locate result easily.
Flink SQL> show databases;
+------------------+
| database name |
+------------------+
| default_database |
| test |
| sys |
| ca_db |
+------------------+
e.g. mysql
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
| test_db |
+--------------------+
6 rows in set (0.01 sec)
> Show databases should better return sorted results
> --------------------------------------------------
>
> Key: FLINK-31452
> URL: https://issues.apache.org/jira/browse/FLINK-31452
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API, Table SQL / Planner
> Reporter: Ran Tao
> Priority: Major
>
> flink show databases not support sorted function. I think we can add support
> for these operations. So when returned results are large, user can locate
> result easily. we can see mature engines such as mysql did support it.
> Flink SQL> show databases;
> +------------------+
> | database name|
> +------------------+
> |default_database|
> | test|
> | sys|
> | ca_db|
> +------------------+
> e.g. mysql
> +--------------------+
> |Database |
> +--------------------+
> |information_schema|
> |mysql |
> |performance_schema|
> |sys |
> |test |
> |test_db |
> +--------------------+
> 6 rows in set (0.01 sec)
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
