[
https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17511590#comment-17511590
]
itxiangkui commented on CALCITE-5053:
-------------------------------------
It seems that "PR 218" has been implemented to the SqlParser layer, but it
would be more practical if implemented to "SqlValidate" and "Relational
Algebra", it feels that context information can be obtained from
Schema.getSubSchemaMap().
At the same time, I have learned about the default tool Sqlline of
"https://calcite.apache.org/docs/tutorial.html";, which provides the syntax
expressions of "!schema" and "!table", but he is from
DatabaseMetaData.getTable. For the information obtained, this usage seems a bit
strange. In addition, when I design a three-level schema
(catalog->database->table), the usage of "!schema" will be meaningless, and I
may consider using "use catalog/database" and "show catalogs/databases/tables"
' syntactic sugar...
> Implement “show catalogs/databases/schemas" semantics
> -------------------------------------------------------
>
> Key: CALCITE-5053
> URL: https://issues.apache.org/jira/browse/CALCITE-5053
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.29.0
> Reporter: itxiangkui
> Priority: Major
>
> our data warehouse has integrate es/mysql/druid and so on ,also the dba
> manage the database difficultly。
> the default sql has implement the "DESCRIBE CATALOG/SCHEMA" and so on
> but most of dba may prefer a simple sql grammar like "show databases" ...
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
