You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (Jira)" <ji...@apache.org> on 2022/03/21 21:24:00 UTC

[jira] [Commented] (CALCITE-5053) Implement “show catalogs/databases/schemas" semantics

    [ https://issues.apache.org/jira/browse/CALCITE-5053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17510112#comment-17510112 ] 

Julian Hyde commented on CALCITE-5053:
--------------------------------------

Are there any DBs that implement both SHOW and DESCRIBE commands? Is SHOW built into the SQL or implemented by the shell?

Are there some use cases that SHOW implements that our current DESCRIBE command does not? (Other than being spelled S-H-O-W.) I don't really want to add a whole set of commands that do the same thing.

> 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)