[
https://issues.apache.org/jira/browse/HIVE-28587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17894396#comment-17894396
]
yongzhi.shao commented on HIVE-28587:
-------------------------------------
could we also support zorder in alter table function?
> Support write order for Iceberg tables at ALTER TABLE
> -----------------------------------------------------
>
> Key: HIVE-28587
> URL: https://issues.apache.org/jira/browse/HIVE-28587
> Project: Hive
> Issue Type: Improvement
> Security Level: Public(Viewable by anyone)
> Components: Hive
> Reporter: Zoltán Rátkai
> Assignee: Zoltán Rátkai
> Priority: Major
>
> 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.
> 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{}}}:
>
> ALTER TABLE prod.db.sample WRITE ORDERED BY category, id
> -- use optional ASC/DEC keyword to specify sort order of each field (default
> ASC)}}
> ALTER 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)}}
> ALTER 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)
