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 ab56ee39 deploy: 36fac7f0793de648dec2fb0e49805746b7cce72c
ab56ee39 is described below
commit ab56ee3903c27bdd049a89e09e871897a2a1dcaf
Author: okumin <[email protected]>
AuthorDate: Tue Sep 22 02:57:34 2026 +0000
deploy: 36fac7f0793de648dec2fb0e49805746b7cce72c
---
.../hplsql/built-in-variables/hostcode/index.html | 28 ------
.../language/hplsql/built-in-variables/index.html | 11 +--
.../language/hplsql/built-in-variables/index.xml | 15 +---
docs/latest/language/hplsql/index.html | 2 +-
.../hplsql/statements/copy-from-ftp/index.html | 29 -------
.../hplsql/statements/copy-from-local/index.html | 29 -------
.../language/hplsql/statements/copy/index.html | 35 --------
.../language/hplsql/statements/host/index.html | 26 ------
docs/latest/language/hplsql/statements/index.html | 30 +------
docs/latest/language/hplsql/statements/index.xml | 80 +----------------
.../hplsql/statements/insert-directory/index.html | 2 +-
.../hplsql/user-guide/configuration/index.html | 2 +-
.../hplsql/user-guide/error-handling/index.html | 2 +-
docs/latest/language/hplsql/user-guide/index.html | 4 +-
docs/latest/language/hplsql/user-guide/index.xml | 4 +-
index.json | 2 +-
index.xml | 99 ++--------------------
sitemap.xml | 2 +-
18 files changed, 23 insertions(+), 379 deletions(-)
diff --git a/docs/latest/language/hplsql/built-in-variables/hostcode/index.html
b/docs/latest/language/hplsql/built-in-variables/hostcode/index.html
deleted file mode 100644
index f9c38ff4..00000000
--- a/docs/latest/language/hplsql/built-in-variables/hostcode/index.html
+++ /dev/null
@@ -1,28 +0,0 @@
-<!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><meta http-equiv=Cache-Control
content="no-cache, no-store, must-revalidate"><meta http-equiv=Pragma
content="no-cache"><meta http-equiv=Expires content="0"><title>Apache Hive :
HPL/SQL - HOSTCODE</title><link rel=icon href=/images/hive.svg sizes=any [...]
-</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-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 : HPL/SQL - HOSTCODE</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : HPL/SQL - HOSTCODE</h1><div class=do [...]
-Last updated: August 12, 2026</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--hplsql---hostcode>Apache Hive
: HPL/SQL - HOSTCODE</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--hplsql---hostcode>Apache Hive : HPL/SQL -
HOSTCODE</h1><p>HOSTCODE built-in variable contains the return code of the last
OS command.</p><pre tabindex=0><code>SET hplsql.onerror = SETERROR;
-
-HOST 'echo hello, world';
-IF HOSTCODE <> 0 THEN
- PRINT 'Error';
-END IF;
-</code></pre><p><strong>Notes</strong>:</p><ul><li>Typically HOSTCODE is 0
when the process terminated successfully, and 1 if it terminated with an
error.</li><li>By default <a
href=https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror>hplsql.onerror</a>
is set to EXCEPTION, so if the OS command cannot be executed (the process does
not exist, no permissions i.e.) the exception is raised and you are not be able
to check HOSTCODE in IF statement.</li>< [...]
-<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/hplsql/built-in-variables/hostcode.md
class="btn btn-outline"><i class="fab fa-github"></i> Edit this page on
GitHub</a></div></footer></article></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//im [...]
-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/thanks.html>thanks
-</a>to the sponsors who
-<a href=https://www.apache.org/foundation/sponsorship.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
© 2026 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?v=1.1.0"></script></body></html>
\ No newline at end of file
diff --git a/docs/latest/language/hplsql/built-in-variables/index.html
b/docs/latest/language/hplsql/built-in-variables/index.html
index b94ed460..a920d685 100644
--- a/docs/latest/language/hplsql/built-in-variables/index.html
+++ b/docs/latest/language/hplsql/built-in-variables/index.html
@@ -3,15 +3,8 @@
<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 class=active>Attributes and Built-in
Variables</li></ol></nav><header class=docs-header><h1
class=docs-title>Attributes and Built-in Variables</h1><div
class=docs-meta><span class=docs-count><i class [...]
-4 documents</span></div></header><div class=docs-article><div
class=docs-grid><div class=docs-card><div class=docs-card-header><h3><a
href=https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/activity_count/>Apache
Hive : HPL/SQL - ACTIVITY_COUNT Variable</a></h3><span class=docs-card-date><i
class="fas fa-calendar-alt"></i>
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---activity_count-variable>Apache Hive : HPL/SQL -
ACTIVITY_COUNT Variable</h1><p>ACTIVITY_COUNT built-in variable contains the
number of rows affected by the last SQL statement.</p><p><strong>Important
Note:</strong> Currently Hive does not support JDBC Statement.getUpdateCount(),
so for INSERT statements ACTIVITY_COUNT will return 0 for Hive 0.13 and earlier
and -1 for Hive 0.14 and later. See <a href=https [...]
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---hostcode>Apache Hive : HPL/SQL -
HOSTCODE</h1><p>HOSTCODE built-in variable contains the return code of the last
OS command.</p><pre tabindex=0><code>SET hplsql.onerror = SETERROR;
-
-HOST 'echo hello, world';
-IF HOSTCODE <> 0 THEN
- PRINT 'Error';
-END IF;
-</code></pre><p><strong>Notes</strong>:</p><ul><li>Typically HOSTCODE is 0
when the process terminated successfully, and 1 if it terminated with an
error.</li><li>By default <a
href=https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror>hplsql.onerror</a>
is set to EXCEPTION, so if the OS command cannot be executed (the process does
not exist, no permissions i.e.) the exception is raised and you are not be able
to check HOSTCODE in IF statement.</li>< [...]
+3 documents</span></div></header><div class=docs-article><div
class=docs-grid><div class=docs-card><div class=docs-card-header><h3><a
href=https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/activity_count/>Apache
Hive : HPL/SQL - ACTIVITY_COUNT Variable</a></h3><span class=docs-card-date><i
class="fas fa-calendar-alt"></i>
+Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---activity_count-variable>Apache Hive : HPL/SQL -
ACTIVITY_COUNT Variable</h1><p>ACTIVITY_COUNT built-in variable contains the
number of rows affected by the last SQL statement.</p><p><strong>Important
Note:</strong> Currently Hive does not support JDBC Statement.getUpdateCount(),
so for INSERT statements ACTIVITY_COUNT will return 0 for Hive 0.13 and earlier
and -1 for Hive 0.14 and later. See <a href=https [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---sqlcode>Apache Hive : HPL/SQL - SQLCODE</h1><p>SQLCODE
built-in variable contains the return code of the last SQL statement. The code
can be zero (0), negative or
positive:</p><table><thead><tr><th><strong>SQLCODE</strong></th><th><strong>Result</strong></th></tr></thead><tbody><tr><td>0</td><td>Successful
execution</td></tr><tr><td>Positive
values</td><td>Warning</td></tr><tr><td>Negative values</td><td>E [...]
DECLARE cur CURSOR FOR 'SELECT id FROM db.orders';
OPEN cur;
diff --git a/docs/latest/language/hplsql/built-in-variables/index.xml
b/docs/latest/language/hplsql/built-in-variables/index.xml
index 00d83e3a..30643467 100644
--- a/docs/latest/language/hplsql/built-in-variables/index.xml
+++ b/docs/latest/language/hplsql/built-in-variables/index.xml
@@ -1,20 +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>Attributes and
Built-in Variables on Hive
Site</title><link>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/</link><description>Recent
content in Attributes and Built-in Variables on Hive
Site</description><generator>Hugo</generator><language>en-us</language><lastBuildDate>Wed,
12 Aug 2026 00:00:00 +0000</lastBuildDate><atom:link href=" [...]
<p>ACTIVITY_COUNT built-in variable contains the number of rows affected
by the last SQL statement.</p>
<p><strong>Important Note:</strong> Currently Hive does not
support JDBC Statement.getUpdateCount(), so for INSERT statements
ACTIVITY_COUNT will return 0 for Hive 0.13 and earlier and -1 for Hive 0.14 and
later. See <a
href="https://issues.apache.org/jira/browse/HIVE-7680">HIVE-7680</a>
for more details.</p>
-<p>Currently you can use ACTIVITY_COUNT only with SELECT statements in
Hive. If SELECT INTO returns a row ACTIVITY_COUNT is set to 1. Also if you use
a cursor each FETCH statement increments ACTIVITY_COUNT by
1.</p></description></item><item><title>Apache Hive : HPL/SQL -
HOSTCODE</title><link>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/hostcode/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/langua [...]
-<p>HOSTCODE built-in variable contains the return code of the last OS
command.</p>
-<pre tabindex="0"><code>SET hplsql.onerror = SETERROR;
-
-HOST &#39;echo hello, world&#39;;
-IF HOSTCODE &lt;&gt; 0 THEN
- PRINT &#39;Error&#39;;
-END IF;
-</code></pre><p><strong>Notes</strong>:</p>
-<ul>
-<li>Typically HOSTCODE is 0 when the process terminated successfully,
and 1 if it terminated with an error.</li>
-<li>By default <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror">hplsql.onerror</a>
is set to EXCEPTION, so if the OS command cannot be executed (the process does
not exist, no permissions i.e.) the exception is raised and you are not be able
to check HOSTCODE in IF statement.</li>
-</ul>
-<p>For more information, see <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/">Error
Handling</a>.</p></description></item><item><title>Apache Hive :
HPL/SQL -
SQLCODE</title><link>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/sqlcode/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/sqlcode/</guid><description><h1
[...]
+<p>Currently you can use ACTIVITY_COUNT only with SELECT statements in
Hive. If SELECT INTO returns a row ACTIVITY_COUNT is set to 1. Also if you use
a cursor each FETCH statement increments ACTIVITY_COUNT by
1.</p></description></item><item><title>Apache Hive : HPL/SQL -
SQLCODE</title><link>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/sqlcode/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language [...]
<p>SQLCODE built-in variable contains the return code of the last SQL
statement. The code can be zero (0), negative or positive:</p>
<table>
<thead>
diff --git a/docs/latest/language/hplsql/index.html
b/docs/latest/language/hplsql/index.html
index 362fce89..90a9f3f2 100644
--- a/docs/latest/language/hplsql/index.html
+++ b/docs/latest/language/hplsql/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 class=active>Apache Hive : HPL/SQL
Reference</li></ol></nav><header class=docs-header><h1 class=docs-title>Apache
Hive : HPL/SQL Reference</h1><div class=docs-meta><span class=docs-count><i
class="fa [...]
-11 documents</span></div></header><div class=docs-article><h1
id=apache-hive--hplsql-reference>Apache Hive : HPL/SQL Reference</h1><p>Hive
Hybrid Procedural SQL On Hadoop (HPL/SQL) is a tool that implements procedural
SQL for Hive. It is available in Hive 2.0.0 (<a
href=https://issues.apache.org/jira/browse/HIVE-11055>HIVE-11055</a>).</p><p>HPL/SQL
is an open source tool (Apache License 2.0) that implements procedural SQL
language for Apache Hive, SparkSQL, Impala as well as any other SQ [...]
+11 documents</span></div></header><div class=docs-article><h1
id=apache-hive--hplsql-reference>Apache Hive : HPL/SQL Reference</h1><p>Hive
Hybrid Procedural SQL On Hadoop (HPL/SQL) is a tool that implements procedural
SQL for Hive. It is available in Hive 2.0.0 (<a
href=https://issues.apache.org/jira/browse/HIVE-11055>HIVE-11055</a>).</p><p>HPL/SQL
is an open source tool (Apache License 2.0) that implements procedural SQL
language for Apache Hive, SparkSQL, Impala as well as any other SQ [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---get-started>Apache Hive : HPL/SQL - Get
Started</h1><p>Quick guide how to start using HPL/SQL.</p><p>You can enable and
use HPL/SQL from any host or third-party tool that can make a JDBC connection
to HiveServer. Beeline is a popular client for use with HPL/SQL because other
third-party tools do not show you some of the error messages about syntax
mistakes.</p><h2 id=enabling-hplsql-in-the-beeline-connecti [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---key-features>Apache Hive : HPL/SQL - Key
Features</h1><p>HPL/SQL key features:</p><ul><li>Flow of Control Statements
(FOR, WHILE, IF, CASE, LOOP, LEAVE, RETURN)</li><li>Functions, procedures, and
packages</li><li>Built-in functions (string manipulations, datetime functions,
conversions)</li><li>Exception handling and conditions</li><li>Constants and
variable, assignment (DECLARE count INT := 1)</li><li>Pro [...]
</code></pre></div><div class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/features/
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/hplsql/why/>Apache Hive : Why
HPL/SQL</a></h3><span class=docs-card-date><i class="fas fa-calendar-alt"></i>
diff --git a/docs/latest/language/hplsql/statements/copy-from-ftp/index.html
b/docs/latest/language/hplsql/statements/copy-from-ftp/index.html
deleted file mode 100644
index c812a0d6..00000000
--- a/docs/latest/language/hplsql/statements/copy-from-ftp/index.html
+++ /dev/null
@@ -1,29 +0,0 @@
-<!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><meta http-equiv=Cache-Control
content="no-cache, no-store, must-revalidate"><meta http-equiv=Pragma
content="no-cache"><meta http-equiv=Expires content="0"><title>Apache Hive :
HPL/SQL - COPY FROM FTP Statement</title><link rel=icon href=/images/hive [...]
-</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-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 : HPL/SQL - COPY FROM FTP Statement</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : HPL/SQL - COPY FROM F [...]
-Last updated: August 12, 2026</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--hplsql---copy-from-ftp-statement>Apache Hive : HPL/SQL -
COPY FROM FTP Statement</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--hplsql---copy-from-ftp-statement>Apache Hive : HPL/SQL - COPY
FROM FTP Statement</h1><p>COPY FROM FTP statement allows to copy files from a
FTP server to local or [...]
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num
-</code></pre><p>Notes:</p><ul><li><em>host, user</em> and <em>pwd</em> specify
the FTP host name, user name and password (identifier, string literal, variable
or expression can be specified).</li><li>DIR option specifies the directory to
get files, optional. If skipped, the current working FTP directory is
used</li><li>FILES option specifies a wildcard (Java regular expression) to
choose which files to transfer. By default, all files from the specified
directory are transferred.</li><li> [...]
-<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/hplsql/statements/copy-from-ftp.md
class="btn btn-outline"><i class="fab fa-github"></i> Edit this page on
GitHub</a></div></footer></article></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//image [...]
-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/thanks.html>thanks
-</a>to the sponsors who
-<a href=https://www.apache.org/foundation/sponsorship.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
© 2026 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?v=1.1.0"></script></body></html>
\ No newline at end of file
diff --git a/docs/latest/language/hplsql/statements/copy-from-local/index.html
b/docs/latest/language/hplsql/statements/copy-from-local/index.html
deleted file mode 100644
index 12d2a7c0..00000000
--- a/docs/latest/language/hplsql/statements/copy-from-local/index.html
+++ /dev/null
@@ -1,29 +0,0 @@
-<!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><meta http-equiv=Cache-Control
content="no-cache, no-store, must-revalidate"><meta http-equiv=Pragma
content="no-cache"><meta http-equiv=Expires content="0"><title>Apache Hive :
HPL/SQL - COPY FROM LOCAL Statement</title><link rel=icon href=/images/hi [...]
-</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-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 : HPL/SQL - COPY FROM LOCAL Statement</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : HPL/SQL - COPY FROM [...]
-Last updated: August 12, 2026</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--hplsql---copy-from-local-statement>Apache Hive : HPL/SQL -
COPY FROM LOCAL Statement</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--hplsql---copy-from-local-statement>Apache Hive : HPL/SQL - COPY
FROM LOCAL Statement</h1><p>COPY FROM LOCAL statement allows to copy local
directories and file [...]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-</code></pre><p>Notes:</p><ul><li><em>srcN</em> specifies a file or directory.
If a directory is specified all subdirectories and their files are copied as
well.</li><li><em>srcN</em> can be an expression, variable, quoted or unquoted
string.</li><li>If a single file is copied <em>tgt</em> must specify a path
including the target file name.</li><li>If multiple files are copied
<em>tgt</em> must specify a directory.</li><li>If the target directory does not
exist it is created.</li><li>OVE [...]
-</code></pre><p><strong>Compatibility:</strong> HPL/SQL Extension</p><p>See
also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy/>COPY</a></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/hplsql/statements/copy-from-local.md
class="btn btn-outline"><i class="fab fa-github"></i> Edit this page on
GitHub</a></div></footer></article></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//ima [...]
-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/thanks.html>thanks
-</a>to the sponsors who
-<a href=https://www.apache.org/foundation/sponsorship.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
© 2026 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?v=1.1.0"></script></body></html>
\ No newline at end of file
diff --git a/docs/latest/language/hplsql/statements/copy/index.html
b/docs/latest/language/hplsql/statements/copy/index.html
deleted file mode 100644
index cde7b903..00000000
--- a/docs/latest/language/hplsql/statements/copy/index.html
+++ /dev/null
@@ -1,35 +0,0 @@
-<!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><meta http-equiv=Cache-Control
content="no-cache, no-store, must-revalidate"><meta http-equiv=Pragma
content="no-cache"><meta http-equiv=Expires content="0"><title>Apache Hive :
HPL/SQL - COPY Statement</title><link rel=icon href=/images/hive.svg size [...]
-</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-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 : HPL/SQL - COPY Statement</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : HPL/SQL - COPY Statement</h1>< [...]
-Last updated: August 12, 2026</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--hplsql---copy-statement>Apache
Hive : HPL/SQL - COPY Statement</a></li></ul></nav></div><div
class=docs-article><h1 id=apache-hive--hplsql---copy-statement>Apache Hive :
HPL/SQL - COPY Statement</h1><p>COPY statement allows to transfer data between
tables and files. Use it to transfer relatively small volumes of [...]
-
-options:
- DELIMITER 'char'
-| SQLINSERT target_table_name
-</code></pre><p>Copy data between existing tables:</p><pre
tabindex=0><code>COPY table_name | (select_stmt) TO target_table_name AT
target_conn_name [options]
-
-options:
- BATCHSIZE num
-</code></pre><p>Notes:</p><ul><li><em>table_name</em> is an
identifier.</li><li><em>file_name</em> can be an expression, quoted or unquoted
string.</li><li>If <em>file_name</em> already exists it is
overwritten.</li><li>When HDFS is specified, the data is copied to a
HDFS-compatible file system.</li><li>DELIMITER specifies the delimiter between
column values, ‘\t’ (TAB character) is the
default.</li><li>SQLINSERT specifies to generate SQL INSERT statements to
insert data to < [...]
- TO /data/users.txt DELIMITER '\t';
-</code></pre><p><strong>Example 2</strong>:</p><p>Generate SQL INSERT
statements:</p><pre tabindex=0><code>COPY sales.users TO /data/users2.sql
SQLINSERT sales.users;
-</code></pre><p><strong>Example 3</strong>:</p><p>Copy rows from between
tables in different databases:</p><pre tabindex=0><code>COPY sales.users TO
sales.users2 AT tdconn;
-</code></pre><p><strong>Compatibility:</strong> HPL/SQL Extension,
PostgreSQL</p><p>See also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/>COPY
FROM LOCAL</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/insert-directory/>INSERT
DIRECTORY</a></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 ca [...]
-<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/hplsql/statements/copy.md
class="btn btn-outline"><i class="fab fa-github"></i> Edit this page on
GitHub</a></div></footer></article></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_log [...]
-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/thanks.html>thanks
-</a>to the sponsors who
-<a href=https://www.apache.org/foundation/sponsorship.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
© 2026 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?v=1.1.0"></script></body></html>
\ No newline at end of file
diff --git a/docs/latest/language/hplsql/statements/host/index.html
b/docs/latest/language/hplsql/statements/host/index.html
deleted file mode 100644
index f8cfa68a..00000000
--- a/docs/latest/language/hplsql/statements/host/index.html
+++ /dev/null
@@ -1,26 +0,0 @@
-<!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><meta http-equiv=Cache-Control
content="no-cache, no-store, must-revalidate"><meta http-equiv=Pragma
content="no-cache"><meta http-equiv=Expires content="0"><title>Apache Hive :
HPL/SQL - Execute OS Command or External Process</title><link rel=icon hr [...]
-</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-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 : HPL/SQL - Execute OS Command or External Process</li></ol></nav><header
class=docs-header><h1 class=docs-title>Apache Hive : HPL/SQ [...]
-Last updated: August 12, 2026</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--hplsql---execute-os-command-or-external-process>Apache Hive
: HPL/SQL - Execute OS Command or External
Process</a></li></ul></nav></div><div class=docs-article><h1
id=apache-hive--hplsql---execute-os-command-or-external-process>Apache Hive :
HPL/SQL - Execute OS Command or External Process</h1><p>HPL/SQL allows [...]
-</code></pre><p>HOST statement:</p><pre tabindex=0><code>HOST string_expr
-</code></pre><p><strong>Parameters:</strong></p><table><thead><tr><th><strong>Parameter</strong></th><th><strong>Description</strong></th></tr></thead><tbody><tr><td>cmd</td><td>Any
OS command or process</td></tr><tr><td>arguments</td><td>Optional argument
list</td></tr><tr><td>string_expr</td><td>Command line for HOST
statement</td></tr></tbody></table><p><strong>Notes</strong>:</p><ul><li>Blank
characters are allowed between ! and cmd</li><li>The ! command must be
terminated by a semic [...]
-</code></pre><p>Using HOST statement:</p><pre tabindex=0><code>HOST 'echo
Hello, world';
-</code></pre><p><strong>Compatibility</strong>: Apache Hive (! command),
Oracle (HOST statement).</p></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/hplsql/statements/host.md
class="btn btn-outline"><i class="fab fa-github"></i> Edit this page on
GitHub</a></div></footer></article></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_log [...]
-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/thanks.html>thanks
-</a>to the sponsors who
-<a href=https://www.apache.org/foundation/sponsorship.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
© 2026 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?v=1.1.0"></script></body></html>
\ No newline at end of file
diff --git a/docs/latest/language/hplsql/statements/index.html
b/docs/latest/language/hplsql/statements/index.html
index 271d7c77..39d74e34 100644
--- a/docs/latest/language/hplsql/statements/index.html
+++ b/docs/latest/language/hplsql/statements/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 class=active>Statements</li></ol></nav><header
class=docs-header><h1 class=docs-title>Statements</h1><div
class=docs-meta><span class=docs-count><i class="fas fa-file-alt"></i>
-51 documents</span></div></header><div class=docs-article><div
class=docs-grid><div class=docs-card><div class=docs-card-header><h3><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/allocate-cursor/>Apache
Hive : HPL/SQL - ALLOCATE CURSOR Statement</a></h3><span
class=docs-card-date><i class="fas fa-calendar-alt"></i>
+47 documents</span></div></header><div class=docs-article><div
class=docs-grid><div class=docs-card><div class=docs-card-header><h3><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/allocate-cursor/>Apache
Hive : HPL/SQL - ALLOCATE CURSOR Statement</a></h3><span
class=docs-card-date><i class="fas fa-calendar-alt"></i>
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---allocate-cursor-statement>Apache Hive : HPL/SQL -
ALLOCATE CURSOR Statement</h1><p>ALLOCATE CURSOR statement allows you to
declare a cursor and associate it with a result set returned from a stored
procedure.</p><p><strong>Syntax</strong>:</p><pre tabindex=0><code>ALLOCATE
cursor_name CURSOR FOR PROCEDURE procedure_name; -- Teradata compatibility
|
ALLOCATE cursor_name CURSOR FOR RESULT SET locator_name; -- DB2 compatibility
@@ -51,28 +51,7 @@ CLOSE cur;
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---cmp-statement>Apache Hive : HPL/SQL - CMP
Statement</h1><p>CMP statement helps you compare data in tables that can be
located in the same or different
databases.</p><p><strong>Syntax</strong>:</p><p>Compare the total number of
rows:</p><pre tabindex=0><code>CMP ROW_COUNT table1 [where_clause1] |
(select_stmt1) [AT conn1],
table2 [where_clause2] | (select_stmt2) [AT conn2]
</code></pre><p>Compare the column summary (COUNT, SUM, MIN and MAX applied to
columns):</p><pre tabindex=0><code>CMP SUM table1 [where_clause1] [AT conn1],
table2 [where_clause2] [AT conn2]
-</code></pre><p>Notes:</p><ul><li>When data are equal, the CMP statement sets
SQLCODE to 0. If data are not equal, SQLCODE is set to 1. In case of any SQL
error, SQLCODE is set to -1</li><li>When the connection profile is not
specified, the default connection profile is used for the specified
table</li></ul><p><strong>Example 1</strong>:</p></div><div
class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/cmp/
class=docs-card-link>Read more <i class [...]
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---copy-from-ftp-statement>Apache Hive : HPL/SQL - COPY
FROM FTP Statement</h1><p>COPY FROM FTP statement allows to copy files from a
FTP server to local or any Hadoop compatible file system. Using this statement
you can easily copy FTP subdirectories into HDFS i.e.</p><p>The NEW option
helps you build a ETL process and download only new files from
FTP.</p><p><strong>Syntax</strong>:</p><pre tabindex=0><code> [...]
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num
-</code></pre><p>Notes:</p></div><div class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-ftp/
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/hplsql/statements/copy-from-local/>Apache
Hive : HPL/SQL - COPY FROM LOCAL Statement</a></h3><span
class=docs-card-date><i class="fas fa-calendar-alt"></i>
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---copy-from-local-statement>Apache Hive : HPL/SQL - COPY
FROM LOCAL Statement</h1><p>COPY FROM LOCAL statement allows to copy local
directories and files to Hadoop compatible file system. Using this statement
you can easily copy subdirectories into HDFS
i.e.</p><p><strong>Syntax</strong>:</p><pre tabindex=0><code>COPY FROM LOCAL
src [, src2, ...] TO tgt [options]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-</code></pre><p>Notes:</p><ul><li><em>srcN</em> specifies a file or directory.
If a directory is specified all subdirectories and their files are copied as
well.</li><li><em>srcN</em> can be an expression, variable, quoted or unquoted
string.</li><li>If a single file is copied <em>tgt</em> must specify a path
including the target file name.</li><li>If multiple files are copied
<em>tgt</em> must specify a directory.</li><li>If the target directory does not
exist it is created.</li><li>OVE [...]
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---copy-statement>Apache Hive : HPL/SQL - COPY
Statement</h1><p>COPY statement allows to transfer data between tables and
files. Use it to transfer relatively small volumes of data i.e. query results,
look-up and dimension tables.</p><p>When you copy data between tables they can
be located in different databases.</p><p><strong>Syntax</strong>:</p><p>Export
data to a file:</p><pre tabindex=0><code>COPY table_n [...]
-
-options:
- DELIMITER 'char'
-| SQLINSERT target_table_name
-</code></pre><p>Copy data between existing tables:</p></div><div
class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy/
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/hplsql/statements/create-database/>Apache
Hive : HPL/SQL - CREATE DATABASE Statement</a></h3><span
class=docs-card-date><i class="fas fa-cal [...]
+</code></pre><p>Notes:</p><ul><li>When data are equal, the CMP statement sets
SQLCODE to 0. If data are not equal, SQLCODE is set to 1. In case of any SQL
error, SQLCODE is set to -1</li><li>When the connection profile is not
specified, the default connection profile is used for the specified
table</li></ul><p><strong>Example 1</strong>:</p></div><div
class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/cmp/
class=docs-card-link>Read more <i class [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---create-database-statement>Apache Hive : HPL/SQL -
CREATE DATABASE Statement</h1><p>CREATE DATABASE statement allows you to create
a database.</p><p><strong>Syntax</strong>:</p><pre tabindex=0><code>CREATE
DATABASE | SCHEMA [IF NOT EXISTS] dbname_expr
[COMMENT comment_expr]
[LOCATION path_expr]
@@ -184,10 +163,7 @@ Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql
</code></pre><p><strong>Example</strong>:</p><p>Drop a database named
<em>testYYYYMMDD</em> (current date):</p><pre tabindex=0><code>drop database if
exists 'test' || replace(current_date, '-', '');
</code></pre><p><strong>Compatibility:</strong> Hive</p><p>See
also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/>CREATE
DATABASE</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/use/>USE</a></li></ul></div><div
class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/drop-database/
class=docs-card-link>Read more <i class="fas
fa-arrow-right"></i></a></div></div><d [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---drop-table-statement>Apache Hive : HPL/SQL - DROP
TABLE Statement</h1><p>DROP TABLE statement drops a
table.</p><p><strong>Syntax</strong>:</p><pre tabindex=0><code>DROP TABLE [IF
EXISTS] table_name
-</code></pre><p><strong>Compatibility:</strong> Oracle, Microsoft SQL Server,
IBM DB2, Teradata, PostgreSQL, MySQL, Hive</p><p>See also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/truncate/>TRUNCATE
TABLE</a></li></ul></div><div class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/drop-table/
class=docs-card-link>Read more <i class="fas
fa-arrow-right"></i></a></div></div><div class=docs-card><div class=docs- [...]
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---execute-os-command-or-external-process>Apache Hive :
HPL/SQL - Execute OS Command or External Process</h1><p>HPL/SQL allows you to
execute an OS command or external process from a HPL/SQL
script:</p><p><strong>Syntax</strong>:</p><p>! command:</p><pre
tabindex=0><code>!cmd [arguments];
-</code></pre><p>HOST statement:</p><pre tabindex=0><code>HOST string_expr
-</code></pre><p><strong>Parameters:</strong></p><table><thead><tr><th><strong>Parameter</strong></th><th><strong>Description</strong></th></tr></thead><tbody><tr><td>cmd</td><td>Any
OS command or process</td></tr><tr><td>arguments</td><td>Optional argument
list</td></tr><tr><td>string_expr</td><td>Command line for HOST
statement</td></tr></tbody></table><p><strong>Notes</strong>:</p><ul><li>Blank
characters are allowed between ! and cmd</li><li>The ! command must be
terminated by a semic [...]
+</code></pre><p><strong>Compatibility:</strong> Oracle, Microsoft SQL Server,
IBM DB2, Teradata, PostgreSQL, MySQL, Hive</p><p>See also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/truncate/>TRUNCATE
TABLE</a></li></ul></div><div class=docs-card-footer><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/drop-table/
class=docs-card-link>Read more <i class="fas
fa-arrow-right"></i></a></div></div><div class=docs-card><div class=docs- [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---execute-statement>Apache Hive : HPL/SQL - EXECUTE
Statement</h1><p>EXECUTE (EXEC or EXECUTE IMMEDIATE) statement executes a
dynamic SQL statement and can return the scalar result to local
variables.</p><p>You can also use this statement to call a stored
procedure.</p><p><strong>Syntax:</strong></p><pre tabindex=0><code>EXEC |
EXECUTE | EXECUTE IMMEDIATE dynamic_sql_string [INTO var1, var2, ...];
|
EXEC | EXECUTE proc_name [parm1 = val1, ... ]
diff --git a/docs/latest/language/hplsql/statements/index.xml
b/docs/latest/language/hplsql/statements/index.xml
index 9563a2c3..6ae57385 100644
--- a/docs/latest/language/hplsql/statements/index.xml
+++ b/docs/latest/language/hplsql/statements/index.xml
@@ -99,48 +99,7 @@ CLOSE cur;
<li>When data are equal, the CMP statement sets SQLCODE to 0. If data
are not equal, SQLCODE is set to 1. In case of any SQL error, SQLCODE is set to
-1</li>
<li>When the connection profile is not specified, the default connection
profile is used for the specified table</li>
</ul>
-<p><strong>Example
1</strong>:</p></description></item><item><title>Apache Hive :
HPL/SQL - COPY FROM FTP
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-ftp/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-ftp/</guid><description><h1
id="apache-hive--hplsql---copy-from-ftp-statement">Apache Hive : HPL/SQL -
COPY FROM FTP Sta [...]
-<p>COPY FROM FTP statement allows to copy files from a FTP server to
local or any Hadoop compatible file system. Using this statement you can easily
copy FTP subdirectories into HDFS i.e.</p>
-<p>The NEW option helps you build a ETL process and download only new
files from FTP.</p>
-<p><strong>Syntax</strong>:</p>
-<pre tabindex="0"><code>COPY FROM FTP host [USER user [PWD
password]] [DIR directory] [FILES files_wildcard]
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num
-</code></pre><p>Notes:</p></description></item><item><title>Apache
Hive : HPL/SQL - COPY FROM LOCAL
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/</guid><description><h1
id="apache-hive--hplsql---copy-from-local-statement">Apache Hive : HPL/SQL
- COPY FROM LOCAL S [...]
-<p>COPY FROM LOCAL statement allows to copy local directories and files
to Hadoop compatible file system. Using this statement you can easily copy
subdirectories into HDFS i.e.</p>
-<p><strong>Syntax</strong>:</p>
-<pre tabindex="0"><code>COPY FROM LOCAL src [, src2, ...] TO tgt
[options]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-</code></pre><p>Notes:</p>
-<ul>
-<li><em>srcN</em> specifies a file or directory. If a
directory is specified all subdirectories and their files are copied as
well.</li>
-<li><em>srcN</em> can be an expression, variable, quoted or
unquoted string.</li>
-<li>If a single file is copied <em>tgt</em> must specify a
path including the target file name.</li>
-<li>If multiple files are copied <em>tgt</em> must specify a
directory.</li>
-<li>If the target directory does not exist it is created.</li>
-<li>OVERWRITE specifies to overwrite the target files if they
exist.</li>
-<li>DELETE specifies to delete the source file upon successfull
copy.</li>
-<li>IGNORE specifies to ignore errors when copying a file and proceed to
copy the remaining files.</li>
-</ul>
-<p><strong>Example</strong>:</p></description></item><item><title>Apache
Hive : HPL/SQL - COPY
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy/</guid><description><h1
id="apache-hive--hplsql---copy-statement">Apache Hive : HPL/SQL - COPY
Statement</h1>
-<p>COPY statement allows to transfer data between tables and files. Use
it to transfer relatively small volumes of data i.e. query results, look-up and
dimension tables.</p>
-<p>When you copy data between tables they can be located in different
databases.</p>
-<p><strong>Syntax</strong>:</p>
-<p>Export data to a file:</p>
-<pre tabindex="0"><code>COPY table_name | (select_stmt) TO [HDFS]
file_name [options]
-
-options:
- DELIMITER &#39;char&#39;
-| SQLINSERT target_table_name
-</code></pre><p>Copy data between existing
tables:</p></description></item><item><title>Apache Hive : HPL/SQL -
CREATE DATABASE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</guid><description><h1
id="apache-hive--hplsql---create-database-statement">Apache Hive : [...]
+<p><strong>Example
1</strong>:</p></description></item><item><title>Apache Hive :
HPL/SQL - CREATE DATABASE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</guid><description><h1
id="apache-hive--hplsql---create-database-statement">Apache Hive : HPL/SQL
- CREATE DA [...]
<p>CREATE DATABASE statement allows you to create a database.</p>
<p><strong>Syntax</strong>:</p>
<pre tabindex="0"><code>CREATE DATABASE | SCHEMA [IF NOT EXISTS]
dbname_expr
@@ -372,42 +331,7 @@ value string default
<p>See also:</p>
<ul>
<li><a
href="https://hive.apache.org/docs/latest/language/hplsql/statements/truncate/">TRUNCATE
TABLE</a></li>
-</ul></description></item><item><title>Apache Hive : HPL/SQL - Execute
OS Command or External
Process</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/host/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/host/</guid><description><h1
id="apache-hive--hplsql---execute-os-command-or-external-process">Apache
Hive : HPL/SQL - Execute OS Command or External Process</h1>
-<p>HPL/SQL allows you to execute an OS command or external process from
a HPL/SQL script:</p>
-<p><strong>Syntax</strong>:</p>
-<p>! command:</p>
-<pre tabindex="0"><code>!cmd [arguments];
-</code></pre><p>HOST statement:</p>
-<pre tabindex="0"><code>HOST string_expr
-</code></pre><p><strong>Parameters:</strong></p>
-<table>
- <thead>
- <tr>
- <th><strong>Parameter</strong></th>
- <th><strong>Description</strong></th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>cmd</td>
- <td>Any OS command or process</td>
- </tr>
- <tr>
- <td>arguments</td>
- <td>Optional argument list</td>
- </tr>
- <tr>
- <td>string_expr</td>
- <td>Command line for HOST statement</td>
- </tr>
- </tbody>
-</table>
-<p><strong>Notes</strong>:</p>
-<ul>
-<li>Blank characters are allowed between ! and cmd</li>
-<li>The ! command must be terminated by a semicolon (;)</li>
-</ul>
-<p><strong>Example:</strong></p></description></item><item><title>Apache
Hive : HPL/SQL - EXECUTE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</guid><description><h1
id="apache-hive--hplsql---execute-statement">Apache Hive : HPL/SQL -
EXECUTE Statement</h1>
+</ul></description></item><item><title>Apache Hive : HPL/SQL - EXECUTE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</guid><description><h1
id="apache-hive--hplsql---execute-statement">Apache Hive : HPL/SQL -
EXECUTE Statement</h1>
<p>EXECUTE (EXEC or EXECUTE IMMEDIATE) statement executes a dynamic SQL
statement and can return the scalar result to local variables.</p>
<p>You can also use this statement to call a stored procedure.</p>
<p><strong>Syntax:</strong></p>
diff --git a/docs/latest/language/hplsql/statements/insert-directory/index.html
b/docs/latest/language/hplsql/statements/insert-directory/index.html
index 1ee951f4..00034831 100644
--- a/docs/latest/language/hplsql/statements/insert-directory/index.html
+++ b/docs/latest/language/hplsql/statements/insert-directory/index.html
@@ -9,7 +9,7 @@ Last updated: August 12, 2026</span></div></header><div
class=docs-toc><h4><i cl
insert overwrite directory '/data/sales_' || current_date
'select * from ' || tabname;
-</code></pre><p><strong>Compatibility:</strong> Hive</p><p>See
also:</p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy/>COPY</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/>COPY
FROM LOCAL</a></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><b [...]
+</code></pre><p><strong>Compatibility:</strong> Hive</p></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">
diff --git a/docs/latest/language/hplsql/user-guide/configuration/index.html
b/docs/latest/language/hplsql/user-guide/configuration/index.html
index 80cc3b01..cb74018c 100644
--- a/docs/latest/language/hplsql/user-guide/configuration/index.html
+++ b/docs/latest/language/hplsql/user-guide/configuration/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 : HPL/SQL - Configurations</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : HPL/SQL - Configurations</h1>< [...]
-Last updated: August 12, 2026</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--hplsql---configurations>Apache
Hive : HPL/SQL - Configurations</a><ul><li><a
href=#hplsqlonerror>hplsql.onerror</a></li><li><a
href=#hplsqltemptables>hplsql.temp.tables</a></li><li><a
href=#hplsqltemptablesschema>hplsql.temp.tables.schema</a></li><li><a
href=#hplsqltemptableslocation>hplsql.temp.tables.location< [...]
+Last updated: August 12, 2026</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--hplsql---configurations>Apache
Hive : HPL/SQL - Configurations</a><ul><li><a
href=#hplsqlonerror>hplsql.onerror</a></li><li><a
href=#hplsqltemptables>hplsql.temp.tables</a></li><li><a
href=#hplsqltemptablesschema>hplsql.temp.tables.schema</a></li><li><a
href=#hplsqltemptableslocation>hplsql.temp.tables.location< [...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
<button class="btn btn-feedback btn-negative">
diff --git a/docs/latest/language/hplsql/user-guide/error-handling/index.html
b/docs/latest/language/hplsql/user-guide/error-handling/index.html
index 170f6fcf..efebbae9 100644
--- a/docs/latest/language/hplsql/user-guide/error-handling/index.html
+++ b/docs/latest/language/hplsql/user-guide/error-handling/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 : HPL/SQL - Error Handling</li></ol></nav><header class=docs-header><h1
class=docs-title>Apache Hive : HPL/SQL - Error Handling</h1>< [...]
-Last updated: August 12, 2026</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--hplsql---error-handling>Apache
Hive : HPL/SQL - Error Handling</a></li></ul></nav></div><div
class=docs-article><h1 id=apache-hive--hplsql---error-handling>Apache Hive :
HPL/SQL - Error Handling</h1><p>HPL/SQL allows you to use exceptions, condition
handlers and error code to handle errors. The <a href=https://h [...]
+Last updated: August 12, 2026</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--hplsql---error-handling>Apache
Hive : HPL/SQL - Error Handling</a></li></ul></nav></div><div
class=docs-article><h1 id=apache-hive--hplsql---error-handling>Apache Hive :
HPL/SQL - Error Handling</h1><p>HPL/SQL allows you to use exceptions, condition
handlers and error code to handle errors. The <a href=https://h [...]
</code></pre><p><strong>See also:</strong></p><ul><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/declare-condition/>DECLARE
CONDITION</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/statements/declare-handler/>DECLARE
HANDLER</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/sqlcode/>SQLCODE</a></li><li><a
href=https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/sqlstate/>SQLST
[...]
<i class="fas fa-thumbs-up"></i> Yes
</button>
diff --git a/docs/latest/language/hplsql/user-guide/index.html
b/docs/latest/language/hplsql/user-guide/index.html
index 1401786a..586a74fe 100644
--- a/docs/latest/language/hplsql/user-guide/index.html
+++ b/docs/latest/language/hplsql/user-guide/index.html
@@ -4,8 +4,8 @@
<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 class=active>User Guide</li></ol></nav><header
class=docs-header><h1 class=docs-title>User Guide</h1><div
class=docs-meta><span class=docs-count><i class="fas fa-file-alt"></i>
6 documents</span></div></header><div class=docs-article><div
class=docs-grid><div class=docs-card><div class=docs-card-header><h3><a
href=https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/>Apache
Hive : HPL/SQL - Configurations</a></h3><span class=docs-card-date><i
class="fas fa-calendar-alt"></i>
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---configurations>Apache Hive : HPL/SQL -
Configurations</h1><p>You can set all options dynamically using the <a
href=https://hive.apache.org/docs/latest/language/hplsql/language-elements/assign/>SET</a>
statement in a HPL/SQL script: <code>SET option=value;</code></p><h2
id=hplsqlonerror>hplsql.onerror</h2><p>The <em>hplsql.onerror</em> option
defines how HPL/SQL handles errors.</p><p>Values:</p><ul><li><str [...]
-Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---error-handling>Apache Hive : HPL/SQL - Error
Handling</h1><p>HPL/SQL allows you to use exceptions, condition handlers and
error code to handle errors. The <a
href=https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror>hplsql.onerror</a>
configuration option defines how HPL/SQL handles errors. It accepts the
following values:</p><ul><li><strong>Exception</strong> (defaul [...]
+Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---configurations>Apache Hive : HPL/SQL -
Configurations</h1><p>You can set all options dynamically using the <a
href=https://hive.apache.org/docs/latest/language/hplsql/language-elements/assign/>SET</a>
statement in a HPL/SQL script: <code>SET option=value;</code></p><h2
id=hplsqlonerror>hplsql.onerror</h2><p>The <em>hplsql.onerror</em> option
defines how HPL/SQL handles errors.</p><p>Values:</p><ul><li><str [...]
+Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---error-handling>Apache Hive : HPL/SQL - Error
Handling</h1><p>HPL/SQL allows you to use exceptions, condition handlers and
error code to handle errors. The <a
href=https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror>hplsql.onerror</a>
configuration option defines how HPL/SQL handles errors. It accepts the
following values:</p><ul><li><strong>Exception</strong> (defaul [...]
Aug 12, 2026</span></div><div class=docs-card-summary><h1
id=apache-hive--hplsql---hive-udf-to-run-hplsql-scripts-from-beeline-in-non-hplsql-mode>Apache
Hive : HPL/SQL - Hive UDF to Run HPL/SQL Scripts from Beeline in non-hplsql
mode</h1><p>HPL/SQL includes a Hive UDF
function(<em><strong>hplsql</strong></em>) that allows you to execute HPL/SQL
scripts (user-defined functions written in HPL/SQL language) in Hive
queries.</p><p>For example, let’s call the following function from a H
[...]
RETURNS STRING
BEGIN
diff --git a/docs/latest/language/hplsql/user-guide/index.xml
b/docs/latest/language/hplsql/user-guide/index.xml
index 1e665e40..1062d044 100644
--- a/docs/latest/language/hplsql/user-guide/index.xml
+++ b/docs/latest/language/hplsql/user-guide/index.xml
@@ -5,7 +5,7 @@
<p>Values:</p>
<ul>
<li><strong>exception</strong> - HPL/SQL raises an exception
when an error occurs. This is the default.</li>
-<li><strong>seterror</strong> - HPL/SQL sets the error code
to SQLCODE or HOSTCODE variables and continues execution</li>
+<li><strong>seterror</strong> - HPL/SQL sets the error code
to SQLCODE variables and continues execution</li>
<li><strong>stop</strong> - HPL/SQL stops executing the
script and exits.</li>
</ul>
<p>For more information, see <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/">Error
Handling</a>.</p></description></item><item><title>Apache Hive :
HPL/SQL - Error
Handling</title><link>https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/</guid><description>&l
[...]
@@ -17,7 +17,7 @@
<ul>
<li><strong>Seterror</strong></li>
</ul>
-<p>When Seterror is specified, HPL/SQL sets the error code to SQLCODE or
HOSTCODE variables and continues
execution.</p></description></item><item><title>Apache Hive : HPL/SQL -
Hive UDF to Run HPL/SQL Scripts from Beeline in non-hplsql
mode</title><link>https://hive.apache.org/docs/latest/language/hplsql/user-guide/udf/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/user-guide/udf/</guid><description><h1
i [...]
+<p>When Seterror is specified, HPL/SQL sets the error code to SQLCODE
variables and continues
execution.</p></description></item><item><title>Apache Hive : HPL/SQL -
Hive UDF to Run HPL/SQL Scripts from Beeline in non-hplsql
mode</title><link>https://hive.apache.org/docs/latest/language/hplsql/user-guide/udf/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/user-guide/udf/</guid><description><h1
id="apache-hi [...]
<p>HPL/SQL includes a Hive UDF
function(<em><strong>hplsql</strong></em>) that allows
you to execute HPL/SQL scripts (user-defined functions written in HPL/SQL
language) in Hive queries.</p>
<p>For example, let&rsquo;s call the following function from a Hive
query:</p>
<pre tabindex="0"><code>CREATE FUNCTION hello(text STRING)
diff --git a/index.json b/index.json
index eba2d645..30a3609c 100644
--- a/index.json
+++ b/index.json
@@ -1 +1 @@
-[{"categories":null,"contents":"Apache Hive : HPL/SQL - %ROWTYPE Attribute
%ROWTYPE attribute lets you declare a record variable that has the same columns
and data types as the specified database table.\nSyntax:\nvar_name
[schema.]table_name%ROWTYPE Examples:\nDECLARE v orders%ROWTYPE; BEGIN SELECT *
INTO v FROM orders LIMIT 1; DBMS_OUTPUT.PUT_LINE(\u0026#39;Item: \u0026#39; ||
v.name || \u0026#39; - \u0026#39; || v.description); END; DECLARE v
orders%ROWTYPE; CURSOR c IS SELECT * FROM o [...]
\ No newline at end of file
+[{"categories":null,"contents":"Apache Hive : HPL/SQL - %ROWTYPE Attribute
%ROWTYPE attribute lets you declare a record variable that has the same columns
and data types as the specified database table.\nSyntax:\nvar_name
[schema.]table_name%ROWTYPE Examples:\nDECLARE v orders%ROWTYPE; BEGIN SELECT *
INTO v FROM orders LIMIT 1; DBMS_OUTPUT.PUT_LINE(\u0026#39;Item: \u0026#39; ||
v.name || \u0026#39; - \u0026#39; || v.description); END; DECLARE v
orders%ROWTYPE; CURSOR c IS SELECT * FROM o [...]
\ No newline at end of file
diff --git a/index.xml b/index.xml
index 5c079609..b48bac9a 100644
--- a/index.xml
+++ b/index.xml
@@ -301,51 +301,10 @@ CLOSE cur;
<p>Values:</p>
<ul>
<li><strong>exception</strong> - HPL/SQL raises an exception
when an error occurs. This is the default.</li>
-<li><strong>seterror</strong> - HPL/SQL sets the error code
to SQLCODE or HOSTCODE variables and continues execution</li>
+<li><strong>seterror</strong> - HPL/SQL sets the error code
to SQLCODE variables and continues execution</li>
<li><strong>stop</strong> - HPL/SQL stops executing the
script and exits.</li>
</ul>
-<p>For more information, see <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/">Error
Handling</a>.</p></description></item><item><title>Apache Hive :
HPL/SQL - COPY FROM FTP
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-ftp/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-ftp/</guid><descrip
[...]
-<p>COPY FROM FTP statement allows to copy files from a FTP server to
local or any Hadoop compatible file system. Using this statement you can easily
copy FTP subdirectories into HDFS i.e.</p>
-<p>The NEW option helps you build a ETL process and download only new
files from FTP.</p>
-<p><strong>Syntax</strong>:</p>
-<pre tabindex="0"><code>COPY FROM FTP host [USER user [PWD
password]] [DIR directory] [FILES files_wildcard]
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num
-</code></pre><p>Notes:</p></description></item><item><title>Apache
Hive : HPL/SQL - COPY FROM LOCAL
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy-from-local/</guid><description><h1
id="apache-hive--hplsql---copy-from-local-statement">Apache Hive : HPL/SQL
- COPY FROM LOCAL S [...]
-<p>COPY FROM LOCAL statement allows to copy local directories and files
to Hadoop compatible file system. Using this statement you can easily copy
subdirectories into HDFS i.e.</p>
-<p><strong>Syntax</strong>:</p>
-<pre tabindex="0"><code>COPY FROM LOCAL src [, src2, ...] TO tgt
[options]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-</code></pre><p>Notes:</p>
-<ul>
-<li><em>srcN</em> specifies a file or directory. If a
directory is specified all subdirectories and their files are copied as
well.</li>
-<li><em>srcN</em> can be an expression, variable, quoted or
unquoted string.</li>
-<li>If a single file is copied <em>tgt</em> must specify a
path including the target file name.</li>
-<li>If multiple files are copied <em>tgt</em> must specify a
directory.</li>
-<li>If the target directory does not exist it is created.</li>
-<li>OVERWRITE specifies to overwrite the target files if they
exist.</li>
-<li>DELETE specifies to delete the source file upon successfull
copy.</li>
-<li>IGNORE specifies to ignore errors when copying a file and proceed to
copy the remaining files.</li>
-</ul>
-<p><strong>Example</strong>:</p></description></item><item><title>Apache
Hive : HPL/SQL - COPY
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/copy/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/copy/</guid><description><h1
id="apache-hive--hplsql---copy-statement">Apache Hive : HPL/SQL - COPY
Statement</h1>
-<p>COPY statement allows to transfer data between tables and files. Use
it to transfer relatively small volumes of data i.e. query results, look-up and
dimension tables.</p>
-<p>When you copy data between tables they can be located in different
databases.</p>
-<p><strong>Syntax</strong>:</p>
-<p>Export data to a file:</p>
-<pre tabindex="0"><code>COPY table_name | (select_stmt) TO [HDFS]
file_name [options]
-
-options:
- DELIMITER &#39;char&#39;
-| SQLINSERT target_table_name
-</code></pre><p>Copy data between existing
tables:</p></description></item><item><title>Apache Hive : HPL/SQL -
CREATE DATABASE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</guid><description><h1
id="apache-hive--hplsql---create-database-statement">Apache Hive : [...]
+<p>For more information, see <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/">Error
Handling</a>.</p></description></item><item><title>Apache Hive :
HPL/SQL - CREATE DATABASE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/create-database/</guid><d
[...]
<p>CREATE DATABASE statement allows you to create a database.</p>
<p><strong>Syntax</strong>:</p>
<pre tabindex="0"><code>CREATE DATABASE | SCHEMA [IF NOT EXISTS]
dbname_expr
@@ -959,7 +918,7 @@ value string default
<ul>
<li><strong>Seterror</strong></li>
</ul>
-<p>When Seterror is specified, HPL/SQL sets the error code to SQLCODE or
HOSTCODE variables and continues
execution.</p></description></item><item><title>Apache Hive : HPL/SQL -
Exceptions</title><link>https://hive.apache.org/docs/latest/language/hplsql/language-elements/exceptions/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/language-elements/exceptions/</guid><description><h1
id="apache-hive--hplsql--- [...]
+<p>When Seterror is specified, HPL/SQL sets the error code to SQLCODE
variables and continues
execution.</p></description></item><item><title>Apache Hive : HPL/SQL -
Exceptions</title><link>https://hive.apache.org/docs/latest/language/hplsql/language-elements/exceptions/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/language-elements/exceptions/</guid><description><h1
id="apache-hive--hplsql---exceptions"& [...]
<p>HPL/SQL allows you to handle exceptions in your programs.</p>
<p><strong>Syntax:</strong></p>
<pre tabindex="0"><code>BEGIN
@@ -981,42 +940,7 @@ BEGIN
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(&#39;Error&#39;);
END
-</code></pre><p><strong>Compatibility</strong>:
Oracle, PostgreSQL and
Netezza.</p></description></item><item><title>Apache Hive : HPL/SQL -
Execute OS Command or External
Process</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/host/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/host/</guid><description><h1
id="apache-hive--hplsql---execute-os- [...]
-<p>HPL/SQL allows you to execute an OS command or external process from
a HPL/SQL script:</p>
-<p><strong>Syntax</strong>:</p>
-<p>! command:</p>
-<pre tabindex="0"><code>!cmd [arguments];
-</code></pre><p>HOST statement:</p>
-<pre tabindex="0"><code>HOST string_expr
-</code></pre><p><strong>Parameters:</strong></p>
-<table>
- <thead>
- <tr>
- <th><strong>Parameter</strong></th>
- <th><strong>Description</strong></th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>cmd</td>
- <td>Any OS command or process</td>
- </tr>
- <tr>
- <td>arguments</td>
- <td>Optional argument list</td>
- </tr>
- <tr>
- <td>string_expr</td>
- <td>Command line for HOST statement</td>
- </tr>
- </tbody>
-</table>
-<p><strong>Notes</strong>:</p>
-<ul>
-<li>Blank characters are allowed between ! and cmd</li>
-<li>The ! command must be terminated by a semicolon (;)</li>
-</ul>
-<p><strong>Example:</strong></p></description></item><item><title>Apache
Hive : HPL/SQL - EXECUTE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</guid><description><h1
id="apache-hive--hplsql---execute-statement">Apache Hive : HPL/SQL -
EXECUTE Statement</h1>
+</code></pre><p><strong>Compatibility</strong>:
Oracle, PostgreSQL and
Netezza.</p></description></item><item><title>Apache Hive : HPL/SQL -
EXECUTE
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/execute/</guid><description><h1
id="apache-hive--hplsql---execute-statement">Apac [...]
<p>EXECUTE (EXEC or EXECUTE IMMEDIATE) statement executes a dynamic SQL
statement and can return the scalar result to local variables.</p>
<p>You can also use this statement to call a stored procedure.</p>
<p><strong>Syntax:</strong></p>
@@ -1199,20 +1123,7 @@ BEGIN
RETURN &#39;Hello, &#39; || text || &#39;!&#39;;
END;
</code></pre><h2
id="running-hplsql-scripts-from-beeline-in-non-hplsql-mode">Running HPL/SQL
scripts from Beeline in non-hplsql mode</h2>
-<p>Now let&rsquo;s use <em>hello</em> function written
in HPL/SQL language in Hive
query:</p></description></item><item><title>Apache Hive : HPL/SQL -
HOSTCODE</title><link>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/hostcode/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/built-in-variables/hostcode/</guid><description><h1
id="apache-hive--hplsql---hostcode">Ap [...]
-<p>HOSTCODE built-in variable contains the return code of the last OS
command.</p>
-<pre tabindex="0"><code>SET hplsql.onerror = SETERROR;
-
-HOST &#39;echo hello, world&#39;;
-IF HOSTCODE &lt;&gt; 0 THEN
- PRINT &#39;Error&#39;;
-END IF;
-</code></pre><p><strong>Notes</strong>:</p>
-<ul>
-<li>Typically HOSTCODE is 0 when the process terminated successfully,
and 1 if it terminated with an error.</li>
-<li>By default <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror">hplsql.onerror</a>
is set to EXCEPTION, so if the OS command cannot be executed (the process does
not exist, no permissions i.e.) the exception is raised and you are not be able
to check HOSTCODE in IF statement.</li>
-</ul>
-<p>For more information, see <a
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/">Error
Handling</a>.</p></description></item><item><title>Apache Hive :
HPL/SQL - IF
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/if/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/if/</guid><description><h1
id="apache-hive--hpls [...]
+<p>Now let&rsquo;s use <em>hello</em> function written
in HPL/SQL language in Hive
query:</p></description></item><item><title>Apache Hive : HPL/SQL - IF
Statement</title><link>https://hive.apache.org/docs/latest/language/hplsql/statements/if/</link><pubDate>Wed,
12 Aug 2026 00:00:00
+0000</pubDate><guid>https://hive.apache.org/docs/latest/language/hplsql/statements/if/</guid><description><h1
id="apache-hive--hplsql---if-statement">Apache Hive : HPL/SQL [...]
<p>IF statement executes a set of statements depending on the value of a
boolean expression.</p>
<p>HPL/SQL supports multiple syntaxes for IF statement.</p>
<h2 id="if---then---elsifelseif---else---end-if">IF - THEN -
ELSIF/ELSEIF - ELSE - END IF</h2>
diff --git a/sitemap.xml b/sitemap.xml
index 570b2e4d..8ed3a995 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/latest/language/hplsql/language-elements/rowtype-attribute/</loc><lastmod>2026-08-12T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/language/hplsql/language-elements/type-attribute/</loc><lastmod>2026-08-12T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache
[...]
\ 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/hplsql/language-elements/rowtype-attribute/</loc><lastmod>2026-08-12T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache.org/docs/latest/language/hplsql/language-elements/type-attribute/</loc><lastmod>2026-08-12T00:00:00+00:00</lastmod></url><url><loc>https://hive.apache
[...]
\ No newline at end of file