[
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 |
e.g. pg:
Name | Owner | Encoding | Collate
------------+----------+----------+-------------
pgbench | postgres | UTF8 | en_US.UTF-8
postgres | postgres | UTF8 | en_US.UTF-8
slonmaster | postgres | UTF8 | en_US.UTF-8
slonslave | postgres | UTF8 | en_US.UTF-8
template0 | postgres | UTF8 | en_US.UTF-8
template1 | postgres | UTF8 | en_US.UTF-8
test | postgres | UTF8 | en_US.UTF-8
was:
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)
> 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
> Labels: pull-request-available
>
> 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 |
> e.g. pg:
> Name | Owner | Encoding | Collate
> ------------+----------+----------+-------------
> pgbench | postgres | UTF8 | en_US.UTF-8
> postgres | postgres | UTF8 | en_US.UTF-8
> slonmaster | postgres | UTF8 | en_US.UTF-8
> slonslave | postgres | UTF8 | en_US.UTF-8
> template0 | postgres | UTF8 | en_US.UTF-8
> template1 | postgres | UTF8 | en_US.UTF-8
> test | postgres | UTF8 | en_US.UTF-8
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
