[
https://issues.apache.org/jira/browse/FLINK-31452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ran Tao updated FLINK-31452:
----------------------------
Description:
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)
was:
Currently TableEnv support return sorted views and tables.
{code:java}
@Override
public String[] listTables() {
return catalogManager.listTables().stream().sorted().toArray(String[]::new);
}
@Override
public String[] listViews() {
return catalogManager.listViews().stream().sorted().toArray(String[]::new);
} {code}
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.
{code:java}
@Override
public String[] listDatabases() {
return catalogManager
.getCatalog(catalogManager.getCurrentCatalog())
.get()
.listDatabases()
.toArray(new String[0]);
} {code}
> Show databases should better return sorted results
> --------------------------------------------------
>
> Key: FLINK-31452
> URL: https://issues.apache.org/jira/browse/FLINK-31452
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API, Table SQL / Planner
> Reporter: Ran Tao
> Priority: Minor
>
> 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)
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
