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 &#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>< [...]
-<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 &#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>< [...]
+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 &#39;SELECT id FROM db.orders&#39;;
 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=" [...]
 &lt;p&gt;ACTIVITY_COUNT built-in variable contains the number of rows affected 
by the last SQL statement.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Important Note:&lt;/strong&gt; 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 &lt;a 
href="https://issues.apache.org/jira/browse/HIVE-7680"&gt;HIVE-7680&lt;/a&gt; 
for more details.&lt;/p&gt;
-&lt;p&gt;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.&lt;/p&gt;</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 [...]
-&lt;p&gt;HOSTCODE built-in variable contains the return code of the last OS 
command.&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;SET hplsql.onerror = SETERROR;
-
-HOST &amp;#39;echo hello, world&amp;#39;;
-IF HOSTCODE &amp;lt;&amp;gt; 0 THEN
- PRINT &amp;#39;Error&amp;#39;;
-END IF;
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Notes&lt;/strong&gt;:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;Typically HOSTCODE is 0 when the process terminated successfully, 
and 1 if it terminated with an error.&lt;/li&gt;
-&lt;li&gt;By default &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror"&gt;hplsql.onerror&lt;/a&gt;
 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.&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;For more information, see &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/"&gt;Error
 Handling&lt;/a&gt;.&lt;/p&gt;</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>&lt;h1
  [...]
+&lt;p&gt;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.&lt;/p&gt;</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 [...]
 &lt;p&gt;SQLCODE built-in variable contains the return code of the last SQL 
statement. The code can be zero (0), negative or positive:&lt;/p&gt;
 &lt;table&gt;
  &lt;thead&gt;
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 &#39;char&#39;
-| 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, &lsquo;\t&rsquo; (TAB character) is the 
default.</li><li>SQLINSERT specifies to generate SQL INSERT statements to 
insert data to < [...]
-  TO /data/users.txt DELIMITER &#39;\t&#39;;
-</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 &#39;echo 
Hello, world&#39;;
-</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 &#39;char&#39;
-| 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 &#39;test&#39; || replace(current_date, &#39;-&#39;, &#39;&#39;);
 </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;
 &lt;li&gt;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&lt;/li&gt;
 &lt;li&gt;When the connection profile is not specified, the default connection 
profile is used for the specified table&lt;/li&gt;
 &lt;/ul&gt;
-&lt;p&gt;&lt;strong&gt;Example 
1&lt;/strong&gt;:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---copy-from-ftp-statement"&gt;Apache Hive : HPL/SQL - 
COPY FROM FTP Sta [...]
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;The NEW option helps you build a ETL process and download only new 
files from FTP.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY FROM FTP host [USER user [PWD 
password]] [DIR directory] [FILES files_wildcard] 
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num 
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Notes:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---copy-from-local-statement"&gt;Apache Hive : HPL/SQL 
- COPY FROM LOCAL S [...]
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY FROM LOCAL src [, src2, ...] TO tgt 
[options]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Notes:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;&lt;em&gt;srcN&lt;/em&gt; specifies a file or directory. If a 
directory is specified all subdirectories and their files are copied as 
well.&lt;/li&gt;
-&lt;li&gt;&lt;em&gt;srcN&lt;/em&gt; can be an expression, variable, quoted or 
unquoted string.&lt;/li&gt;
-&lt;li&gt;If a single file is copied &lt;em&gt;tgt&lt;/em&gt; must specify a 
path including the target file name.&lt;/li&gt;
-&lt;li&gt;If multiple files are copied &lt;em&gt;tgt&lt;/em&gt; must specify a 
directory.&lt;/li&gt;
-&lt;li&gt;If the target directory does not exist it is created.&lt;/li&gt;
-&lt;li&gt;OVERWRITE specifies to overwrite the target files if they 
exist.&lt;/li&gt;
-&lt;li&gt;DELETE specifies to delete the source file upon successfull 
copy.&lt;/li&gt;
-&lt;li&gt;IGNORE specifies to ignore errors when copying a file and proceed to 
copy the remaining files.&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;&lt;strong&gt;Example&lt;/strong&gt;:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---copy-statement"&gt;Apache Hive : HPL/SQL - COPY 
Statement&lt;/h1&gt;
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;When you copy data between tables they can be located in different 
databases.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;p&gt;Export data to a file:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY table_name | (select_stmt) TO [HDFS] 
file_name [options]
-
-options:
- DELIMITER &amp;#39;char&amp;#39;
-| SQLINSERT target_table_name
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Copy data between existing 
tables:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---create-database-statement"&gt;Apache Hive : [...]
+&lt;p&gt;&lt;strong&gt;Example 
1&lt;/strong&gt;:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---create-database-statement"&gt;Apache Hive : HPL/SQL 
- CREATE DA [...]
 &lt;p&gt;CREATE DATABASE statement allows you to create a database.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
 &lt;pre tabindex="0"&gt;&lt;code&gt;CREATE DATABASE | SCHEMA [IF NOT EXISTS] 
dbname_expr
@@ -372,42 +331,7 @@ value string default
 &lt;p&gt;See also:&lt;/p&gt;
 &lt;ul&gt;
 &lt;li&gt;&lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/statements/truncate/"&gt;TRUNCATE
 TABLE&lt;/a&gt;&lt;/li&gt;
-&lt;/ul&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-os-command-or-external-process"&gt;Apache 
Hive : HPL/SQL - Execute OS Command or External Process&lt;/h1&gt;
-&lt;p&gt;HPL/SQL allows you to execute an OS command or external process from 
a HPL/SQL script:&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;p&gt;! command:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;!cmd [arguments];
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;HOST statement:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;HOST string_expr
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Parameters:&lt;/strong&gt;&lt;/p&gt;
-&lt;table&gt;
- &lt;thead&gt;
- &lt;tr&gt;
- &lt;th&gt;&lt;strong&gt;Parameter&lt;/strong&gt;&lt;/th&gt;
- &lt;th&gt;&lt;strong&gt;Description&lt;/strong&gt;&lt;/th&gt;
- &lt;/tr&gt;
- &lt;/thead&gt;
- &lt;tbody&gt;
- &lt;tr&gt;
- &lt;td&gt;cmd&lt;/td&gt;
- &lt;td&gt;Any OS command or process&lt;/td&gt;
- &lt;/tr&gt;
- &lt;tr&gt;
- &lt;td&gt;arguments&lt;/td&gt;
- &lt;td&gt;Optional argument list&lt;/td&gt;
- &lt;/tr&gt;
- &lt;tr&gt;
- &lt;td&gt;string_expr&lt;/td&gt;
- &lt;td&gt;Command line for HOST statement&lt;/td&gt;
- &lt;/tr&gt;
- &lt;/tbody&gt;
-&lt;/table&gt;
-&lt;p&gt;&lt;strong&gt;Notes&lt;/strong&gt;:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;Blank characters are allowed between ! and cmd&lt;/li&gt;
-&lt;li&gt;The ! command must be terminated by a semicolon (;)&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;&lt;strong&gt;Example:&lt;/strong&gt;&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-statement"&gt;Apache Hive : HPL/SQL - 
EXECUTE Statement&lt;/h1&gt;
+&lt;/ul&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-statement"&gt;Apache Hive : HPL/SQL - 
EXECUTE Statement&lt;/h1&gt;
 &lt;p&gt;EXECUTE (EXEC or EXECUTE IMMEDIATE) statement executes a dynamic SQL 
statement and can return the scalar result to local variables.&lt;/p&gt;
 &lt;p&gt;You can also use this statement to call a stored procedure.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Syntax:&lt;/strong&gt;&lt;/p&gt;
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 &#39;/data/sales_&#39; || current_date 
   &#39;select * from &#39; || 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&rsquo;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 @@
 &lt;p&gt;Values:&lt;/p&gt;
 &lt;ul&gt;
 &lt;li&gt;&lt;strong&gt;exception&lt;/strong&gt; - HPL/SQL raises an exception 
when an error occurs. This is the default.&lt;/li&gt;
-&lt;li&gt;&lt;strong&gt;seterror&lt;/strong&gt; - HPL/SQL sets the error code 
to SQLCODE or HOSTCODE variables and continues execution&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;seterror&lt;/strong&gt; - HPL/SQL sets the error code 
to SQLCODE variables and continues execution&lt;/li&gt;
 &lt;li&gt;&lt;strong&gt;stop&lt;/strong&gt; - HPL/SQL stops executing the 
script and exits.&lt;/li&gt;
 &lt;/ul&gt;
 &lt;p&gt;For more information, see &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/"&gt;Error
 Handling&lt;/a&gt;.&lt;/p&gt;</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 @@
 &lt;ul&gt;
 &lt;li&gt;&lt;strong&gt;Seterror&lt;/strong&gt;&lt;/li&gt;
 &lt;/ul&gt;
-&lt;p&gt;When Seterror is specified, HPL/SQL sets the error code to SQLCODE or 
HOSTCODE variables and continues 
execution.&lt;/p&gt;</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>&lt;h1
 i [...]
+&lt;p&gt;When Seterror is specified, HPL/SQL sets the error code to SQLCODE 
variables and continues 
execution.&lt;/p&gt;</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>&lt;h1
 id="apache-hi [...]
 &lt;p&gt;HPL/SQL includes a Hive UDF 
function(&lt;em&gt;&lt;strong&gt;hplsql&lt;/strong&gt;&lt;/em&gt;) that allows 
you to execute HPL/SQL scripts (user-defined functions written in HPL/SQL 
language) in Hive queries.&lt;/p&gt;
 &lt;p&gt;For example, let&amp;rsquo;s call the following function from a Hive 
query:&lt;/p&gt;
 &lt;pre tabindex="0"&gt;&lt;code&gt;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;
 &lt;p&gt;Values:&lt;/p&gt;
 &lt;ul&gt;
 &lt;li&gt;&lt;strong&gt;exception&lt;/strong&gt; - HPL/SQL raises an exception 
when an error occurs. This is the default.&lt;/li&gt;
-&lt;li&gt;&lt;strong&gt;seterror&lt;/strong&gt; - HPL/SQL sets the error code 
to SQLCODE or HOSTCODE variables and continues execution&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;seterror&lt;/strong&gt; - HPL/SQL sets the error code 
to SQLCODE variables and continues execution&lt;/li&gt;
 &lt;li&gt;&lt;strong&gt;stop&lt;/strong&gt; - HPL/SQL stops executing the 
script and exits.&lt;/li&gt;
 &lt;/ul&gt;
-&lt;p&gt;For more information, see &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/"&gt;Error
 Handling&lt;/a&gt;.&lt;/p&gt;</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
 [...]
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;The NEW option helps you build a ETL process and download only new 
files from FTP.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY FROM FTP host [USER user [PWD 
password]] [DIR directory] [FILES files_wildcard] 
- [TO [LOCAL] target_directory] [options]
-
-options:
- OVERWRITE | NEW
- SUBDIR
- SESSIONS num 
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Notes:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---copy-from-local-statement"&gt;Apache Hive : HPL/SQL 
- COPY FROM LOCAL S [...]
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY FROM LOCAL src [, src2, ...] TO tgt 
[options]
-
-options:
- OVERWRITE
- DELETE
- IGNORE
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Notes:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;&lt;em&gt;srcN&lt;/em&gt; specifies a file or directory. If a 
directory is specified all subdirectories and their files are copied as 
well.&lt;/li&gt;
-&lt;li&gt;&lt;em&gt;srcN&lt;/em&gt; can be an expression, variable, quoted or 
unquoted string.&lt;/li&gt;
-&lt;li&gt;If a single file is copied &lt;em&gt;tgt&lt;/em&gt; must specify a 
path including the target file name.&lt;/li&gt;
-&lt;li&gt;If multiple files are copied &lt;em&gt;tgt&lt;/em&gt; must specify a 
directory.&lt;/li&gt;
-&lt;li&gt;If the target directory does not exist it is created.&lt;/li&gt;
-&lt;li&gt;OVERWRITE specifies to overwrite the target files if they 
exist.&lt;/li&gt;
-&lt;li&gt;DELETE specifies to delete the source file upon successfull 
copy.&lt;/li&gt;
-&lt;li&gt;IGNORE specifies to ignore errors when copying a file and proceed to 
copy the remaining files.&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;&lt;strong&gt;Example&lt;/strong&gt;:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---copy-statement"&gt;Apache Hive : HPL/SQL - COPY 
Statement&lt;/h1&gt;
-&lt;p&gt;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.&lt;/p&gt;
-&lt;p&gt;When you copy data between tables they can be located in different 
databases.&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;p&gt;Export data to a file:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;COPY table_name | (select_stmt) TO [HDFS] 
file_name [options]
-
-options:
- DELIMITER &amp;#39;char&amp;#39;
-| SQLINSERT target_table_name
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;Copy data between existing 
tables:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---create-database-statement"&gt;Apache Hive : [...]
+&lt;p&gt;For more information, see &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/"&gt;Error
 Handling&lt;/a&gt;.&lt;/p&gt;</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
 [...]
 &lt;p&gt;CREATE DATABASE statement allows you to create a database.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
 &lt;pre tabindex="0"&gt;&lt;code&gt;CREATE DATABASE | SCHEMA [IF NOT EXISTS] 
dbname_expr
@@ -959,7 +918,7 @@ value string default
 &lt;ul&gt;
 &lt;li&gt;&lt;strong&gt;Seterror&lt;/strong&gt;&lt;/li&gt;
 &lt;/ul&gt;
-&lt;p&gt;When Seterror is specified, HPL/SQL sets the error code to SQLCODE or 
HOSTCODE variables and continues 
execution.&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql--- [...]
+&lt;p&gt;When Seterror is specified, HPL/SQL sets the error code to SQLCODE 
variables and continues 
execution.&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---exceptions"& [...]
 &lt;p&gt;HPL/SQL allows you to handle exceptions in your programs.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Syntax:&lt;/strong&gt;&lt;/p&gt;
 &lt;pre tabindex="0"&gt;&lt;code&gt;BEGIN
@@ -981,42 +940,7 @@ BEGIN
 EXCEPTION WHEN OTHERS THEN
  DBMS_OUTPUT.PUT_LINE(&amp;#39;Error&amp;#39;);
 END
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Compatibility&lt;/strong&gt;: 
Oracle, PostgreSQL and 
Netezza.&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-os- [...]
-&lt;p&gt;HPL/SQL allows you to execute an OS command or external process from 
a HPL/SQL script:&lt;/p&gt;
-&lt;p&gt;&lt;strong&gt;Syntax&lt;/strong&gt;:&lt;/p&gt;
-&lt;p&gt;! command:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;!cmd [arguments];
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;HOST statement:&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;HOST string_expr
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Parameters:&lt;/strong&gt;&lt;/p&gt;
-&lt;table&gt;
- &lt;thead&gt;
- &lt;tr&gt;
- &lt;th&gt;&lt;strong&gt;Parameter&lt;/strong&gt;&lt;/th&gt;
- &lt;th&gt;&lt;strong&gt;Description&lt;/strong&gt;&lt;/th&gt;
- &lt;/tr&gt;
- &lt;/thead&gt;
- &lt;tbody&gt;
- &lt;tr&gt;
- &lt;td&gt;cmd&lt;/td&gt;
- &lt;td&gt;Any OS command or process&lt;/td&gt;
- &lt;/tr&gt;
- &lt;tr&gt;
- &lt;td&gt;arguments&lt;/td&gt;
- &lt;td&gt;Optional argument list&lt;/td&gt;
- &lt;/tr&gt;
- &lt;tr&gt;
- &lt;td&gt;string_expr&lt;/td&gt;
- &lt;td&gt;Command line for HOST statement&lt;/td&gt;
- &lt;/tr&gt;
- &lt;/tbody&gt;
-&lt;/table&gt;
-&lt;p&gt;&lt;strong&gt;Notes&lt;/strong&gt;:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;Blank characters are allowed between ! and cmd&lt;/li&gt;
-&lt;li&gt;The ! command must be terminated by a semicolon (;)&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;&lt;strong&gt;Example:&lt;/strong&gt;&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-statement"&gt;Apache Hive : HPL/SQL - 
EXECUTE Statement&lt;/h1&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Compatibility&lt;/strong&gt;: 
Oracle, PostgreSQL and 
Netezza.&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---execute-statement"&gt;Apac [...]
 &lt;p&gt;EXECUTE (EXEC or EXECUTE IMMEDIATE) statement executes a dynamic SQL 
statement and can return the scalar result to local variables.&lt;/p&gt;
 &lt;p&gt;You can also use this statement to call a stored procedure.&lt;/p&gt;
 &lt;p&gt;&lt;strong&gt;Syntax:&lt;/strong&gt;&lt;/p&gt;
@@ -1199,20 +1123,7 @@ BEGIN
  RETURN &amp;#39;Hello, &amp;#39; || text || &amp;#39;!&amp;#39;;
 END;
 &lt;/code&gt;&lt;/pre&gt;&lt;h2 
id="running-hplsql-scripts-from-beeline-in-non-hplsql-mode"&gt;Running HPL/SQL 
scripts from Beeline in non-hplsql mode&lt;/h2&gt;
-&lt;p&gt;Now let&amp;rsquo;s use &lt;em&gt;hello&lt;/em&gt; function written 
in HPL/SQL language in Hive 
query:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---hostcode"&gt;Ap [...]
-&lt;p&gt;HOSTCODE built-in variable contains the return code of the last OS 
command.&lt;/p&gt;
-&lt;pre tabindex="0"&gt;&lt;code&gt;SET hplsql.onerror = SETERROR;
-
-HOST &amp;#39;echo hello, world&amp;#39;;
-IF HOSTCODE &amp;lt;&amp;gt; 0 THEN
- PRINT &amp;#39;Error&amp;#39;;
-END IF;
-&lt;/code&gt;&lt;/pre&gt;&lt;p&gt;&lt;strong&gt;Notes&lt;/strong&gt;:&lt;/p&gt;
-&lt;ul&gt;
-&lt;li&gt;Typically HOSTCODE is 0 when the process terminated successfully, 
and 1 if it terminated with an error.&lt;/li&gt;
-&lt;li&gt;By default &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/configuration/#hplsqlonerror"&gt;hplsql.onerror&lt;/a&gt;
 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.&lt;/li&gt;
-&lt;/ul&gt;
-&lt;p&gt;For more information, see &lt;a 
href="https://hive.apache.org/docs/latest/language/hplsql/user-guide/error-handling/"&gt;Error
 Handling&lt;/a&gt;.&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hpls [...]
+&lt;p&gt;Now let&amp;rsquo;s use &lt;em&gt;hello&lt;/em&gt; function written 
in HPL/SQL language in Hive 
query:&lt;/p&gt;</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>&lt;h1
 id="apache-hive--hplsql---if-statement"&gt;Apache Hive : HPL/SQL  [...]
 &lt;p&gt;IF statement executes a set of statements depending on the value of a 
boolean expression.&lt;/p&gt;
 &lt;p&gt;HPL/SQL supports multiple syntaxes for IF statement.&lt;/p&gt;
 &lt;h2 id="if---then---elsifelseif---else---end-if"&gt;IF - THEN - 
ELSIF/ELSEIF - ELSE - END IF&lt;/h2&gt;
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

Reply via email to