[
https://issues.apache.org/jira/browse/HIVE-28586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zoltán Rátkai updated HIVE-28586:
---------------------------------
Description:
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.
was:
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.
}}
> 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
> 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.
> 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)
