This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hive-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new c2e6b3a deploy: 012556d57b683932aee9e10c4d4c6cda22646e8b
c2e6b3a is described below
commit c2e6b3aacd8dd03d2c2bbd779b2eb7c1cafad7d8
Author: deniskuzZ <[email protected]>
AuthorDate: Sat Nov 1 10:18:12 2025 +0000
deploy: 012556d57b683932aee9e10c4d4c6cda22646e8b
---
docs/latest/language/index.html | 24 +-
docs/latest/language/index.xml | 7 +-
docs/latest/language/languagemanual/index.html | 1 +
docs/latest/language/writeordering/index.html | 428 +++++++++++++++++++++++++
index.json | 2 +-
index.xml | 7 +-
sitemap.xml | 2 +-
7 files changed, 463 insertions(+), 8 deletions(-)
diff --git a/docs/latest/language/index.html b/docs/latest/language/index.html
index f5c5e75..0fa3332 100644
--- a/docs/latest/language/index.html
+++ b/docs/latest/language/index.html
@@ -140,7 +140,7 @@ ASF
<div class=docs-meta>
<span class=docs-count>
<i class="fas fa-file-alt"></i>
-53 documents
+54 documents
</span>
</div>
</header>
@@ -148,6 +148,26 @@ ASF
<div class=docs-grid>
<div class=docs-card>
<div class=docs-card-header>
+<h3><a href=https://hive.apache.org/docs/latest/language/writeordering/>Apache
Hive : Write Ordering</a></h3>
+<span class=docs-card-date>
+<i class="fas fa-calendar-alt"></i>
+Oct 31, 2025
+</span>
+</div>
+<div class=docs-card-summary>
+Apache Hive : Write Ordering Overview Write ordering controls the physical
layout of data within table files. Unlike SORT BY which orders data during
query execution, write ordering is applied at write time and persists in the
stored files.
+Write ordering is supported for Iceberg tables and can be specified during
table creation.
+Hive supports two write ordering strategies:
+Regular Ordering: Sort by one or more columns in a specified order Z-Ordering:
Multi-dimensional clustering using space-filling curves Regular Column Ordering
Version Introduced in Hive version 4.
+</div>
+<div class=docs-card-footer>
+<a href=https://hive.apache.org/docs/latest/language/writeordering/
class=docs-card-link>
+Read more <i class="fas fa-arrow-right"></i>
+</a>
+</div>
+</div>
+<div class=docs-card>
+<div class=docs-card-header>
<h3><a
href=https://hive.apache.org/docs/latest/language/apache-hive-sql-conformance/>Apache
Hive : Apache Hive SQL Conformance</a></h3>
<span class=docs-card-date>
<i class="fas fa-calendar-alt"></i>
@@ -375,7 +395,7 @@ Commands and CLIs
Commands Hive CLI (old) Beeline CLI (new) Variable Substitution HCatalog CLI
File Formats
Avro Files ORC Files Parquet Compressed Data Storage LZO Compression Data Types
Data Definition Statements
-DDL Statements Bucketed Tables Statistics (Analyze and Describe) Indexes
Archiving Data Manipulation Statements
+DDL Statements Bucketed Tables Write Ordering (Regular & Z-Order) Statistics
(Analyze and Describe) Indexes Archiving Data Manipulation Statements
</div>
<div class=docs-card-footer>
<a href=https://hive.apache.org/docs/latest/language/languagemanual/
class=docs-card-link>
diff --git a/docs/latest/language/index.xml b/docs/latest/language/index.xml
index 4f478a3..bedbccb 100644
--- a/docs/latest/language/index.xml
+++ b/docs/latest/language/index.xml
@@ -1,4 +1,7 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0"
xmlns:atom="http://www.w3.org/2005/Atom";><channel><title>Language Manual on
Hive
Site</title><link>https://hive.apache.org/docs/latest/language/</link><description>Recent
content in Language Manual on Hive Site</description><generator>Hugo --
gohugo.io</generator><language>en-us</language><lastBuildDate>Thu, 24 Jul 2025
00:00:00 +0000</lastBuildDate><atom:link
href="https://hive.apache.org/docs/latest/language/inde [...]
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0"
xmlns:atom="http://www.w3.org/2005/Atom";><channel><title>Language Manual on
Hive
Site</title><link>https://hive.apache.org/docs/latest/language/</link><description>Recent
content in Language Manual on Hive Site</description><generator>Hugo --
gohugo.io</generator><language>en-us</language><lastBuildDate>Thu, 24 Jul 2025
00:00:00 +0000</lastBuildDate><atom:link
href="https://hive.apache.org/docs/latest/language/inde [...]
+Write ordering is supported for Iceberg tables and can be specified during
table creation.
+Hive supports two write ordering strategies:
+Regular Ordering: Sort by one or more columns in a specified order Z-Ordering:
Multi-dimensional clustering using space-filling curves Regular Column Ordering
Version Introduced in Hive version 4.</description></item><item><title>Apache
Hive : Apache Hive SQL
Conformance</title><link>https://hive.apache.org/docs/latest/language/apache-hive-sql-conformance/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/apache-hive-sql-conformanc
[...]
This information is versioned by Hive release version, allowing a user to
quickly identify features available to them.
The formal name of the current SQL standard is ISO/IEC 9075
&ldquo;Database Language
SQL&rdquo;.</description></item><item><title>Apache Hive : CAST...FORMAT
with SQL:2016 datetime
formats</title><link>https://hive.apache.org/docs/latest/language/cast-format-with-sql2016-datetime-formats/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/cast-format-with-sql2016-datetime-formats/</guid><description>Apache
Hive : CAST&he [...]
Patterns are case-insensitive, except AM/PM and T/Z. See these sections for
more details. For string to datetime conversion, no duplicate format tokens are
allowed, including tokens</description></item><item><title>Apache Hive : Common
Table
Expression</title><link>https://hive.apache.org/docs/latest/language/common-table-expression/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/common-table-expression/</guid><description>Apach
[...]
@@ -14,7 +17,7 @@ Commands and CLIs
Commands Hive CLI (old) Beeline CLI (new) Variable Substitution HCatalog CLI
File Formats
Avro Files ORC Files Parquet Compressed Data Storage LZO Compression Data Types
Data Definition Statements
-DDL Statements Bucketed Tables Statistics (Analyze and Describe) Indexes
Archiving Data Manipulation Statements</description></item><item><title>Apache
Hive : LanguageManual
Archiving</title><link>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</guid><description>Apache
Hive : LanguageManual Archiving Archiving for File Count Reduction.
+DDL Statements Bucketed Tables Write Ordering (Regular &amp; Z-Order)
Statistics (Analyze and Describe) Indexes Archiving Data Manipulation
Statements</description></item><item><title>Apache Hive : LanguageManual
Archiving</title><link>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</guid><description>Apache
Hive : LanguageManual [...]
Apache Hive : LanguageManual Archiving Overview Settings Usage Archive
Unarchive Cautions and Limitations Under the Hood Overview Due to the design of
HDFS, the number of files in the filesystem directly affects the memory
consumption in the namenode. While normally not a problem for small clusters,
memory usage may hit the limits of accessible memory on a single machine when
there are &gt;50-100 million files.</description></item><item><title>Apache
Hive : LanguageManual Authorizati [...]
Apache Hive : LanguageManual Hive CLI Deprecation in favor of Beeline CLI Hive
Command Line Options Examples The hiverc File Logging Tool to Clear Dangling
Scratch Directories Hive Batch Mode Commands Hive Interactive Shell Commands
Hive Resources HCatalog CLI Deprecation in favor of Beeline CLI HiveServer2
(introduced in Hive 0.</description></item><item><title>Apache Hive :
LanguageManual
Commands</title><link>https://hive.apache.org/docs/latest/language/languagemanual-commands/</link>
[...]
Command Description quit exit Use quit or exit to leave the interactive shell.
reset Resets the configuration to the default values (as of Hive 0.10: see
HIVE-3202). Any configuration parameters that were set using the set command or
-hiveconf parameter in hive commandline will get reset to default
value.</description></item><item><title>Apache Hive : LanguageManual
DDL</title><link>https://hive.apache.org/docs/latest/language/languagemanual-ddl/</link><pubDate>Thu,
12 Dec 2024 00:00:00 [...]
diff --git a/docs/latest/language/languagemanual/index.html
b/docs/latest/language/languagemanual/index.html
index a92deab..965696a 100644
--- a/docs/latest/language/languagemanual/index.html
+++ b/docs/latest/language/languagemanual/index.html
@@ -186,6 +186,7 @@ Last updated: December 12, 2024
<li><a
href=https://hive.apache.org/docs/latest/language/languagemanual-ddl/>DDL
Statements</a>
<ul>
<li><a
href=https://hive.apache.org/docs/latest/language/languagemanual-ddl-bucketedtables/>Bucketed
Tables</a></li>
+<li><a href=https://hive.apache.org/docs/latest/language/writeordering/>Write
Ordering (Regular & Z-Order)</a></li>
</ul>
</li>
<li><a
href=https://hive.apache.org/development/desingdocs/statsdev/>Statistics
(Analyze and Describe)</a></li>
diff --git a/docs/latest/language/writeordering/index.html
b/docs/latest/language/writeordering/index.html
new file mode 100644
index 0000000..e613a12
--- /dev/null
+++ b/docs/latest/language/writeordering/index.html
@@ -0,0 +1,428 @@
+<!doctype html><html><!doctype html>
+<html>
+<head>
+<meta charset=utf-8>
+<meta http-equiv=x-ua-compatible content="IE=edge">
+<meta name=viewport content="width=device-width,initial-scale=1">
+<meta name=description content>
+<meta name=author content>
+<title>Apache Hive : Write Ordering</title>
+<link rel=icon href=/images/hive.svg sizes=any type=image/svg+xml>
+<link rel=stylesheet href=https://hive.apache.org/css/hive-theme.css>
+<link rel=stylesheet href=https://hive.apache.org/css/font-awesome.all.min.css>
+<link rel=stylesheet href=https://hive.apache.org/css/bootstrap.min.css>
+<link rel=stylesheet href=https://hive.apache.org/css/termynal.css>
+<link rel=apple-touch-icon sizes=180x180
href=https://hive.apache.org/images/apple-touch-icon.png>
+<link rel=icon type=image/png sizes=32x32
href=https://hive.apache.org/images/favicon-32x32.png>
+<link rel=icon type=image/png sizes=16x16
href=https://hive.apache.org/images/favicon-16x16.png>
+<link rel=manifest href=https://hive.apache.org/images/site.webmanifest>
+<link rel=mask-icon href=https://hive.apache.org/images/safari-pinned-tab.svg
color=#5bbad5>
+<meta name=msapplication-TileColor content="#da532c">
+<meta name=theme-color content="#ffffff">
+<script>var
_paq=window._paq=window._paq||[];_paq.push(['disableCookies']),_paq.push(['trackPageView']),_paq.push(['enableLinkTracking']),function(){var
b="https://analytics.apache.org/",c,a,d;_paq.push(['setTrackerUrl',b+'matomo.php']),_paq.push(['setSiteId','30']),c=document,a=c.createElement('script'),d=c.getElementsByTagName('script')[0],a.async=!0,a.src=b+'matomo.js',d.parentNode.insertBefore(a,d)}()</script>
+</head>
+<body>
+<body>
+<header>
+<menu class=main-menu>
+<nav class="navbar navbar-expand-lg navbar-dark">
+<div class=container-fluid>
+<div class=navbar-brand-wrapper>
+<a href=https://hive.apache.org class=navbar-logo>
+<img src=https://hive.apache.org/images/hive.svg width=50 height=30
alt="Apache Hive Logo">
+</a>
+<a class=navbar-brand href=https://hive.apache.org>Apache Hive</a>
+</div>
+<button class=navbar-toggler type=button data-bs-toggle=collapse
data-bs-target=#navbarSupportedContent aria-controls=navbarSupportedContent
aria-expanded=false aria-label="Toggle navigation">
+<span class=navbar-toggler-icon></span>
+</button>
+<div class="collapse navbar-collapse" id=navbarSupportedContent>
+<ul class="navbar-nav me-auto">
+<li class=nav-item>
+<a class=nav-link href=https://hive.apache.org/general/downloads>
+Releases
+</a>
+</li>
+<li class="nav-item dropdown">
+<a class="nav-link dropdown-toggle" href=/Document id=docsDropdown role=button
data-bs-toggle=dropdown aria-expanded=false>
+Documentation
+</a>
+<ul class=dropdown-menu aria-labelledby=docsDropdown>
+<li><a class=dropdown-item
href=https://hive.apache.org/docs/latest/>Latest</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/docs/javadocs/>Javadocs</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/docs/latest/language/languagemanual>Language
Manual</a></li>
+</ul>
+</li>
+<li class="nav-item dropdown">
+<a class="nav-link dropdown-toggle" href=/general id=generalDropdown
role=button data-bs-toggle=dropdown aria-expanded=false>
+General
+</a>
+<ul class=dropdown-menu aria-labelledby=generalDropdown>
+<li><a class=dropdown-item
href=https://www.apache.org/licenses/LICENSE-2.0.html>License</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/general/privacypolicy/>Privacy Policy</a></li>
+<li><a class=dropdown-item href=/general/poweredby/>Powered by</a></li>
+</ul>
+</li>
+<li class="nav-item dropdown">
+<a class="nav-link dropdown-toggle" href=# id=devDropdown role=button
data-bs-toggle=dropdown aria-expanded=false>
+Development
+</a>
+<ul class=dropdown-menu aria-labelledby=devDropdown>
+<li><a class=dropdown-item
href=https://hive.apache.org/development/gettingstarted/>Getting
Started</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/development/quickstart/>Quickstart with
Docker</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/development/desingdocs/>Design Docs</a></li>
+<li><a class=dropdown-item
href=https://issues.apache.org/jira/projects/HIVE/issues>Hive JIRA</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/community/resources/hivedeveloperfaq>Hive
Developer FAQ</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/development/versioncontrol/>Version
Control</a></li>
+</ul>
+</li>
+<li class="nav-item dropdown">
+<a class="nav-link dropdown-toggle" href=# id=communityDropdown role=button
data-bs-toggle=dropdown aria-expanded=false>
+Community
+</a>
+<ul class=dropdown-menu aria-labelledby=communityDropdown>
+<li><a class=dropdown-item href=/community/becomingcommitter/>Becoming A
Committer</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/community/resources/howtocontribute>How To
Contribute</a></li>
+<li><a class=dropdown-item href=/community/resources/>Resources</a></li>
+<li><a class=dropdown-item href=/community/meetings/>Meetings</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/community/mailinglists/>Mailing Lists</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/community/issuetracking/>Issue Tracking</a></li>
+<li><a class=dropdown-item
href=https://hive.apache.org/community/people/>People</a></li>
+<li><hr class=dropdown-divider></li>
+<li><a class=dropdown-item href=/community/bylaws/>By Laws</a></li>
+<li><a class=dropdown-item href=/community/resources/howtorelease/>How To
Release</a></li>
+</ul>
+</li>
+<li class=nav-item>
+<a class=nav-link href=https://hive.blog.apache.org/>
+Blogs
+</a>
+</li>
+<li class="nav-item dropdown">
+<a class="nav-link dropdown-toggle" href=# id=asfDropdown role=button
data-bs-toggle=dropdown aria-expanded=false>
+ASF
+</a>
+<ul class=dropdown-menu aria-labelledby=asfDropdown>
+<li><a class=dropdown-item
href=https://www.apache.org/foundation/contributing.html>Donations</a></li>
+<li><a class=dropdown-item
href=https://www.apache.org/foundation/sponsorship.html>Sponsorship</a></li>
+<li><a class=dropdown-item
href=https://www.apache.org/foundation/thanks.html>Thanks</a></li>
+<li><a class=dropdown-item href=https://www.apache.org/>Website</a></li>
+</ul>
+</li>
+</ul>
+<div class=navbar-search>
+<form action=/search method=get class=search-form>
+<div class=search-input-group>
+<input type=search name=q id=search-query placeholder=Search...
class=search-input aria-label=Search>
+<button type=submit class=search-button aria-label="Submit search">
+<i class="fas fa-search"></i>
+</button>
+</div>
+</form>
+</div>
+</div>
+</div>
+</nav>
+</menu>
+</header>
+<div class=content>
+<div class=docs-container>
+<main class="docs-main docs-main-full">
+<article class=docs-content>
+<nav class=docs-breadcrumb>
+<ol>
+<li><a href=/><i class="fas fa-home"></i> Home</a></li>
+<li><a href=/docs/>Documentation</a></li>
+<li class=active>Apache Hive : Write Ordering</li>
+</ol>
+</nav>
+<header class=docs-header>
+<h1 class=docs-title>Apache Hive : Write Ordering</h1>
+<div class=docs-meta>
+<span class=docs-date>
+<i class="fas fa-calendar-alt"></i>
+Last updated: October 31, 2025
+</span>
+</div>
+</header>
+<div class=docs-toc>
+<h4><i class="fas fa-list"></i> Table of Contents</h4>
+<nav id=TableOfContents>
+<ul>
+<li><a href=#apache-hive--write-ordering>Apache Hive : Write Ordering</a>
+<ul>
+<li><a href=#overview>Overview</a></li>
+<li><a href=#regular-column-ordering>Regular Column Ordering</a>
+<ul>
+<li><a href=#version>Version</a></li>
+<li><a href=#syntax>Syntax</a></li>
+<li><a href=#options>Options</a></li>
+<li><a href=#examples>Examples</a></li>
+<li><a href=#use-cases>Use Cases</a></li>
+</ul>
+</li>
+<li><a href=#z-ordering>Z-Ordering</a>
+<ul>
+<li><a href=#version-1>Version</a></li>
+<li><a href=#overview-1>Overview</a></li>
+<li><a href=#syntax-1>Syntax</a></li>
+<li><a href=#examples-1>Examples</a></li>
+<li><a href=#table-properties-method>Table Properties Method</a></li>
+<li><a href=#use-cases-1>Use Cases</a></li>
+</ul>
+</li>
+<li><a href=#comparison-with-sort-by>Comparison with SORT BY</a></li>
+<li><a href=#limitations-and-considerations>Limitations and
Considerations</a></li>
+</ul>
+</li>
+</ul>
+</nav>
+</div>
+<div class=docs-article>
+<h1 id=apache-hive--write-ordering>Apache Hive : Write Ordering</h1>
+<h2 id=overview>Overview</h2>
+<p>Write ordering controls the physical layout of data within table files.
Unlike <code>SORT BY</code> which orders data during query execution, write
ordering is applied at write time and persists in the stored files.</p>
+<p>Write ordering is supported for Iceberg tables and can be specified during
table creation.</p>
+<p>Hive supports two write ordering strategies:</p>
+<ul>
+<li><strong>Regular Ordering</strong>: Sort by one or more columns in a
specified order</li>
+<li><strong>Z-Ordering</strong>: Multi-dimensional clustering using
space-filling curves</li>
+</ul>
+<hr>
+<h2 id=regular-column-ordering>Regular Column Ordering</h2>
+<h3 id=version>Version</h3>
+<p>Introduced in Hive version <a
href=https://issues.apache.org/jira/browse/HIVE-28586>4.1.0</a></p>
+<h3 id=syntax>Syntax</h3>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> <span style=color:#66d9ef>table_name</span>
(column_definitions)
+<span style=color:#66d9ef>WRITE</span> [LOCALLY] ORDERED <span
style=color:#66d9ef>BY</span> <span style=color:#66d9ef>column_name</span>
[<span style=color:#66d9ef>ASC</span> <span style=color:#f92672>|</span> <span
style=color:#66d9ef>DESC</span>] [NULLS <span style=color:#66d9ef>FIRST</span>
<span style=color:#f92672>|</span> NULLS <span style=color:#66d9ef>LAST</span>]
+ [, <span style=color:#66d9ef>column_name</span> [<span
style=color:#66d9ef>ASC</span> <span style=color:#f92672>|</span> <span
style=color:#66d9ef>DESC</span>] [NULLS <span style=color:#66d9ef>FIRST</span>
<span style=color:#f92672>|</span> NULLS <span style=color:#66d9ef>LAST</span>]
]<span style=color:#f92672>*</span>
+STORED <span style=color:#66d9ef>BY</span> ICEBERG
+[STORED <span style=color:#66d9ef>AS</span> file_format];
+</code></pre></div><h3 id=options>Options</h3>
+<ul>
+<li>Sort Order
+<ul>
+<li><code>ASC</code>: Ascending order (default)</li>
+<li><code>DESC</code>: Descending order</li>
+</ul>
+</li>
+<li>Null Order
+<ul>
+<li><code>NULLS FIRST</code>: Null values sorted before non-null values</li>
+<li><code>NULLS LAST</code>: Null values sorted after non-null values</li>
+</ul>
+</li>
+</ul>
+<h3 id=examples>Examples</h3>
+<p>Single column:</p>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> events (
+ event_id BIGINT,
+ event_date DATE,
+ event_type STRING
+)
+<span style=color:#66d9ef>WRITE</span> LOCALLY ORDERED <span
style=color:#66d9ef>BY</span> event_date <span style=color:#66d9ef>DESC</span>
+STORED <span style=color:#66d9ef>BY</span> ICEBERG
+STORED <span style=color:#66d9ef>AS</span> ORC;
+</code></pre></div><p>Multiple columns with null handling:</p>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> orders (
+ order_id BIGINT,
+ order_date DATE,
+ customer_id INT,
+ amount DECIMAL(<span style=color:#ae81ff>10</span>,<span
style=color:#ae81ff>2</span>)
+)
+<span style=color:#66d9ef>WRITE</span> ORDERED <span
style=color:#66d9ef>BY</span> order_date <span style=color:#66d9ef>DESC</span>
NULLS <span style=color:#66d9ef>FIRST</span>, order_id <span
style=color:#66d9ef>ASC</span>
+STORED <span style=color:#66d9ef>BY</span> ICEBERG;
+</code></pre></div><h3 id=use-cases>Use Cases</h3>
+<p>Regular ordering is most effective for:</p>
+<ul>
+<li>Time-series data with temporal access patterns</li>
+<li>Range queries on sorted columns</li>
+<li>Queries with consistent ORDER BY clauses</li>
+<li>Single-dimensional access patterns</li>
+</ul>
+<hr>
+<h2 id=z-ordering>Z-Ordering</h2>
+<h3 id=version-1>Version</h3>
+<p>Introduced in Hive version <a
href=https://issues.apache.org/jira/browse/HIVE-29133>4.2.0</a></p>
+<h3 id=overview-1>Overview</h3>
+<p>Z-order applies a multi-dimensional clustering technique based on
space-filling curves. This approach interleaves column values to co-locate
related records across multiple dimensions, enabling efficient filtering on
various column combinations.</p>
+<h3 id=syntax-1>Syntax</h3>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> <span style=color:#66d9ef>table_name</span>
(column_definitions)
+<span style=color:#66d9ef>WRITE</span> [LOCALLY] ORDERED <span
style=color:#66d9ef>BY</span> ZORDER(<span
style=color:#66d9ef>column_name</span> [, <span
style=color:#66d9ef>column_name</span> ]<span style=color:#f92672>*</span>)
+STORED <span style=color:#66d9ef>BY</span> ICEBERG
+[STORED <span style=color:#66d9ef>AS</span> file_format];
+</code></pre></div><h3 id=examples-1>Examples</h3>
+<p>Two columns:</p>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> user_events (
+ user_id INT,
+ event_date DATE,
+ event_type STRING,
+ value DOUBLE
+)
+<span style=color:#66d9ef>WRITE</span> LOCALLY ORDERED <span
style=color:#66d9ef>BY</span> ZORDER(user_id, event_date)
+STORED <span style=color:#66d9ef>BY</span> ICEBERG
+STORED <span style=color:#66d9ef>AS</span> ORC;
+</code></pre></div><p>Multiple columns:</p>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> analytics (
+ customer_id INT,
+ activity_date DATE,
+ country STRING,
+ product_id INT
+)
+<span style=color:#66d9ef>WRITE</span> ORDERED <span
style=color:#66d9ef>BY</span> ZORDER(customer_id, activity_date, country)
+STORED <span style=color:#66d9ef>BY</span> ICEBERG;
+</code></pre></div><h3 id=table-properties-method>Table Properties Method</h3>
+<p>Z-ordering can alternatively be specified using table properties.</p>
+<div class=highlight><pre tabindex=0
style=color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4><code
class=language-sql data-lang=sql><span style=color:#66d9ef>CREATE</span> <span
style=color:#66d9ef>TABLE</span> <span style=color:#66d9ef>table_name</span>
(column_definitions)
+STORED <span style=color:#66d9ef>BY</span> ICEBERG
+TBLPROPERTIES (
+ <span style=color:#e6db74>'sort.order'</span> <span
style=color:#f92672>=</span> <span style=color:#e6db74>'zorder'</span>,
+ <span style=color:#e6db74>'sort.columns'</span> <span
style=color:#f92672>=</span> <span
style=color:#e6db74>'column1,column2'</span>
+);
+</code></pre></div><h3 id=use-cases-1>Use Cases</h3>
+<p>Z-order is most effective for:</p>
+<ul>
+<li>Multi-dimensional analytical queries</li>
+<li>Ad-hoc queries with varying filter patterns</li>
+<li>Queries filtering on different column combinations</li>
+</ul>
+<hr>
+<h2 id=comparison-with-sort-by>Comparison with SORT BY</h2>
+<table>
+<thead>
+<tr>
+<th>Feature</th>
+<th>WRITE ORDERED BY</th>
+<th>SORT BY</th>
+</tr>
+</thead>
+<tbody>
+<tr>
+<td>Application</td>
+<td>Write time</td>
+<td>Query time</td>
+</tr>
+<tr>
+<td>Persistence</td>
+<td>Permanent in files</td>
+<td>Query result only</td>
+</tr>
+<tr>
+<td>Scope</td>
+<td>Physical file layout</td>
+<td>Query execution</td>
+</tr>
+<tr>
+<td>Table Support</td>
+<td>Iceberg tables</td>
+<td>All table types</td>
+</tr>
+</tbody>
+</table>
+<hr>
+<h2 id=limitations-and-considerations>Limitations and Considerations</h2>
+<ul>
+<li>Write ordering only applies to Iceberg tables</li>
+<li>Write operations incur ordering overhead:
+<ul>
+<li>Regular ordering: Sort cost</li>
+<li>Z-order: Sort cost plus z-value computation</li>
+</ul>
+</li>
+<li>Column selection should be based on query workload analysis</li>
+</ul>
+</div>
+<footer class=docs-footer>
+<div class=docs-feedback>
+<h4><i class="fas fa-comment"></i> Feedback</h4>
+<p>Was this page helpful? Let us know how we can improve.</p>
+<div class=docs-feedback-buttons>
+<button class="btn btn-feedback btn-positive">
+<i class="fas fa-thumbs-up"></i> Yes
+</button>
+<button class="btn btn-feedback btn-negative">
+<i class="fas fa-thumbs-down"></i> No
+</button>
+</div>
+</div>
+<div class=docs-edit>
+<a
href=https://github.com/apache/hive-site/edit/main/content/docs/latest/language/writeordering.md
class="btn btn-outline">
+<i class="fab fa-github"></i> Edit this page on GitHub
+</a>
+</div>
+</footer>
+</article>
+<aside class=docs-toc-sidebar>
+<div class=docs-toc-sticky>
+<h4><i class="fas fa-list"></i> On this page</h4>
+<nav id=TableOfContents>
+<ul>
+<li><a href=#apache-hive--write-ordering>Apache Hive : Write Ordering</a>
+<ul>
+<li><a href=#overview>Overview</a></li>
+<li><a href=#regular-column-ordering>Regular Column Ordering</a>
+<ul>
+<li><a href=#version>Version</a></li>
+<li><a href=#syntax>Syntax</a></li>
+<li><a href=#options>Options</a></li>
+<li><a href=#examples>Examples</a></li>
+<li><a href=#use-cases>Use Cases</a></li>
+</ul>
+</li>
+<li><a href=#z-ordering>Z-Ordering</a>
+<ul>
+<li><a href=#version-1>Version</a></li>
+<li><a href=#overview-1>Overview</a></li>
+<li><a href=#syntax-1>Syntax</a></li>
+<li><a href=#examples-1>Examples</a></li>
+<li><a href=#table-properties-method>Table Properties Method</a></li>
+<li><a href=#use-cases-1>Use Cases</a></li>
+</ul>
+</li>
+<li><a href=#comparison-with-sort-by>Comparison with SORT BY</a></li>
+<li><a href=#limitations-and-considerations>Limitations and
Considerations</a></li>
+</ul>
+</li>
+</ul>
+</nav>
+</div>
+</aside>
+</main>
+</div>
+</div>
+<footer class="black-background static-bottom" style=padding:30px>
+<div class=row>
+<div class=col-3>
+<a href=https://www.apache.org/>
+<img src=https://hive.apache.org/images/asf_logo.png width=270 height=100
alt="Apache Software Foundation"></a>
+</a>
+</div>
+<div class=col-9>
+<p class=footer-text>Apache is a non-profit organization helping open-source
+software projects released under the Apache
+<a href=https://www.apache.org/licenses/>license</a>
+and managed with
+<a href=https://www.apache.org/foundation/how-it-works.html>
+open governance</a> and
+<a href=https://privacy.apache.org/policies/privacy-policy-public.html>
+privacy policy</a>. See upcoming
+<a href=https://www.apache.org/events/current-event>Apache Events</a>.
+If you discover any
+<a href=https://www.apache.org/security/>security</a> vulnerabilities, please
+report them privately. Finally,
+<a href=https://www.apache.org/foundation/sponsorship.html>thanks
+</a> to the sponsors who
+<a href=https://www.apache.org/foundation/contributing.html>
+donate</a> to the Apache Foundation.
+</p>
+</div>
+</div>
+<div class="copyright row">
+<a href=https://hive.apache.org style=color:grey>
+The contents of this website are © 2023 Apache Software Foundation under the
terms of the Apache License v2. Apache Hive and its logo are trademarks of the
Apache Software Foundation.
+</a>
+</div>
+</footer>
+<script src=https://hive.apache.org/js/bootstrap.bundle.min.js></script>
+</body>
+</html>
\ No newline at end of file
diff --git a/index.json b/index.json
index 7df07e1..1ee4e2c 100644
--- a/index.json
+++ b/index.json
@@ -1 +1 @@
-[{"categories":null,"contents":"REST Catalog Integration Table of Contents
Hive + Gravitino + Keycloak Architecture Overview Prerequisites Quickstart
Configuration Keyclock Gravitino Hive Networking Notes Hive + Polaris
Architecture Overview Prerequisites Quickstart Configuration Polaris Hive
Networking Notes Hive + Gravitino + Keycloak The code for this setup is
located in the Hive repository in packaging/src/docker/thirdparties/gravitino
folder. It contains a docker-comp [...]
\ No newline at end of file
+[{"categories":null,"contents":"Apache Hive : Write Ordering Overview Write
ordering controls the physical layout of data within table files. Unlike SORT
BY which orders data during query execution, write ordering is applied at write
time and persists in the stored files.\nWrite ordering is supported for Iceberg
tables and can be specified during table creation.\nHive supports two write
ordering strategies:\n Regular Ordering: Sort by one or more columns in a
specified order Z-Ordering: [...]
\ No newline at end of file
diff --git a/index.xml b/index.xml
index 960b730..adc2bf8 100644
--- a/index.xml
+++ b/index.xml
@@ -1,4 +1,7 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0"
xmlns:atom="http://www.w3.org/2005/Atom";><channel><title>Apache Hive on Hive
Site</title><link>https://hive.apache.org/</link><description>Recent content in
Apache Hive on Hive Site</description><generator>Hugo --
gohugo.io</generator><language>en-us</language><lastBuildDate>Fri, 27 Jan 2023
19:16:15 +0530</lastBuildDate><atom:link
href="https://hive.apache.org/index.xml"; rel="self"
type="application/rss+xml"/><ite [...]
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0"
xmlns:atom="http://www.w3.org/2005/Atom";><channel><title>Apache Hive on Hive
Site</title><link>https://hive.apache.org/</link><description>Recent content in
Apache Hive on Hive Site</description><generator>Hugo --
gohugo.io</generator><language>en-us</language><lastBuildDate>Fri, 27 Jan 2023
19:16:15 +0530</lastBuildDate><atom:link
href="https://hive.apache.org/index.xml"; rel="self"
type="application/rss+xml"/><ite [...]
+Write ordering is supported for Iceberg tables and can be specified during
table creation.
+Hive supports two write ordering strategies:
+Regular Ordering: Sort by one or more columns in a specified order Z-Ordering:
Multi-dimensional clustering using space-filling curves Regular Column Ordering
Version Introduced in Hive version 4.</description></item><item><title>Hive
4.2.0 - REST Catalog
Integration</title><link>https://hive.apache.org/docs/latest/quickstart-rest-catalog/</link><pubDate>Fri,
31 Oct 2025 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/quickstart-rest-catalog/</guid><description>REST
Cat [...]
Metastore Schema Verification Introduced in Hive 0.12.0. See HIVE-3764.
Hive records the schema version in the metastore database and verifies that
the metastore schema version is compatible with Hive binaries that are going to
access the metastore.</description></item><item><title>Apache Hive : Setting Up
OAuth 2 with
Keycloak</title><link>https://hive.apache.org/docs/latest/admin/oauth2/keycloak/</link><pubDate>Tue,
30 Sep 2025 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/admin/oauth2/keycloak/</guid><description>Apache
Hive : Setting [...]
2. Define the &ldquo;catalog&rdquo; scope Iceberg REST Catalog uses
&ldquo;catalog&rdquo; as the default scope
name.</description></item><item><title>Capture Lineage Information In Hive
Hooks</title><link>https://hive.apache.org/docs/latest/user/capture-lineage-info/</link><pubDate>Tue,
29 Jul 2025 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/user/capture-lineage-info/</guid><description>Background
In Hive, lineage information is captured in the form [...]
@@ -149,7 +152,7 @@ Commands and CLIs
Commands Hive CLI (old) Beeline CLI (new) Variable Substitution HCatalog CLI
File Formats
Avro Files ORC Files Parquet Compressed Data Storage LZO Compression Data Types
Data Definition Statements
-DDL Statements Bucketed Tables Statistics (Analyze and Describe) Indexes
Archiving Data Manipulation Statements</description></item><item><title>Apache
Hive : LanguageManual
Archiving</title><link>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</guid><description>Apache
Hive : LanguageManual Archiving Archiving for File Count Reduction.
+DDL Statements Bucketed Tables Write Ordering (Regular &amp; Z-Order)
Statistics (Analyze and Describe) Indexes Archiving Data Manipulation
Statements</description></item><item><title>Apache Hive : LanguageManual
Archiving</title><link>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</link><pubDate>Thu,
12 Dec 2024 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/languagemanual-archiving/</guid><description>Apache
Hive : LanguageManual [...]
Apache Hive : LanguageManual Archiving Overview Settings Usage Archive
Unarchive Cautions and Limitations Under the Hood Overview Due to the design of
HDFS, the number of files in the filesystem directly affects the memory
consumption in the namenode. While normally not a problem for small clusters,
memory usage may hit the limits of accessible memory on a single machine when
there are &gt;50-100 million files.</description></item><item><title>Apache
Hive : LanguageManual Authorizati [...]
Apache Hive : LanguageManual Hive CLI Deprecation in favor of Beeline CLI Hive
Command Line Options Examples The hiverc File Logging Tool to Clear Dangling
Scratch Directories Hive Batch Mode Commands Hive Interactive Shell Commands
Hive Resources HCatalog CLI Deprecation in favor of Beeline CLI HiveServer2
(introduced in Hive 0.</description></item><item><title>Apache Hive :
LanguageManual
Commands</title><link>https://hive.apache.org/docs/latest/language/languagemanual-commands/</link>
[...]
Command Description quit exit Use quit or exit to leave the interactive shell.
reset Resets the configuration to the default values (as of Hive 0.10: see
HIVE-3202). Any configuration parameters that were set using the set command or
-hiveconf parameter in hive commandline will get reset to default
value.</description></item><item><title>Apache Hive : LanguageManual
DDL</title><link>https://hive.apache.org/docs/latest/language/languagemanual-ddl/</link><pubDate>Thu,
12 Dec 2024 00:00:00 [...]
diff --git a/sitemap.xml b/sitemap.xml
index fb8588f..2bac781 100644
--- a/sitemap.xml
+++ b/sitemap.xml
@@ -1 +1 @@
-<?xml version="1.0" encoding="utf-8" standalone="yes"?><urlset
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9";
xmlns:xhtml="http://www.w3.org/1999/xhtml";><url><loc>https://hive.apache.org/docs/</loc><lastmod>2025-10-31T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/quickstart-rest-catalog/</loc><lastmod>2025-10-31T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/admin/hive-schema-tool/</loc><lastmod>2025-10-14T00:00:00+00:00</la
[...]
\ No newline at end of file
+<?xml version="1.0" encoding="utf-8" standalone="yes"?><urlset
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9";
xmlns:xhtml="http://www.w3.org/1999/xhtml";><url><loc>https://hive.apache.org/docs/latest/language/writeordering/</loc><lastmod>2025-10-31T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/</loc><lastmod>2025-10-31T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/quickstart-rest-catalog/</loc><lastmod>2025-10-31T00:00:00+00:00</la
[...]
\ No newline at end of file
