[
https://issues.apache.org/jira/browse/FLINK-22885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17358500#comment-17358500
]
Roc Marshal commented on FLINK-22885:
-------------------------------------
[~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)
