This is an automated email from the ASF dual-hosted git repository.
github-actions[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 c5ddf3b5 deploy: 6303885c2dd175cbde217ed5e05743bf5a2c3f99
c5ddf3b5 is described below
commit c5ddf3b5f2eb62cd81a384a7e9ab3d134fe6d152
Author: zabetak <[email protected]>
AuthorDate: Tue Jun 9 07:42:40 2026 +0000
deploy: 6303885c2dd175cbde217ed5e05743bf5a2c3f99
---
docs/latest/hcatalog/hcatalog-cli/index.html | 2 +-
.../hcatalog/hcatalog-inputoutput/index.html | 2 +-
docs/latest/hcatalog/hcatalog-loadstore/index.html | 2 +-
.../index.html | 2 +-
docs/latest/language/hive-udfs/index.html | 2 +-
docs/latest/language/index.html | 8 +--
docs/latest/language/index.xml | 74 +++++++++++-----------
docs/latest/language/languagemanual-cli/index.html | 4 +-
.../language/languagemanual-commands/index.html | 2 +-
docs/latest/language/languagemanual-ddl/index.html | 2 +-
docs/latest/language/languagemanual-dml/index.html | 2 +-
.../language/languagemanual-lateralview/index.html | 2 +-
docs/latest/language/languagemanual-orc/index.html | 2 +-
docs/latest/language/scheduled-queries/index.html | 2 +-
.../index.html | 4 +-
.../supported-features-apache-hive-2-1/index.html | 2 +-
.../supported-features-apache-hive-2-3/index.html | 2 +-
docs/latest/language/supported-features/index.html | 2 +-
index.json | 2 +-
index.xml | 74 +++++++++++-----------
20 files changed, 97 insertions(+), 97 deletions(-)
diff --git a/docs/latest/hcatalog/hcatalog-cli/index.html
b/docs/latest/hcatalog/hcatalog-cli/index.html
index 4081f460..d84feebd 100644
--- a/docs/latest/hcatalog/hcatalog-cli/index.html
+++ b/docs/latest/hcatalog/hcatalog-cli/index.html
@@ -4,7 +4,7 @@
<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 : HCatalog CLI</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : HCatalog CLI</h1><div class=docs-meta><spa [...]
Last updated: December 12, 2024</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--hcatalog-command-line-interface>Apache Hive : HCatalog
Command Line Interface</a><ul><li><a href=#set-up>Set Up</a></li><li><a
href=#hcatalog-cli>HCatalog CLI</a><ul><li><a href=#owner-permissions>Owner
Permissions</a></li><li><a href=#hive-cli>Hive CLI</a></li></ul></li><li><a
href=#hcatalog-ddl>HCatalog DDL< [...]
-</code></pre><h3 id=owner-permissions>Owner Permissions</h3><p>When using the
HCatalog CLI, you cannot specify a permission string without read permissions
for owner, such as <code>-wxrwxr-x</code>, because the string begins with
“<code>-</code>”. If such a permission setting is desired, you can
use the octal version instead, which in this case would be 375. Also, any other
kind of permission string where the owner has read permissions (for example
<code>r-x-----</code> or <c [...]
+</code></pre><h3 id=owner-permissions>Owner Permissions</h3><p>When using the
HCatalog CLI, you cannot specify a permission string without read permissions
for owner, such as <code>-wxrwxr-x</code>, because the string begins with
“<code>-</code>”. If such a permission setting is desired, you can
use the octal version instead, which in this case would be 375. Also, any other
kind of permission string where the owner has read permissions (for example
<code>r-x-----</code> or <c [...]
Previous: <a
href=https://hive.apache.org/docs/latest/hcatalog/hcatalog-readerwriter/>Reader
and Writer Interfaces</a><br>Next: <a
href=https://hive.apache.org/docs/latest/hcatalog/hcatalog-storageformats/>Storage
Formats</a></p><p>Hive command line interface: <a
href=https://hive.apache.org/docs/latest/language/languagemanual-cli/>Hive
CLI</a><br>Hive DDL commands: <a
href=https://hive.apache.org/docs/latest/language/languagemanual-ddl/>Hive Data
Definition Language</a><br>WebHCat DDL r [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
diff --git a/docs/latest/hcatalog/hcatalog-inputoutput/index.html
b/docs/latest/hcatalog/hcatalog-inputoutput/index.html
index a21dcb18..d98f3c16 100644
--- a/docs/latest/hcatalog/hcatalog-inputoutput/index.html
+++ b/docs/latest/hcatalog/hcatalog-inputoutput/index.html
@@ -102,7 +102,7 @@ hdfs:///tmp/jdo2-api-2.3-ec.jar,
hdfs:///tmp/slf4j-api-1.6.1.jar
# (Other statements remain the same.)
-</code></pre><h3 id=authentication>Authentication</h3><p>If a failure results
in a message like “2010-11-03 16:17:28,225 WARN hive.metastore … -
Unable to connect metastore with URI thrift://…” in
<code>/tmp/</code><em></em><code>/hive.log</code>, then make sure you have run
“<code>kinit</code> <em></em><code>@FOO.COM</code>” to get a
Kerberos ticket and to be able to authenticate to the HCatalog server.</p><h3
id=read-example>Read Example</h3><p>The fol [...]
+</code></pre><h3 id=authentication>Authentication</h3><p>If a failure results
in a message like “2010-11-03 16:17:28,225 WARN hive.metastore … -
Unable to connect metastore with URI thrift://…” in
<code>/tmp/<username>/hive.log</code>, then make sure you have run
“<code>kinit <username>@FOO.COM</code>” to get a Kerberos ticket
and to be able to authenticate to the HCatalog server.</p><h3
id=read-example>Read Example</h3><p>The following very simple [...]
public static class Map extends
Mapper<WritableComparable, HCatRecord, IntWritable,
IntWritable> {
diff --git a/docs/latest/hcatalog/hcatalog-loadstore/index.html
b/docs/latest/hcatalog/hcatalog-loadstore/index.html
index c54d9d29..162922ea 100644
--- a/docs/latest/hcatalog/hcatalog-loadstore/index.html
+++ b/docs/latest/hcatalog/hcatalog-loadstore/index.html
@@ -26,7 +26,7 @@ $HCAT_HOME/share/hcatalog/hcatalog-pig-adapter*.jar:\
$HIVE_HOME/lib/hive-metastore-*.jar:$HIVE_HOME/lib/libthrift-*.jar:\
$HIVE_HOME/lib/hive-exec-*.jar:$HIVE_HOME/lib/libfb303-*.jar:\
$HIVE_HOME/lib/jdo2-api-*-ec.jar:$HIVE_HOME/lib/slf4j-api-*.jar
<script.pig>
-</code></pre><p>The version number found in each filepath will be substituted
for *. For example, HCatalog release 0.5.0 uses these jars and conf
files:</p><ul><li><code>$HCAT_HOME/share/hcatalog/hcatalog-core-0.5.0.jar</code></li><li><code>$HCAT_HOME/share/hcatalog/hcatalog-pig-adapter-0.5.0.jar</code></li><li><code>$HIVE_HOME/lib/hive-metastore-0.10.0.jar</code></li><li><code>$HIVE_HOME/lib/libthrift-0.7.0.jar</code></li><li><code>$HIVE_HOME/lib/hive-exec-0.10.0.jar</code></li><li><cod
[...]
+</code></pre><p>The version number found in each filepath will be substituted
for *. For example, HCatalog release 0.5.0 uses these jars and conf
files:</p><ul><li><code>$HCAT_HOME/share/hcatalog/hcatalog-core-0.5.0.jar</code></li><li><code>$HCAT_HOME/share/hcatalog/hcatalog-pig-adapter-0.5.0.jar</code></li><li><code>$HIVE_HOME/lib/hive-metastore-0.10.0.jar</code></li><li><code>$HIVE_HOME/lib/libthrift-0.7.0.jar</code></li><li><code>$HIVE_HOME/lib/hive-exec-0.10.0.jar</code></li><li><cod
[...]
A = LOAD 'tablename' USING org.apache.hive.hcatalog.pig.HCatLoader();
...
...
diff --git
a/docs/latest/language/cast-format-with-sql2016-datetime-formats/index.html
b/docs/latest/language/cast-format-with-sql2016-datetime-formats/index.html
index 2591c092..7fa3a1f2 100644
--- a/docs/latest/language/cast-format-with-sql2016-datetime-formats/index.html
+++ b/docs/latest/language/cast-format-with-sql2016-datetime-formats/index.html
@@ -7,7 +7,7 @@ Last updated: December 12, 2024</span></div></header><div
class=docs-toc><h4><i
CAST(<varchar/char/string> AS <timestamp/date> [FORMAT
<template>])
</code></pre><h2 id=example>Example</h2><pre tabindex=0><code>select cast(dt
as string format 'DD-MM-YYYY')
select cast('01-05-2017' as date format 'DD-MM-YYYY')
-</code></pre><h2
id=template-elements-aka-tokens-aka-patterns-aka-sql2016-datetime-formats>Template
elements, a.k.a. Tokens, a.k.a Patterns a.k.a SQL:2016 Datetime
Formats</h2><h3 id=notes>Notes</h3><p>For all tokens:</p><ul><li>Patterns are
case-insensitive, except AM/PM and T/Z. See these sections for more
details.</li><li>For string to datetime conversion, no duplicate format tokens
are allowed, including tokens<br>that have the same meaning but different
lengths (“Y” and [...]
+</code></pre><h2
id=template-elements-aka-tokens-aka-patterns-aka-sql2016-datetime-formats>Template
elements, a.k.a. Tokens, a.k.a Patterns a.k.a SQL:2016 Datetime
Formats</h2><h3 id=notes>Notes</h3><p>For all tokens:</p><ul><li>Patterns are
case-insensitive, except AM/PM and T/Z. See these sections for more
details.</li><li>For string to datetime conversion, no duplicate format tokens
are allowed, including tokens<br>that have the same meaning but different
lengths (“Y” and [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/hive-udfs/index.html
b/docs/latest/language/hive-udfs/index.html
index ceabef2c..8d65a9df 100644
--- a/docs/latest/language/hive-udfs/index.html
+++ b/docs/latest/language/hive-udfs/index.html
@@ -4,7 +4,7 @@
<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 : Hive UDFs</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : Hive UDFs</h1><div class=docs-meta><span clas
[...]
Last updated: December 12, 2024</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--hive-udfs>Apache Hive : Hive
UDFs</a><ul><li><a href=#overview>Overview</a></li><li><a
href=#available-function>Available function</a><ul><li><a
href=#built-in-aggregate-functions-udaf>Built-in Aggregate Functions
(UDAF)</a></li><li><a href=#built-in-table-generating-functions-udtf>Built-in
Table-Generating Fu [...]
-</code></pre><p>In this case, the <strong>length</strong> of thebuilt-in UDF
evaluates each row of the string_col values. </p><p>As we see how a built-in
UDF works let’s see what kind of built-in UDFs the Apache Hive
has.</p><p>Tipp</p><p>All Hive keywords are <strong>case-insensitive</strong>,
including the names of Hive operators and functions. I.e: length and LENGTH are
also accepted by the Hive.</p><h2 id=available-function>Available
function</h2><h3 id=built-in-aggregate-funct [...]
+</code></pre><p>In this case, the <strong>length</strong> of thebuilt-in UDF
evaluates each row of the string_col values. </p><p>As we see how a built-in
UDF works let’s see what kind of built-in UDFs the Apache Hive
has.</p><p>Tipp</p><p>All Hive keywords are <strong>case-insensitive</strong>,
including the names of Hive operators and functions. I.e: length and LENGTH are
also accepted by the Hive.</p><h2 id=available-function>Available
function</h2><h3 id=built-in-aggregate-funct [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/index.html b/docs/latest/language/index.html
index 2ff9388a..e32fe436 100644
--- a/docs/latest/language/index.html
+++ b/docs/latest/language/index.html
@@ -36,7 +36,7 @@ Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--langua
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-archiving>Apache Hive : LanguageManual
Archiving</h1><p>Archiving for File Count Reduction.</p><h2
id=overview>Overview</h2><p>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 >50-100 million f [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-authorization>Apache Hive : LanguageManual
Authorization</h1><h2 id=introduction>Introduction</h2><p>Note that this
documentation is referring to Authorization which is verifying if a user has
permission to perform a certain action, and not about Authentication (verifying
the identity of the user). Strong authentication for tools like the <a
href=https://hive.apache.org/docs/latest/language/languagem [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-hive-cli>Apache Hive : LanguageManual Hive
CLI</h1><p>$HIVE_HOME/bin/hive is a shell utility which can be used to run Hive
queries in either interactive or batch mode.</p><h1
id=deprecation-in-favor-of-beeline-cli>Deprecation in favor of Beeline
CLI</h1><p>HiveServer2 (introduced in Hive 0.11) has its own CLI called <a
href=#beeline>Beeline</a>, which is a JDBC client based on SQLLine. Due to new
de [...]
-Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-commands>Apache Hive : LanguageManual
Commands</h1><p>Commands are non-SQL statements such as setting a property or
adding a resource. They can be used in HiveQL scripts or directly in the <a
href=https://hive.apache.org/docs/latest/language/languagemanual-cli/>CLI</a>
or <a
href=#beeline>Beeline</a>.</p><table><thead><tr><th>Command</th><th>Description</th></tr></thead><tbody><tr><td>quit
exit</td>< [...]
+Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-commands>Apache Hive : LanguageManual
Commands</h1><p>Commands are non-SQL statements such as setting a property or
adding a resource. They can be used in HiveQL scripts or directly in the <a
href=https://hive.apache.org/docs/latest/language/languagemanual-cli/>CLI</a>
or <a
href=#beeline>Beeline</a>.</p><table><thead><tr><th>Command</th><th>Description</th></tr></thead><tbody><tr><td><code>quit
exit [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-ddl>Apache Hive : LanguageManual DDL</h1><h2
id=overview>Overview</h2><p>HiveQL DDL statements are documented here,
including:</p><ul><li>CREATE DATABASE/SCHEMA, TABLE, VIEW, FUNCTION,
INDEX</li><li>DROP DATABASE/SCHEMA, TABLE, VIEW, INDEX</li><li>TRUNCATE
TABLE</li><li>ALTER DATABASE/SCHEMA, TABLE, VIEW</li><li>MSCK REPAIR TABLE (or
ALTER TABLE RECOVER PARTITIONS)</li><li>SHOW DATABASES/SCHEMAS, TAB [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-ddl-bucketedtables>Apache Hive : LanguageManual
DDL BucketedTables</h1><p>This is a brief example on creating and populating
bucketed tables. (For another example, see <a
href=#bucketed-sorted-tables>Bucketed Sorted Tables</a>.)</p><p>Bucketed tables
are fantastic in that they allow much more efficient <a
href=https://hive.apache.org/docs/latest/language/languagemanual-sampling/>sampling</a>
than do [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--languagemanual-dml>Apache Hive : LanguageManual DML</h1><h1
id=hive-data-manipulation-language>Hive Data Manipulation Language</h1><h3
id=loading-files-into-tables>Loading files into tables</h3><p>Hive does not do
any transformation while loading data into tables. Load operations are
currently pure copy/move operations that move datafiles into locations
corresponding to Hive tables.</p><h5 id=syntax>Syntax</h5><pre [...]
@@ -127,9 +127,9 @@ Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--reflec
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--scheduled-queries>Apache Hive : Scheduled Queries</h1><h1
id=introduction>Introduction</h1><p>Executing statements periodically can be
usefull in</p><ul><li>Pulling informations from external
systems</li><li>Periodically updating column statistics</li><li>Rebuilding
materialized views</li></ul><p>Overview</p><ul><li>The metastore maintains the
scheduled queries in the metastore database</li><li>Hiveserver(s) period [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--sql-standard-based-hive-authorization>Apache Hive : SQL
Standard Based Hive Authorization</h1><h1
id=status-of-hive-authorization-before-hive-013>Status of Hive Authorization
before Hive 0.13</h1><p>The <a href=#default-authorization-in-hive>default
authorization in Hive</a> is not designed with the intent to protect against
malicious users accessing data they should not be accessing. It only helps in
preventing us [...]
Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--statistics-and-data-mining>Apache Hive : Statistics and Data
Mining</h1><p>This page is the secondary documentation for the slightly more
advanced statistical and data mining functions that are being integrated into
Hive, and especially the functions that warrant more than one-line
descriptions.</p><h2
id=ngrams-and-context_ngrams-n-gram-frequency-estimation>ngrams() and
context_ngrams(): N-gram frequency estimatio [...]
-Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</h1><p>This table covers all mandatory features from
<a href=https://en.wikipedia.org/wiki/SQL:2016>SQL:2016</a> as well as optional
features that Hive implements.</p><table><thead><tr><th><strong>Feature
ID</strong></th><th><strong>Feature
Name</strong></th><th><strong>Implemented</strong></th><th><strong>Mandatory</strong></th><th
[...]
-Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive
2.1</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive
2.1</th><th>Comment</th></tr></thead><tbody><tr><td>E011</td><td>Numeric data
types</td><td>Yes</td><td></td></tr><tr><td>E011-01</td><td>INTEGER and
SMALLINT data types (including all spellings)</td><td>Yes</td><td>Int instead
of Integer</td></tr><tr><td>E011-02< [...]
-Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive
2.3</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive
2.3</th><th>Comment</th></tr></thead><tbody><tr><td>E011</td><td>Numeric data
types</td><td>Yes</td><td></td></tr><tr><td>E011-01</td><td>INTEGER and
SMALLINT data types (including all
spellings)</td><td>Yes</td><td></td></tr><tr><td>E011-02</td><td>REAL, DOUBLE P
[...]
+Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</h1><p>This table covers all mandatory features from
<a href=https://en.wikipedia.org/wiki/SQL:2016>SQL:2016</a> as well as optional
features that Hive implements.</p><table><thead><tr><th><strong>Feature
ID</strong></th><th><strong>Feature
Name</strong></th><th><strong>Implemented</strong></th><th><strong>Mandatory</strong></th><th
[...]
+Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive
2.1</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive
2.1</th><th>Comment</th></tr></thead><tbody><tr><td>E011</td><td>Numeric data
types</td><td>Yes</td><td></td></tr><tr><td>E011-01</td><td>INTEGER and
SMALLINT data types (including all spellings)</td><td>Yes</td><td>Int instead
of Integer</td></tr><tr><td>E011-02< [...]
+Dec 12, 2024</span></div><div class=docs-card-summary><h1
id=apache-hive--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive
2.3</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive
2.3</th><th>Comment</th></tr></thead><tbody><tr><td>E011</td><td>Numeric data
types</td><td>Yes</td><td></td></tr><tr><td>E011-01</td><td>INTEGER and
SMALLINT data types (including all
spellings)</td><td>Yes</td><td></td></tr><tr><td>E011-02</td><td>REAL, DOUBLE P
[...]
software projects released under the Apache
<a href=https://www.apache.org/licenses/>license</a>
and managed with
diff --git a/docs/latest/language/index.xml b/docs/latest/language/index.xml
index b7e50626..46120826 100644
--- a/docs/latest/language/index.xml
+++ b/docs/latest/language/index.xml
@@ -200,71 +200,71 @@ public final class Lower extends UDF {
</thead>
<tbody>
<tr>
- <td>quit exit</td>
+ <td><code>quit exit</code></td>
<td>Use quit or exit to leave the interactive shell.</td>
</tr>
<tr>
- <td>reset</td>
+ <td><code>reset</code></td>
<td>Resets the configuration to the default values (as of Hive 0.10:
see <a
href="https://issues.apache.org/jira/browse/HIVE-3202">HIVE-3202</a>).
Any configuration parameters that were set using the set command or -hiveconf
parameter in hive commandline will get reset to default value.Note that this
does not apply to configuration parameters that were set in set command using
the &ldquo;hiveconf:&rdquo; prefix for the key name (for historic
reasons).</td>
</tr>
<tr>
- <td>set <!-- raw HTML omitted -->=<!-- raw HTML omitted
--></td>
+ <td><code>set
&lt;key&gt;=&lt;value&gt;</code></td>
<td>Sets the value of a particular configuration variable (key).
<strong>Note:</strong> If you misspell the variable name, the CLI
will not show an error.</td>
</tr>
<tr>
- <td>set</td>
+ <td><code>set</code></td>
<td>Prints a list of configuration variables that are overridden by the
user or Hive.</td>
</tr>
<tr>
- <td>set -v</td>
+ <td><code>set -v</code></td>
<td>Prints all Hadoop and Hive configuration variables.</td>
</tr>
<tr>
- <td>add FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add ARCHIVE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->*</td>
+ <td><code>add FILE[S] &lt;filepath&gt;
&lt;filepath&gt;*</code> <code>add JAR[S]
&lt;filepath&gt; &lt;filepath&gt;*</code> <code>add
ARCHIVE[S] &lt;filepath&gt;
&lt;filepath&gt;*</code></td>
<td>Adds one or more files, jars, or archives to the list of resources
in the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>add FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add ARCHIVE[S]<!-- raw HTML omitted --> <!-- raw HTML
omitted -->*</td>
+ <td><code>add FILE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code> <code>add JAR[S]
&lt;ivyurl&gt; &lt;ivyurl&gt;*</code> <code>add
ARCHIVE[S]&lt;ivyurl&gt; &lt;ivyurl&gt;*</code></td>
<td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
adds one or more files, jars or archives to the list of resources in the
distributed cache using an <a
href="http://ant.apache.org/ivy/">Ivy</a> URL of the form
ivy://group:module:version?query_string. See <a
href="#hive-resources">Hive Resources</a> for more
information.</td>
</tr>
<tr>
- <td>list FILE[S] list JAR[S] list ARCHIVE[S]</td>
+ <td><code>list FILE[S]</code> <code>list
JAR[S]</code> <code>list ARCHIVE[S]</code></td>
<td>Lists the resources already added to the distributed cache. See
<a href="#hive-resources">Hive Resources</a> for more
information.</td>
</tr>
<tr>
- <td>list FILE[S] <!-- raw HTML omitted -->* list JAR[S] <!--
raw HTML omitted -->* list ARCHIVE[S] <!-- raw HTML omitted
-->*</td>
+ <td><code>list FILE[S] &lt;filepath&gt;*</code>
<code>list JAR[S] &lt;filepath&gt;*</code> <code>list
ARCHIVE[S] &lt;filepath&gt;*</code></td>
<td>Checks whether the given resources are already added to the
distributed cache or not. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>delete FILE[S] <!-- raw HTML omitted -->* delete JAR[S]
<!-- raw HTML omitted -->* delete ARCHIVE[S] <!-- raw HTML omitted
-->*</td>
+ <td><code>delete FILE[S] &lt;filepath&gt;*</code>
<code>delete JAR[S] &lt;filepath&gt;*</code>
<code>delete ARCHIVE[S] &lt;filepath&gt;*</code></td>
<td>Removes the resource(s) from the distributed cache.</td>
</tr>
<tr>
- <td>delete FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* delete JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* delete ARCHIVE[S] <!-- raw HTML omitted --> <!-- raw
HTML omitted -->*</td>
- <td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
removes the resource(s) which were added using the <!-- raw HTML omitted
--> from the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
+ <td><code>delete FILE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code> <code>delete JAR[S]
&lt;ivyurl&gt; &lt;ivyurl&gt;*</code> <code>delete
ARCHIVE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code></td>
+ <td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
removes the resource(s) which were added using the &lt;ivyurl&gt; from
the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>! <!-- raw HTML omitted --></td>
+ <td><code>! &lt;command&gt;</code></td>
<td>Executes a shell command from the Hive shell.</td>
</tr>
<tr>
- <td>dfs <!-- raw HTML omitted --></td>
+ <td><code>dfs &lt;dfs command&gt;</code></td>
<td>Executes a dfs command from the Hive shell.</td>
</tr>
<tr>
- <td><!-- raw HTML omitted --></td>
+ <td><code>&lt;query string&gt;</code></td>
<td>Executes a Hive query and prints results to standard
output.</td>
</tr>
<tr>
- <td>source FILE <!-- raw HTML omitted --></td>
+ <td><code>source FILE
&lt;filepath&gt;</code></td>
<td>Executes a script file inside the CLI.</td>
</tr>
<tr>
- <td>compile <code>&lt;groovy string&gt;</code> AS
GROOVY NAMED <!-- raw HTML omitted --></td>
+ <td><code>compile `&lt;groovy string&gt;` AS GROOVY NAMED
&lt;name&gt;</code></td>
<td>This allows inline Groovy code to be compiled and be used as a UDF
(as of Hive <a
href="https://issues.apache.org/jira/browse/HIVE-5252">0.13.0</a>).
For a usage example, see <a
href="https://hive.apache.org/attachments/27362054/HiveContrib-Nov13-groovy_plus_hive.pptx">Nov.
2013 Hive Contributors Meetup Presentations – Using Dynamic Compilation with
Hive</a>.</td>
</tr>
<tr>
- <td>show processlist</td>
+ <td><code>show processlist</code></td>
<td>Displays information about the operations currently running on
HiveServer2. It helps to troubleshoot issues such as long running queries,
connection starvation, etc. The command was introduced in <a
href="https://issues.apache.org/jira/browse/HIVE-27829">HIVE-27829</a>.</td>
</tr>
</tbody>
@@ -886,7 +886,7 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td>Mandatory</td>
<td></td>
@@ -2006,56 +2006,56 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>F850</td>
- <td>Top level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F856</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;fetch first clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F857</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;fetch first clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F858</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;fetch first clause&gt; in subqueries</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F859</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;fetch first clause&gt; in views</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
@@ -2498,7 +2498,7 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -3068,25 +3068,25 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>F850</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -3434,7 +3434,7 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -4094,25 +4094,25 @@ $ hive -e &#34; describe $a &#34;
</tr>
<tr>
<td>F850</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
diff --git a/docs/latest/language/languagemanual-cli/index.html
b/docs/latest/language/languagemanual-cli/index.html
index dd5a8838..05efc99f 100644
--- a/docs/latest/language/languagemanual-cli/index.html
+++ b/docs/latest/language/languagemanual-cli/index.html
@@ -27,7 +27,7 @@ Last updated: December 12, 2024</span></div></header><div
class=docs-toc><h4><i
$HIVE_HOME/bin/hive -f s3://mys3bucket/s3-script.sql
</code></pre><ul><li>Example of running an initialization script before
entering interactive mode</li></ul><pre tabindex=0><code>$HIVE_HOME/bin/hive -i
/home/my/hive-init.sql
</code></pre><h3 id=the-hiverc-file>The hiverc File</h3><p>The CLI when
invoked without the <code>-i</code> option will attempt to load
$HIVE_HOME/bin/.hiverc and $HOME/.hiverc as initialization files.</p><h3
id=logging>Logging</h3><p>Hive uses log4j for logging. These logs are not
emitted to the standard output by default but are instead captured to a log
file specified by Hive’s log4j properties file. By default Hive will use
<code>hive-log4j.default</code> in the <code>conf/</co [...]
-</code></pre><p><code>hive.root.logger</code> specifies the logging level as
well as the log destination. Specifying <code>console</code> as the target
sends the logs to the standard error (instead of the log file).</p><p>See <a
href=#hive-logging-in-getting-started>Hive Logging in Getting Started</a> for
more information.</p><h3 id=tool-to-clear-dangling-scratch-directories>Tool to
Clear Dangling Scratch Directories</h3><p>See <a
href=#scratch-directory-management>Scratch Directory Mana [...]
+</code></pre><p><code>hive.root.logger</code> specifies the logging level as
well as the log destination. Specifying <code>console</code> as the target
sends the logs to the standard error (instead of the log file).</p><p>See <a
href=#hive-logging-in-getting-started>Hive Logging in Getting Started</a> for
more information.</p><h3 id=tool-to-clear-dangling-scratch-directories>Tool to
Clear Dangling Scratch Directories</h3><p>See <a
href=#scratch-directory-management>Scratch Directory Mana [...]
hive> set;
hive> select a.* from tab1;
hive> !ls;
@@ -43,7 +43,7 @@ $HIVE_HOME/bin/hive -f s3://mys3bucket/s3-script.sql
USING 'python tt.py' as nn where a.ds =
'2009-01-04' limit 10;
</code></pre><p> </p><p> </p><p>Version 1.2.0</p><p>As of <a
href=https://issues.apache.org/jira/browse/HIVE-9664>Hive 1.2.0</a>, resources
can be added and deleted using <a href=http://ant.apache.org/ivy/>Ivy</a> URLs
of the form ivy://group:module:version?query_string.</p><ul><li><em>group</em>
– Which module group the module comes from. Translates directly to a Maven
groupId or an Ivy Organization.</li><li><em>module</em> – The name of the
module to load. Translates directly to a Mave [...]
DELETE { FILE[S] | JAR[S] | ARCHIVE[S] } <ivy://org:module:version>
<ivy://org:module:version>*
-</code></pre><p>Also, we can mix and in the same ADD and DELETE
commands.</p><pre tabindex=0><code>ADD { FILE[S] | JAR[S] | ARCHIVE[S] } {
<ivyurl> | <filepath> } <ivyurl>* <filepath>*
+</code></pre><p>Also, we can mix <ivyurl> and <filepath> in the same ADD
and DELETE commands.</p><pre tabindex=0><code>ADD { FILE[S] | JAR[S] |
ARCHIVE[S] } { <ivyurl> | <filepath> } <ivyurl>*
<filepath>*
DELETE { FILE[S] | JAR[S] | ARCHIVE[S] } { <ivyurl> | <filepath> }
<ivyurl>* <filepath>*
</code></pre><p>The different parameters that can be passed
are:</p><ol><li><em>exclude</em>: Takes a comma separated value of the form
org:module.</li><li><em>transitive</em>: Takes values true or false. Defaults
to true. When transitive = true, all the transitive dependencies are downloaded
and added to the classpath.</li><li><em>ext</em>: The extension of the file to
add. ‘jar’ by default.</li><li><em>classifier</em>: The maven
classifier to resolve by.</li></ol><p>Example [...]
hive>ADD JAR
ivy://org.apache.pig:pig:0.10.0?exclude=org.apache.hadoop:avro&transitive=false;
diff --git a/docs/latest/language/languagemanual-commands/index.html
b/docs/latest/language/languagemanual-commands/index.html
index fd902179..c14fb174 100644
--- a/docs/latest/language/languagemanual-commands/index.html
+++ b/docs/latest/language/languagemanual-commands/index.html
@@ -3,7 +3,7 @@
<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-it [...]
<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 : LanguageManual Commands</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : LanguageManual Commands</h1><di [...]
-Last updated: December 12, 2024</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--languagemanual-commands>Apache
Hive : LanguageManual Commands</a></li></ul></nav></div><div
class=docs-article><h1 id=apache-hive--languagemanual-commands>Apache Hive :
LanguageManual Commands</h1><p>Commands are non-SQL statements such as setting
a property or adding a resource. They can be used in HiveQL scr [...]
+Last updated: December 12, 2024</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--languagemanual-commands>Apache
Hive : LanguageManual Commands</a></li></ul></nav></div><div
class=docs-article><h1 id=apache-hive--languagemanual-commands>Apache Hive :
LanguageManual Commands</h1><p>Commands are non-SQL statements such as setting
a property or adding a resource. They can be used in HiveQL scr [...]
hive> set;
hive> select a.* from tab1;
hive> !ls;
diff --git a/docs/latest/language/languagemanual-ddl/index.html
b/docs/latest/language/languagemanual-ddl/index.html
index 8b8ffd49..b42da6df 100644
--- a/docs/latest/language/languagemanual-ddl/index.html
+++ b/docs/latest/language/languagemanual-ddl/index.html
@@ -115,7 +115,7 @@ constraint_specification:
[, CONSTRAINT constraint_name FOREIGN KEY (col_name, ...) REFERENCES
table_name(col_name, ...) DISABLE NOVALIDATE
[, CONSTRAINT constraint_name UNIQUE (col_name, ...) DISABLE NOVALIDATE
RELY/NORELY ]
[, CONSTRAINT constraint_name CHECK [check_expression] ENABLE|DISABLE
NOVALIDATE RELY/NORELY ]
-</code></pre><p>CREATE TABLE creates a table with the given name. An error is
thrown if a table or view with the same name already exists. You can use IF NOT
EXISTS to skip the error.</p><ul><li>Table names and column names are case
insensitive but SerDe and property names are case sensitive.<ul><li>In Hive
0.12 and earlier, only alphanumeric and underscore characters are allowed in
table and column names.</li><li>In Hive 0.13 and later, column names can
contain any <a href=http://en.wik [...]
+</code></pre><p>CREATE TABLE creates a table with the given name. An error is
thrown if a table or view with the same name already exists. You can use IF NOT
EXISTS to skip the error.</p><ul><li>Table names and column names are case
insensitive but SerDe and property names are case sensitive.<ul><li>In Hive
0.12 and earlier, only alphanumeric and underscore characters are allowed in
table and column names.</li><li>In Hive 0.13 and later, column names can
contain any <a href=http://en.wik [...]
date date,
name varchar
</code></pre><p>Now you want to partition on date. Your Hive definition could
use “dtDontQuery” as a column name so that “date” can
be used for partitioning (and
querying).</p><p><strong>Example:</strong></p><pre tabindex=0><code>create
table table_name (
diff --git a/docs/latest/language/languagemanual-dml/index.html
b/docs/latest/language/languagemanual-dml/index.html
index 0ae102ab..0a9ab560 100644
--- a/docs/latest/language/languagemanual-dml/index.html
+++ b/docs/latest/language/languagemanual-dml/index.html
@@ -76,7 +76,7 @@ ON <boolean expression1>
WHEN MATCHED [AND <boolean expression2>] THEN UPDATE SET <set clause
list>
WHEN MATCHED [AND <boolean expression3>] THEN DELETE
WHEN NOT MATCHED [AND <boolean expression4>] THEN INSERT VALUES<value
list>
-</code></pre><h5 id=synopsis-6>Synopsis</h5><ul><li><a
href=https://en.wikipedia.org/wiki/Merge_(SQL)>Merge</a> allows actions to be
performed on a target table based on the results of a join with a source
table.</li><li>In Hive 2.2, upon successful completion of this operation the
changes will be auto-committed.</li></ul><h5 id=performance-note>Performance
Note</h5><p>SQL Standard requires that an error is raised if the ON clause is
such that more than 1 row in source matches a row in t [...]
+</code></pre><h5 id=synopsis-6>Synopsis</h5><ul><li><a
href=https://en.wikipedia.org/wiki/Merge_(SQL)>Merge</a> allows actions to be
performed on a target table based on the results of a join with a source
table.</li><li>In Hive 2.2, upon successful completion of this operation the
changes will be auto-committed.</li></ul><h5 id=performance-note>Performance
Note</h5><p>SQL Standard requires that an error is raised if the ON clause is
such that more than 1 row in source matches a row in t [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/languagemanual-lateralview/index.html
b/docs/latest/language/languagemanual-lateralview/index.html
index 2d35b596..feccaea4 100644
--- a/docs/latest/language/languagemanual-lateralview/index.html
+++ b/docs/latest/language/languagemanual-lateralview/index.html
@@ -5,7 +5,7 @@
<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 : LanguageManual LateralView</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : LanguageManual LateralView</ [...]
Last updated: December 12, 2024</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--languagemanual-lateralview>Apache Hive : LanguageManual
LateralView</a><ul><li><a href=#lateral-view-syntax>Lateral View
Syntax</a></li><li><a href=#description>Description</a></li><li><a
href=#example>Example</a></li><li><a href=#multiple-lateral-views>Multiple
Lateral Views</a></li><li><a href=#outer-lateral [...]
fromClause: FROM baseTable (lateralView)*
-</code></pre><h2 id=description>Description</h2><p>Lateral view is used in
conjunction with user-defined table generating functions such as
<code>explode()</code>. As mentioned in <a
href=#built-in-table-generating-functions>Built-in Table-Generating
Functions</a>, a UDTF generates zero or more output rows for each input row. A
lateral view first applies the UDTF to each row of base table and then joins
resulting output rows to the input rows to form a virtual table having the
supplied t [...]
+</code></pre><h2 id=description>Description</h2><p>Lateral view is used in
conjunction with user-defined table generating functions such as
<code>explode()</code>. As mentioned in <a
href=#built-in-table-generating-functions>Built-in Table-Generating
Functions</a>, a UDTF generates zero or more output rows for each input row. A
lateral view first applies the UDTF to each row of base table and then joins
resulting output rows to the input rows to form a virtual table having the
supplied t [...]
FROM pageAds LATERAL VIEW explode(adid_list) adTable AS adid;
</code></pre><p>The resulting output will be</p><table><thead><tr><th>pageid
(string)</th><th>adid
(int)</th></tr></thead><tbody><tr><td>“front_page”</td><td>1</td></tr><tr><td>“front_page”</td><td>2</td></tr><tr><td>“front_page”</td><td>3</td></tr><tr><td>“contact_page”</td><td>3</td></tr><tr><td>“contact_page”</td><td>4</td></tr><tr><td>“contact_page”</td><td>5</td></tr></tbody></table><p>Then
in order to count the [...]
FROM pageAds LATERAL VIEW explode(adid_list) adTable AS adid
diff --git a/docs/latest/language/languagemanual-orc/index.html
b/docs/latest/language/languagemanual-orc/index.html
index 34145ae1..1f1ba988 100644
--- a/docs/latest/language/languagemanual-orc/index.html
+++ b/docs/latest/language/languagemanual-orc/index.html
@@ -22,7 +22,7 @@ hive --orcfiledump [-d] [-t] [--rowindex <col_ids>]
<location-of-orc-fi
// Hive version 1.3.0 and later:
hive --orcfiledump [-j] [-p] [-d] [-t] [--rowindex <col_ids>]
[--recover] [--skip-dump]
[--backup-path <new-path>] <location-of-orc-file-or-directory>
-</code></pre><p>Specifying <code>-d</code> in the command will cause it to
dump the ORC file data rather than the metadata (Hive <a
href=https://issues.apache.org/jira/browse/HIVE-7896>1.1.0</a> and
later).</p><p>Specifying <code>--rowindex</code> with a comma separated list of
column ids will cause it to print <a href=#row-indexes>row indexes</a> for the
specified columns, where 0 is the top level struct containing all of the
columns and 1 is the first column id (Hive <a href=https://is [...]
+</code></pre><p>Specifying <code>-d</code> in the command will cause it to
dump the ORC file data rather than the metadata (Hive <a
href=https://issues.apache.org/jira/browse/HIVE-7896>1.1.0</a> and
later).</p><p>Specifying <code>--rowindex</code> with a comma separated list of
column ids will cause it to print <a href=#row-indexes>row indexes</a> for the
specified columns, where 0 is the top level struct containing all of the
columns and 1 is the first column id (Hive <a href=https://is [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/scheduled-queries/index.html
b/docs/latest/language/scheduled-queries/index.html
index 4d654ef1..7a64a76f 100644
--- a/docs/latest/language/scheduled-queries/index.html
+++ b/docs/latest/language/scheduled-queries/index.html
@@ -12,7 +12,7 @@ Last updated: December 12, 2024</span></div></header><div
class=docs-toc><h4><i
<a
href=/docs/latest/language/scheduled-queries#executedas-syntax><code><executedAsSpec></code></a>|
<a
href=/docs/latest/language/scheduled-queries#enablespecification-syntax><code><enableSpecification></code></a>|
<a
href=/docs/latest/language/scheduled-queries#defined-as-syntax><code><definedAsSpec></code></a>|
-<a
href=/docs/latest/language/scheduled-queries#executespec-syntax><code><executeSpec></code></a>);</strong></p><h2
id=drop-syntax>Drop syntax</h2><p><strong>DROP SCHEDULED QUERY
<scheduled_query_name>;</strong></p><h2
id=schedulespecification-syntax>scheduleSpecification syntax</h2><p>Schedules
can be specified using CRON expressions or for common cases there is a simpler
form; in any case the schedule is stored as Quartz cron expression.</p><h3
id=cron-based-schedulesyntax>CRON b [...]
+<a
href=/docs/latest/language/scheduled-queries#executespec-syntax><code><executeSpec></code></a>);</strong></p><h2
id=drop-syntax>Drop syntax</h2><p><strong>DROP SCHEDULED QUERY
<scheduled_query_name>;</strong></p><h2
id=schedulespecification-syntax>scheduleSpecification syntax</h2><p>Schedules
can be specified using CRON expressions or for common cases there is a simpler
form; in any case the schedule is stored as Quartz cron expression.</p><h3
id=cron-based-schedulesyntax>CRON b [...]
| <strong>schedule_name</strong> | sc1 | The name of the schedule |
| <strong>enabled</strong> | true | True if the schedule is enabled |
| <strong>cluster_namespace</strong> | hive | The namespace thes scheduled
query belongs to |
diff --git
a/docs/latest/language/sql-standard-based-hive-authorization/index.html
b/docs/latest/language/sql-standard-based-hive-authorization/index.html
index b2897c41..ff000ab9 100644
--- a/docs/latest/language/sql-standard-based-hive-authorization/index.html
+++ b/docs/latest/language/sql-standard-based-hive-authorization/index.html
@@ -21,7 +21,7 @@ FROM principal_specification [, principal_specification] ... ;
principal_specification
: USER user
| ROLE role
-</code></pre><p>Revokes the membership of the roles from the user/roles in the
FROM clause.</p><p>As of Hive 0.14.0, revoking just the ADMIN OPTION is
possible with the use of REVOKE ADMIN OPTION FOR (<a
href=https://issues.apache.org/jira/browse/HIVE-6252>HIVE-6252</a>).</p><h4
id=show-role-grant>Show Role Grant</h4><pre tabindex=0><code>SHOW ROLE GRANT
(USER|ROLE) principal_name;
+</code></pre><p>Revokes the membership of the roles from the user/roles in the
FROM clause.</p><p>As of Hive 0.14.0, revoking just the ADMIN OPTION is
possible with the use of REVOKE ADMIN OPTION FOR <role> (<a
href=https://issues.apache.org/jira/browse/HIVE-6252>HIVE-6252</a>).</p><h4
id=show-role-grant>Show Role Grant</h4><pre tabindex=0><code>SHOW ROLE GRANT
(USER|ROLE) principal_name;
</code></pre><p>where <code>principal_name</code> is the name of a user or
role.</p><p>Lists all roles the given user or role has been
granted.</p><p>Currently any user can run this command. But this is likely to
change in future to allow users to see only their own role grants, and
additional privileges would be needed to see role grants of other users.</p><h5
id=example-of-show-role-grant>Example of Show Role Grant</h5><pre
tabindex=0><code>0: jdbc:hive2://localhost:10000> GRANT rol [...]
No rows affected (0.058 seconds)
@@ -57,7 +57,7 @@ principal_specification
priv_type
: INSERT | SELECT | UPDATE | DELETE | ALL
-</code></pre><p>If a user is granted a privilege WITH GRANT OPTION on a table
or view, then the user can also grant/revoke privileges of other users and
roles on those objects. As of Hive 0.14.0, the grant option for a privilege can
be removed while still keeping the privilege by using REVOKE GRANT OPTION FOR
(<a
href=https://issues.apache.org/jira/browse/HIVE-7404>HIVE-7404</a>).</p><p>Note
that in case of the REVOKE statement, the DROP-BEHAVIOR option of CASCADE is
not currently suppor [...]
+</code></pre><p>If a user is granted a privilege WITH GRANT OPTION on a table
or view, then the user can also grant/revoke privileges of other users and
roles on those objects. As of Hive 0.14.0, the grant option for a privilege can
be removed while still keeping the privilege by using REVOKE GRANT OPTION FOR
<privilege> (<a
href=https://issues.apache.org/jira/browse/HIVE-7404>HIVE-7404</a>).</p><p>Note
that in case of the REVOKE statement, the DROP-BEHAVIOR option of CASCADE is
not c [...]
No rows affected (0.046 seconds)
0: jdbc:hive2://localhost:10000/default> revoke update, select on table
secured_table from role my_role;
diff --git a/docs/latest/language/supported-features-apache-hive-2-1/index.html
b/docs/latest/language/supported-features-apache-hive-2-1/index.html
index 308dde94..9d72892c 100644
--- a/docs/latest/language/supported-features-apache-hive-2-1/index.html
+++ b/docs/latest/language/supported-features-apache-hive-2-1/index.html
@@ -3,7 +3,7 @@
<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-it [...]
<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 : Supported Features: Apache Hive 2.1</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : Supported Features: [...]
-Last updated: December 12, 2024</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--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive 2.1</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive
2.1</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive 2.1<
[...]
+Last updated: December 12, 2024</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--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive 2.1</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-21>Apache Hive : Supported
Features: Apache Hive
2.1</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive 2.1<
[...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/supported-features-apache-hive-2-3/index.html
b/docs/latest/language/supported-features-apache-hive-2-3/index.html
index 0c698cf6..ba70be6a 100644
--- a/docs/latest/language/supported-features-apache-hive-2-3/index.html
+++ b/docs/latest/language/supported-features-apache-hive-2-3/index.html
@@ -3,7 +3,7 @@
<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-it [...]
<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 : Supported Features: Apache Hive 2.3</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : Supported Features: [...]
-Last updated: December 12, 2024</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--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive 2.3</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive
2.3</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive 2.3<
[...]
+Last updated: December 12, 2024</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--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive 2.3</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-23>Apache Hive : Supported
Features: Apache Hive
2.3</h1><table><thead><tr><th>Identifier</th><th>Description</th><th>Hive 2.3<
[...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/supported-features/index.html
b/docs/latest/language/supported-features/index.html
index 283e2bc9..978c3d21 100644
--- a/docs/latest/language/supported-features/index.html
+++ b/docs/latest/language/supported-features/index.html
@@ -3,7 +3,7 @@
<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-it [...]
<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 : Supported Features: Apache Hive 3.1</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : Supported Features: [...]
-Last updated: December 12, 2024</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--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</h1><p>This table covers all mandatory features from
<a href=https://en.wi [...]
+Last updated: December 12, 2024</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--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--supported-features-apache-hive-31>Apache Hive : Supported
Features: Apache Hive 3.1</h1><p>This table covers all mandatory features from
<a href=https://en.wi [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/index.json b/index.json
index 7447638f..e038e5b8 100644
--- a/index.json
+++ b/index.json
@@ -1 +1 @@
-[{"categories":null,"contents":"Apache Hive : Iceberg REST Catalog API backed
by Hive Metastore Introduction Hive Metastore offers Iceberg REST API endpoints
for clients native to Apache Iceberg. Consequently, Iceberg users can access
Iceberg tables via either Hive Metastore Thrift API (using HiveCatalog) or
Iceberg REST Catalog API.\nBasic configurations You must configure the
following parameters.\nKey Required? Default Value
metastore.catalog.servlet.port Yes -1 The port number to whi [...]
\ No newline at end of file
+[{"categories":null,"contents":"Apache Hive : Iceberg REST Catalog API backed
by Hive Metastore Introduction Hive Metastore offers Iceberg REST API endpoints
for clients native to Apache Iceberg. Consequently, Iceberg users can access
Iceberg tables via either Hive Metastore Thrift API (using HiveCatalog) or
Iceberg REST Catalog API.\nBasic configurations You must configure the
following parameters.\nKey Required? Default Value
metastore.catalog.servlet.port Yes -1 The port number to whi [...]
\ No newline at end of file
diff --git a/index.xml b/index.xml
index 0f4fce4c..be399dde 100644
--- a/index.xml
+++ b/index.xml
@@ -3713,71 +3713,71 @@ TBLPROPERTIES (
</thead>
<tbody>
<tr>
- <td>quit exit</td>
+ <td><code>quit exit</code></td>
<td>Use quit or exit to leave the interactive shell.</td>
</tr>
<tr>
- <td>reset</td>
+ <td><code>reset</code></td>
<td>Resets the configuration to the default values (as of Hive 0.10:
see <a
href="https://issues.apache.org/jira/browse/HIVE-3202">HIVE-3202</a>).
Any configuration parameters that were set using the set command or -hiveconf
parameter in hive commandline will get reset to default value.Note that this
does not apply to configuration parameters that were set in set command using
the &ldquo;hiveconf:&rdquo; prefix for the key name (for historic
reasons).</td>
</tr>
<tr>
- <td>set <!-- raw HTML omitted -->=<!-- raw HTML omitted
--></td>
+ <td><code>set
&lt;key&gt;=&lt;value&gt;</code></td>
<td>Sets the value of a particular configuration variable (key).
<strong>Note:</strong> If you misspell the variable name, the CLI
will not show an error.</td>
</tr>
<tr>
- <td>set</td>
+ <td><code>set</code></td>
<td>Prints a list of configuration variables that are overridden by the
user or Hive.</td>
</tr>
<tr>
- <td>set -v</td>
+ <td><code>set -v</code></td>
<td>Prints all Hadoop and Hive configuration variables.</td>
</tr>
<tr>
- <td>add FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add ARCHIVE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->*</td>
+ <td><code>add FILE[S] &lt;filepath&gt;
&lt;filepath&gt;*</code> <code>add JAR[S]
&lt;filepath&gt; &lt;filepath&gt;*</code> <code>add
ARCHIVE[S] &lt;filepath&gt;
&lt;filepath&gt;*</code></td>
<td>Adds one or more files, jars, or archives to the list of resources
in the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>add FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* add ARCHIVE[S]<!-- raw HTML omitted --> <!-- raw HTML
omitted -->*</td>
+ <td><code>add FILE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code> <code>add JAR[S]
&lt;ivyurl&gt; &lt;ivyurl&gt;*</code> <code>add
ARCHIVE[S]&lt;ivyurl&gt; &lt;ivyurl&gt;*</code></td>
<td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
adds one or more files, jars or archives to the list of resources in the
distributed cache using an <a
href="http://ant.apache.org/ivy/">Ivy</a> URL of the form
ivy://group:module:version?query_string. See <a
href="#hive-resources">Hive Resources</a> for more
information.</td>
</tr>
<tr>
- <td>list FILE[S] list JAR[S] list ARCHIVE[S]</td>
+ <td><code>list FILE[S]</code> <code>list
JAR[S]</code> <code>list ARCHIVE[S]</code></td>
<td>Lists the resources already added to the distributed cache. See
<a href="#hive-resources">Hive Resources</a> for more
information.</td>
</tr>
<tr>
- <td>list FILE[S] <!-- raw HTML omitted -->* list JAR[S] <!--
raw HTML omitted -->* list ARCHIVE[S] <!-- raw HTML omitted
-->*</td>
+ <td><code>list FILE[S] &lt;filepath&gt;*</code>
<code>list JAR[S] &lt;filepath&gt;*</code> <code>list
ARCHIVE[S] &lt;filepath&gt;*</code></td>
<td>Checks whether the given resources are already added to the
distributed cache or not. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>delete FILE[S] <!-- raw HTML omitted -->* delete JAR[S]
<!-- raw HTML omitted -->* delete ARCHIVE[S] <!-- raw HTML omitted
-->*</td>
+ <td><code>delete FILE[S] &lt;filepath&gt;*</code>
<code>delete JAR[S] &lt;filepath&gt;*</code>
<code>delete ARCHIVE[S] &lt;filepath&gt;*</code></td>
<td>Removes the resource(s) from the distributed cache.</td>
</tr>
<tr>
- <td>delete FILE[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* delete JAR[S] <!-- raw HTML omitted --> <!-- raw HTML
omitted -->* delete ARCHIVE[S] <!-- raw HTML omitted --> <!-- raw
HTML omitted -->*</td>
- <td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
removes the resource(s) which were added using the <!-- raw HTML omitted
--> from the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
+ <td><code>delete FILE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code> <code>delete JAR[S]
&lt;ivyurl&gt; &lt;ivyurl&gt;*</code> <code>delete
ARCHIVE[S] &lt;ivyurl&gt;
&lt;ivyurl&gt;*</code></td>
+ <td>As of <a
href="https://issues.apache.org/jira/browse/HIVE-9664">Hive 1.2.0</a>,
removes the resource(s) which were added using the &lt;ivyurl&gt; from
the distributed cache. See <a href="#hive-resources">Hive
Resources</a> for more information.</td>
</tr>
<tr>
- <td>! <!-- raw HTML omitted --></td>
+ <td><code>! &lt;command&gt;</code></td>
<td>Executes a shell command from the Hive shell.</td>
</tr>
<tr>
- <td>dfs <!-- raw HTML omitted --></td>
+ <td><code>dfs &lt;dfs command&gt;</code></td>
<td>Executes a dfs command from the Hive shell.</td>
</tr>
<tr>
- <td><!-- raw HTML omitted --></td>
+ <td><code>&lt;query string&gt;</code></td>
<td>Executes a Hive query and prints results to standard
output.</td>
</tr>
<tr>
- <td>source FILE <!-- raw HTML omitted --></td>
+ <td><code>source FILE
&lt;filepath&gt;</code></td>
<td>Executes a script file inside the CLI.</td>
</tr>
<tr>
- <td>compile <code>&lt;groovy string&gt;</code> AS
GROOVY NAMED <!-- raw HTML omitted --></td>
+ <td><code>compile `&lt;groovy string&gt;` AS GROOVY NAMED
&lt;name&gt;</code></td>
<td>This allows inline Groovy code to be compiled and be used as a UDF
(as of Hive <a
href="https://issues.apache.org/jira/browse/HIVE-5252">0.13.0</a>).
For a usage example, see <a
href="https://hive.apache.org/attachments/27362054/HiveContrib-Nov13-groovy_plus_hive.pptx">Nov.
2013 Hive Contributors Meetup Presentations – Using Dynamic Compilation with
Hive</a>.</td>
</tr>
<tr>
- <td>show processlist</td>
+ <td><code>show processlist</code></td>
<td>Displays information about the operations currently running on
HiveServer2. It helps to troubleshoot issues such as long running queries,
connection starvation, etc. The command was introduced in <a
href="https://issues.apache.org/jira/browse/HIVE-27829">HIVE-27829</a>.</td>
</tr>
</tbody>
@@ -4829,7 +4829,7 @@ FROM customer
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td>Mandatory</td>
<td></td>
@@ -5949,56 +5949,56 @@ FROM customer
</tr>
<tr>
<td>F850</td>
- <td>Top level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F856</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;fetch first clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F857</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;fetch first clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F858</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;fetch first clause&gt; in subqueries</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
</tr>
<tr>
<td>F859</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;fetch first clause&gt; in views</td>
<td>Yes</td>
<td>Optional</td>
<td></td>
@@ -6441,7 +6441,7 @@ FROM customer
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -7011,25 +7011,25 @@ FROM customer
</tr>
<tr>
<td>F850</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -7377,7 +7377,7 @@ FROM customer
</tr>
<tr>
<td>E051-04</td>
- <td>GROUP BY can contain columns not in <!-- raw HTML omitted
--></td>
+ <td>GROUP BY can contain columns not in &lt;select
list&gt;</td>
<td>Yes</td>
<td></td>
</tr>
@@ -8037,25 +8037,25 @@ FROM customer
</tr>
<tr>
<td>F850</td>
- <td>Top-level <!-- raw HTML omitted --> in <!-- raw HTML
omitted --></td>
+ <td>Top-level &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F851</td>
- <td><!-- raw HTML omitted --> in subqueries</td>
+ <td>&lt;order by clause&gt; in subqueries</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F852</td>
- <td>Top-level <!-- raw HTML omitted --> in views</td>
+ <td>Top-level &lt;order by clause&gt; in views</td>
<td>Yes</td>
<td></td>
</tr>
<tr>
<td>F855</td>
- <td>Nested <!-- raw HTML omitted --> in <!-- raw HTML omitted
--></td>
+ <td>Nested &lt;order by clause&gt; in &lt;query
expression&gt;</td>
<td>Yes</td>
<td></td>
</tr>
