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

["Zoltán Rátkai (Jira)" <ji...@apache.org>]

Zoltán Rátkai created HIVE-28586:
------------------------------------

             Summary: 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
      Security Level: Public (Viewable by anyone)
          Components: Hive
            Reporter: Zoltán Rátkai
            Assignee: Zoltán Rátkai


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{}}}:
 
{{[|https://iceberg.apache.org/docs/latest/spark-ddl/#__codelineno-31-1]CREATE TABLE prod.db.sample WRITE ORDERED BY category, id[|https://iceberg.apache.org/docs/latest/spark-ddl/#__codelineno-31-2]-- 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 DESC[|https://iceberg.apache.org/docs/latest/spark-ddl/#__codelineno-31-4]-- 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)