You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2025/01/21 09:57:00 UTC

[jira] [Commented] (HIVE-28586) Support write order for Iceberg tables at CREATE TABLE

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

Denys Kuzmenko commented on HIVE-28586:
---------------------------------------

Merged to master
Thanks [~zratkai] for the patch and [~zhangbutao], [~okumin], [~ayushsaxena] for the review!

> Support write order for Iceberg tables at CREATE TABLE
> ------------------------------------------------------
>
>                 Key: HIVE-28586
>                 URL: https://issues.apache.org/jira/browse/HIVE-28586
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>            Reporter: Zoltán Rátkai
>            Assignee: Zoltán Rátkai
>            Priority: Major
>              Labels: pull-request-available
>
> h3. Add support for:
> Iceberg tables can be configured with a sort order that is used to automatically sort data that is written to the table in some engines. For example, {{MERGE INTO}} in Spark will use the table ordering.
> To set the write order for a table, use {{{}WRITE ORDERED BY{}}}:
>  
> CREATE TABLE prod.db.sample WRITE ORDERED BY category, id
> -- use optional ASC/DEC keyword to specify sort order of each field (default ASC)}}
> CREATE TABLE prod.db.sample WRITE ORDERED BY category ASC, id 
> -- use optional NULLS FIRST/NULLS LAST keyword to specify null order of each field (default FIRST)}}
> CREATE TABLE prod.db.sample WRITE ORDERED BY category ASC NULLS LAST, id DESC NULLS FIRST
> Align the syntax based on compatibility.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)