[
https://issues.apache.org/jira/browse/FLINK-22885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17358500#comment-17358500
]
Roc Marshal edited comment on FLINK-22885 at 6/7/21, 10:45 AM:
---------------------------------------------------------------
[~jark] Thank you for your attention. And I make a table to describe the state
of the 'SHOW COLUMNS' syntax in other DB engines.
Look forward to your reply.
||database||primitive syntax support||optional strategy||reference link||
|MySQL|SHOW [EXTENDED] [FULL] {COLUMNS
\| FIELDS}
\{FROM \| IN}
_tbl_name_ [\{FROM \| IN}
_db_name_] [LIKE 'pattern' \| WHERE expr]|query from meta schema
store.|[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html]| |
|SparkSQL| {{SHOW COLUMNS table_identifier [ database
]}}|unknown|[https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-columns.html]|
|
|Hive|SHOW COLUMNS (FROM\|IN) table_name [(FROM \| IN) db_name] {{ [ LIKE }}
{{'pattern_with_wildcards'}} {{]}};|unknown| #
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowColumns]
# https://issues.apache.org/jira/browse/HIVE-18373| | |
|Presto|SHOW COLUMNS FROM
<table>|unknown|[https://prestodb.io/docs/current/sql/show-columns.html]| |
|Snowflake|SHOW COLUMNS [ LIKE '<pattern>' ] [ IN { ACCOUNT
\| [ DATABASE ] <db_name>
\| [ SCHEMA ] <schema_name>
\| [ TABLE ] <table_name>
\| [ VIEW ] <view_name>
}]|unknown|[https://docs.snowflake.com/en/sql-reference/sql/show-columns.html]|
|
|Trino|SHOW COLUMNS FROM table [ LIKE pattern
]|unknown|[https://trino.io/docs/current/sql/show-columns.html]| |
|PostgreSQL|disable|"SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = '<table_name>';"
OR
"\d <table_name>" / "\d+
<table_name>"|[https://www.postgresql.org/docs/current/sql.html]|
was (Author: rocmarshal):
[~jark] Thank you for your attention. And I make a table to describe the state
of the 'SHOW COLUMNS' syntax in other DB engines.
Look forward to your reply.
||database||primitive syntax support||optional strategy||reference link||
|MySQL|SHOW [EXTENDED] [FULL] \{COLUMNS \\| FIELDS}
{FROM \\| IN} _tbl_name_ [\{FROM \| IN}
_db_name_] [LIKE '_pattern_' \\| WHERE _expr_]|query from meta schema
store.|[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html]| |
|SparkSQL| {{SHOW COLUMNS table_identifier [ database
]}}|unknown|[https://spark.apache.org/docs/latest/sql-ref-syntax-aux-show-columns.html]|
|
|Hive|SHOW COLUMNS (FROM\|IN) table_name [(FROM\\|IN) db_name] {{ [ LIKE }}
{{'pattern_with_wildcards'}} {{]}};|unknown| #
[https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowColumns]
# https://issues.apache.org/jira/browse/HIVE-18373| | |
|Presto|SHOW COLUMNS FROM
<table>|unknown|[https://prestodb.io/docs/current/sql/show-columns.html]| |
|Snowflake|SHOW COLUMNS [ LIKE '<pattern>' ] [ IN \{ ACCOUNT \\| [ DATABASE ]
<db_name> \\| [ SCHEMA ] <schema_name> \\| [ TABLE ] <table_name> \\| [ VIEW ]
<view_name>
}]|unknown|[https://docs.snowflake.com/en/sql-reference/sql/show-columns.html]|
|
|Trino|SHOW COLUMNS FROM table [ LIKE pattern
]|unknown|[https://trino.io/docs/current/sql/show-columns.html]| |
|PostgreSQL|disable|"SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = '<table_name>';"
OR
"\d <table_name>" / "\d+
<table_name>"|[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)
