You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2021/06/01 11:52:00 UTC

[jira] [Comment Edited] (FLINK-22827) Hive dialect supports CLUSTERED BY clause of CREATE TABLE DDL

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

Jark Wu edited comment on FLINK-22827 at 6/1/21, 11:51 AM:
-----------------------------------------------------------

I updated the title to support this syntax in hive dialect. We recently supported a better Hive DDL&DQL compatibility in 1.13 version. I'm not sure whether this CLUSTERED BY syntax has been supported or not. Maybe [~lirui] can answer here. 


was (Author: jark):
I updated the title to support this syntax in hive dialect. We recently supported a better Hive DDL&DQL compatibility in 1.13 version. I'm not sure whether this CLUSTERED BY syntax is supported or not. Maybe [~lirui] can answer here. 

> Hive dialect supports CLUSTERED BY clause of CREATE TABLE DDL
> -------------------------------------------------------------
>
>                 Key: FLINK-22827
>                 URL: https://issues.apache.org/jira/browse/FLINK-22827
>             Project: Flink
>          Issue Type: New Feature
>          Components: Connectors / Hive
>    Affects Versions: 1.13.1
>            Reporter: Ma Jun
>            Priority: Major
>
> {code:java}
> # hive syntax:
> CREATE [ EXTERNAL ] TABLE [ IF NOT EXISTS ] table_identifier
>     [ ( col_name1[:] col_type1 [ COMMENT col_comment1 ], ... ) ]
>     [ COMMENT table_comment ]
>     [ PARTITIONED BY ( col_name2[:] col_type2 [ COMMENT col_comment2 ], ... ) 
>         | ( col_name1, col_name2, ... ) ]
>     [ CLUSTERED BY ( col_name1, col_name2, ...) 
>         [ SORTED BY ( col_name1 [ ASC | DESC ], col_name2 [ ASC | DESC ], ... ) ] 
>         INTO num_buckets BUCKETS ]
>     [ ROW FORMAT row_format ]
>     [ STORED AS file_format ]
>     [ LOCATION path ]
>     [ TBLPROPERTIES ( key1=val1, key2=val2, ... ) ]
>     [ AS select_statement ]
> {code}
>  
> {code:java}
> [ CLUSTERED BY ( col_name1, col_name2, ...) [ SORTED BY ( col_name1 [ ASC | DESC ], col_name2 [ ASC | DESC ], ... ) ] 
> {code}
> Will Flink support the way of creating tables and supporting clustered by | sort by into buckets in later versions?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)