[
https://issues.apache.org/jira/browse/FLINK-22885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17358540#comment-17358540
]
Roc Marshal edited comment on FLINK-22885 at 6/7/21, 11:08 AM:
---------------------------------------------------------------
*Note:* *The above table shows that there are several problems that cannot be
adjusted, please ignore it. Refer to the information below, Please.*
* *MySQL*
* *primitive syntax support*: SHOW [EXTENDED] [FULL] \{COLUMNS| FIELDS}
\{FROM| IN} _tbl_name_ [\{FROM | IN} _db_name_] [LIKE 'pattern'| WHERE expr]
* *optional strategy*:query from meta schema store.
* *reference link*:[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html]
* *SparkSQL*
* *primitive syntax support*: SHOW COLUMNS table_identifier [ database ]
* *optional strategy*: unknown
* *reference
link*:[https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-columns.html]
* *Hive*
* *primitive syntax support*: SHOW COLUMNS (FROM|IN) table_name [(FROM| IN)
db_name] {{ [ LIKE }} {{'pattern_with_wildcards'}} {{]}};
* *optional strategy*: unknown
* *reference link*: https://issues.apache.org/jira/browse/HIVE-18373
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowColumns]
* *Presto*
* *primitive syntax support*: SHOW COLUMNS FROM <table>
* *optional strategy*: unknown
* *reference link*: [https://prestodb.io/docs/current/sql/show-columns.html]
* *Snowflake*
* *primitive syntax support*: SHOW COLUMNS [ LIKE '<pattern>' ] [ IN \{
ACCOUNT | [ DATABASE ] <db_name> | [ SCHEMA ] <schema_name> | [ TABLE ]
<table_name> | [ VIEW ] <view_name> }]
* *optional strategy*: unknown
* *reference link*:
[https://docs.snowflake.com/en/sql-reference/sql/show-columns.html]
* *Trino*
* *primitive syntax support*: SHOW COLUMNS FROM table [ LIKE pattern ]
* *optional strategy*:unknown
* *reference link*: [https://trino.io/docs/current/sql/show-columns.html]
* *PostgreSQL*
* *primitive syntax support*: disable
* *optional strategy*: "SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = '<table_name>';"
OR
"\d <table_name>" OR "\d+ <table_name>"
* *reference link*:[https://www.postgresql.org/docs/current/sql.html]
was (Author: rocmarshal):
*Note:* *The above table shows that there are several problems that cannot be
adjusted, please ignore it. Refer to the information below, Please.*
* *MySQL*
* *primitive syntax support*: SHOW [EXTENDED] [FULL] \{COLUMNS| FIELDS}
\{FROM| IN} _tbl_name_ [\{FROM | IN} _db_name_] [LIKE 'pattern'| WHERE expr]
* *optional strategy*:query from meta schema store.
* *reference link*:[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html]
* *SparkSQL*
* *primitive syntax support*: SHOW COLUMNS table_identifier [ database ]
* *optional strategy*: unknown
* *reference
link*:[https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-columns.html]
* *Hive*
* *primitive syntax support*: SHOW COLUMNS (FROM|IN) table_name [(FROM| IN)
db_name] {{ [ LIKE }} {{'pattern_with_wildcards'}} {{]}};
* *optional strategy*: unknown
* *reference link*: https://issues.apache.org/jira/browse/HIVE-18373
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowColumns]
* *Presto*
* *primitive syntax support*: SHOW COLUMNS FROM <table>
* *optional strategy*: unknown
* *reference link*: [https://prestodb.io/docs/current/sql/show-columns.html]
* *Snowflake*
* *primitive syntax support*: SHOW COLUMNS [ LIKE '<pattern>' ] [ IN \{
ACCOUNT | [ DATABASE ] <db_name> | [ SCHEMA ] <schema_name> | [ TABLE ]
<table_name> | [ VIEW ] <view_name> }]
* *optional strategy*: unknown
* *reference link*:
[https://docs.snowflake.com/en/sql-reference/sql/show-columns.html]
* *Trino*
* *primitive syntax support*: SHOW COLUMNS FROM table [ LIKE pattern ]
* *optional strategy*:unknown
* *reference link*: [https://trino.io/docs/current/sql/show-columns.html]
* *PostgreSQL*
* *primitive syntax support*: disable
* *optional strategy*: "SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = '<table_name>';"
OR
"\d <table_name>" OR "\d+ <table_name>"
* *reference link*:[https://www.postgresql.org/docs/current/sql.html]
> Support 'SHOW COLUMNS'.
> -----------------------
>
> Key: FLINK-22885
> URL: https://issues.apache.org/jira/browse/FLINK-22885
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / API
> Reporter: Roc Marshal
> Priority: Major
>
> h1. Support 'SHOW COLUMNS'.
> SHOW COLUMNS ( FROM | IN ) <table_name> [LIKE <like_sql_pattern>]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
