[
https://issues.apache.org/jira/browse/FLINK-21058?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
孙铮 updated FLINK-21058:
-----------------------
Description:
Hive dialect already supports show partitions syntax
{code:java}
SHOW PARTITIONS table_name [PARTITION partition_spec];{code}
I think Flink SQL should support this syntax.
Starting with Hive 4.0.0, SHOW PARTITIONS can optionally use the WHERE/ORDER
BY/LIMIT clause to filter/order/limit the resulting list. These clauses work in
a similar way as they do in a SELECT statement.
{code:java}
SHOW PARTITIONS [db_name.]table_name [PARTITION(partition_spec)] [WHERE
where_condition] [ORDER BY col_list] [LIMIT rows];
{code}
I think Flink SQL should also support this syntax later
was:
Hive catalog show partitions
SHOW PARTITIONS [db_name.]table_name [PARTITION(partition_spec)];
> Add SHOW PARTITION syntax support for flink
> -------------------------------------------
>
> Key: FLINK-21058
> URL: https://issues.apache.org/jira/browse/FLINK-21058
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner
> Affects Versions: 1.12.0
> Reporter: 孙铮
> Priority: Minor
> Fix For: 1.13.0
>
>
> Hive dialect already supports show partitions syntax
>
> {code:java}
> SHOW PARTITIONS table_name [PARTITION partition_spec];{code}
>
> I think Flink SQL should support this syntax.
>
> Starting with Hive 4.0.0, SHOW PARTITIONS can optionally use the WHERE/ORDER
> BY/LIMIT clause to filter/order/limit the resulting list. These clauses work
> in a similar way as they do in a SELECT statement.
> {code:java}
> SHOW PARTITIONS [db_name.]table_name [PARTITION(partition_spec)] [WHERE
> where_condition] [ORDER BY col_list] [LIMIT rows];
> {code}
> I think Flink SQL should also support this syntax later
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
