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 932bffc8 deploy: 6894bbea20184f6b9fd4458d7906bb8676380dea
932bffc8 is described below
commit 932bffc8524904845218c0abb017529b2d5b191c
Author: zabetak <[email protected]>
AuthorDate: Fri Nov 20 10:02:53 2026 +0000
deploy: 6894bbea20184f6b9fd4458d7906bb8676380dea
---
docs/latest/language/hplsql/index.html | 2 +-
docs/latest/language/hplsql/new.md.bak | 222 ---------------------
docs/latest/language/hplsql/troubleshooting.md.bak | 12 --
docs/latest/language/hplsql/user-guide/cli.md.bak | 71 -------
.../language/hplsql/user-guide/connections.md.bak | 99 ---------
docs/latest/language/hplsql/user-guide/hive.md.bak | 41 ----
.../hplsql/user-guide/multiple-databases.md.bak | 48 -----
7 files changed, 1 insertion(+), 494 deletions(-)
diff --git a/docs/latest/language/hplsql/index.html
b/docs/latest/language/hplsql/index.html
index 90a9f3f2..3b30e0b8 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/new.md.bak
b/docs/latest/language/hplsql/new.md.bak
deleted file mode 100644
index 6ebb420b..00000000
--- a/docs/latest/language/hplsql/new.md.bak
+++ /dev/null
@@ -1,222 +0,0 @@
----
-title: "Apache Hive : What's New"
-date: 2026-08-12
----
-
-# Apache Hive : What's New
-
-New HPL/SQL features:
-
-## HPL/SQL 0.3.17 - March 28, 2016
-
-- [COPY FROM FTP]({{< ref "copy-from-ftp" >}}) statement
-- [CREATE DATABASE]({{< ref "create-database" >}}) statement
-- [DROP DATABASE]({{< ref "drop-database" >}}) statement
-- [TRUNCATE]({{< ref "truncate" >}}) statement
-- [DESCRIBE]({{< ref "describe" >}}) statement
-- [INSERT DIRECTORY]({{< ref "insert-directory" >}}) statement
-- [REPLACE]({{< ref "replace" >}}) function
-- [NOW]({{< ref "now" >}}) function
-- [UNIX_TIMESTAMP]({{< ref "unix-timestamp" >}}) function
-- [FROM_UNIXTIME]({{< ref "from-unixtime" >}}) function
-- [+ Operator]({{< ref "plus#concatenate_two_strings" >}}) to concatenate two
strings
-- [INT(n) to INT]({{< ref "data-types#data_type_conversion" >}}) data type
conversion (MySQL compatibility)
-- [TEXT to STRING]({{< ref "data-types#data_type_conversion" >}}) data type
conversion (MySQL compatibility)
-- [INT2 to SMALLINT]({{< ref "data-types#data_type_conversion" >}}) data type
conversion (PostgreSQL compatibility)
-- [INT4 to INT]({{< ref "data-types#data_type_conversion" >}}) data type
conversion (PostgreSQL compatibility)
-- [INT8 to BIGINT]({{< ref "data-types#data_type_conversion" >}}) data type
conversion (PostgreSQL compatibility)
-- [INTERVAL]({{< ref "interval" >}}) keyword in interval expressions
-- AUTO_INCREMENT, ENGINE, CHARSET, COMMENT clauses parser (MySQL compatibility)
-- BEGIN TRANSACTION and END TRANSACTION statements parser (Teradata
compatibility)
-- ALTER TABLE ADD CONSTRAINT parser
-- WHERE clause in UPDATE clause of MERGE statement (Parser fix)
-- Allow expressions in PARTITION BY clause of window functions (Parser fix)
-- SET QUERY_BAND statement parser (Teradata compatibility)
-- ENABLE constraint keyword parser (Oracle compatibility)
-- Removing [dbo] schema when executing SQL (Microsoft SQL Server compatibility)
-- By default, not adding FROM [hplsql.dual.table]({{< ref
"configuration#hplsqldualtable" >}}) to SELECT without FROM
-- INNER keyword is optional in join (Parser fix)
-- RAISE statement (Parser fix)
-- Variable declaration block in procedures and functions (Bug fix)
-- Subtraction ('-') operator (Bug fix)
-- Multiplication ('*') and division ('/') operators in SQL statements (Bug fix)
-- OVERWRITE keyword missed in INSERT statements (Bug fix)
-- PL/SQL-style stored procedure without parameters (Bug fix)
-- FOR cursor columns values (Bug fix)
-- EXCEPTION block in functions (Bug fix)
-## HPL/SQL 0.3.13 - October 30, 2015
-
-- [CREATE PACKAGE]({{< ref "create-package" >}}) statement
-- [%TYPE]({{< ref "type-attribute" >}}) attribute
-- [%ROWTYPE]({{< ref "rowtype-attribute" >}}) attribute
-- [PART_COUNT]({{< ref "part-count" >}}) function
-- [PART_COUNT_BY]({{< ref "part-count-by" >}}) function
-- [PLS_INTEGER]({{< ref "data-types" >}}), [BINARY_INTEGER]({{< ref
"data-types" >}}) and [SIMPLE_INTEGER]({{< ref "data-types" >}}) data types
-- [REAL]({{< ref "data-types" >}}), [FLOAT]({{< ref "data-types" >}}) and
[DOUBLE]({{< ref "data-types" >}}) data types
-- [BINARY_FLOAT]({{< ref "data-types" >}}) and [BINARY_DOUBLE]({{< ref
"data-types" >}}) data types
-- [SIMPLE_FLOAT]({{< ref "data-types" >}}) and [SIMPLE_DOUBLE]({{< ref
"data-types" >}}) data types
-- [BOOL]({{< ref "data-types" >}}) and [BOOLEAN]({{< ref "data-types" >}})
data types
-- [CMP]({{< ref "cmp" >}}) statement to compare data in tables
-- [COPY TO HDFS]({{< ref "copy" >}}) statement to copy JDBC query results to
HDFS
-- [NULL]({{< ref "null" >}}) statement (no operation)
-- TRUE and FALSE boolean literals
-- CONSTANT declarations
-- Support expressions in [INCLUDE]({{< ref "include" >}}) statement
-- BYTE and CHAR column length semantics (Parser)
-- FOREIGN KEY and UNIQUE constraint in CREATE TABLE (Parser)
-- Oracle storage clause in CREATE TABLE (Parser)
-- NOT NULL constraint in variable declaration (Parser)
-- XML data type (Parser)
-- Calling stored procedures without parameters (Bug fix)
-- AS alias in SELECT list (Bug fix)
-- Subselect in FROM clause (Bug fix)
-- Multiplication * and division / operators for integers (Bug fix)
-- NOT boolean expression (Bug fix)
-- Invoke built-in functions in lower case (Bug fix)
-- Compare DECIMAL values, DECIMAL and integer values (Bug fix)
-- NUMBER data type (Bug fix)
-- Variable scope when calling functions or procedures (Bug fix)
-- Using parameters in JDBC connection URL to specify advanced options such as
Kerberos authentication (Bug fix)
-## HPL/SQL 0.3.11 - July 30, 2015
-
-- [SYS_REFCURSOR]({{< ref "data-types" >}}) cursor variable
-- [%ISOPEN, %FOUND and %NOTFOUND]({{< ref "cursor-attributes" >}}) cursor
attributes
-- Named parameters in procedure call
-- SELECT @var = col, ... FROM assignment syntax
-- [ALLOCATE CURSOR]({{< ref "allocate-cursor" >}}) statement
-- [ASSOCIATE RESULT SET LOCATOR]({{< ref "associate-locator" >}}) statement
-- [SET CURRENT SCHEMA]({{< ref "set-session#current-schema" >}}) statement
-- [CURRENT_USER]({{< ref "current-user" >}}) function
-- [CURRENT USER]({{< ref "current-user" >}}) function
-- [INSTR]({{< ref "instr" >}}) function
-- [SUBSTRING(str FROM start FOR len)]({{< ref "substring" >}}) function
-- [USER]({{< ref "functions/user.md" >}}) function
-- [VARCHAR(MAX) to STRING]({{< ref "data-types#data-type-conversion" >}}) data
type conversion
-- [DATETIME and SMALLDATETIME to TIMESTAMP]({{< ref
"data-types#data-type-conversion" >}}) data type conversion
-- [NUMERIC to DECIMAL]({{< ref "data-types#data-type-conversion" >}}) data
type conversion
-- [NCHAR and NVARCHAR to STRING]({{< ref "data-types#data-type-conversion"
>}}) data type conversion
-- [BIT to TINYINT]({{< ref "data-types#data-type-conversion" >}}) data type
conversion
-- [Identifier]({{< ref "conversion#language-elements-and-operators" >}})
conversion ("" and [] to ``)
-- UPDATE ELSE INSERT statement parser (UPSERT)
-- LIKE, RLIKE and REGEXP parser
-- CUME_DIST function parser
-- CHARACTER SET data type attribute
-- CASESPECIFIC data type attribute
-- DYNAMIC RESULT SETS clause parser in CREATE PROCEDURE
-- TITLE 'alias' clause parser in SELECT
-- WITH RETURN TO CALLER/CLIENT clause parser in DECLARE CURSOR
-- IDENTITY clause parser
-- SET ANSI_NULLS, ANSI_PADDING, NOCOUNT, QUOTED_IDENTIFIER and XACT_ABORT
parser
-- OPEN cursor FOR SELECT (Bug fix)
-- SELECT INTO a DECIMAL, BIGINT, SMALLINT or TINYINT variable (Bug fix)
-- NULL in +/- operations (Bug fix)
-- Initialize missing parameters to NULL in -main procedure call (Bug fix)
-- Calling stored procedure without parameters (Bug fix)
-- Do not throw NOT FOUND exception in FETCH statement (Bug fix)
-- Division operator for integer values (Bug fix)
-- Assign an integer value to decimal variable (Bug fix)
-- Catch exceptions thrown during expression evaluation (Bug fix)
-## HPL/SQL 0.3.7 - May 19, 2015
-
-- [COPY]({{< ref "copy" >}}) statement
-- [COPY FROM LOCAL]({{< ref "copy-from-local" >}}) statement
-- [SET v = (SELECT c FROM ...)]({{< ref
"assign#assignment-from-a-select-statement" >}}) assignment
-- [hplsql.conn.db2conn]({{< ref "configuration#hplsqlconndb2conn" >}}) option
-- [hplsql.conn.tdconn]({{< ref "configuration#hplsqlconntdconn" >}}) option
-- DATE data type
-- TIMESTAMP data type
-- CURRENT_DATE, CURRENT DATE to TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP()))
conversion in executable SQL for Hive
-- CURRENT_TIMESTAMP, CURRENT TIMESTAMP to FROM_UNIXTIME(UNIX_TIMESTAMP())
conversion in executable SQL for Hive
-- TOP *n* to LIMIT *n* conversion in SELECT statement for Hive
-- LIMIT clause in SELECT
-- UPDATE statement parser
-- DELETE statement parser
-- MERGE statement parser
-- Common table expression (CTE) parser
-- ROW FORMAT DELIMITED, FIELDS TERMINATED, LINES TERMINATED clauses for Hive
-- Default values parser in procedure parameters
-- LANGUAGE SQL clause in CREATE PROCEDURE
-- SQL SECURITY clause in CREATE PROCEDURE
-- Procedure label in CREATE PROCEDURE
-- WITH UR, RR, RS, CS clause in SELECT
-- CREATE INDEX parser
-- GRANT EXECUTE ON PROCEDURE parser
-- #, @ and / characters can be used as the statement terminators
-- CASE expressions in SQL statements (Bug fix)
-- BETWEEN clause in boolean expressions and SQL statements (Bug fix)
-- IS NOT NULL clause in boolean expressions and SQL statements (Bug fix)
-- NOT IN clause in SQL statements (Bug fix)
-- GROUP BY parser (Bug fix)
-- ORDER BY parser (Bug fix)
-- Windows-style file path parser (Bug fix)
-## HPL/SQL 0.3.1 - April 30, 2015
-
-- [Hive UDF]({{< ref "udf" >}}) to run HPL/SQL scripts from Hive CLI queries
-- Automatically put functions referenced in Hive queries to Distributed Cache,
register [UDF]({{< ref "udf" >}}) and modify SQL statements
-- [Multiple connections]({{< ref "connections" >}}) to different systems from
a single script
-- [ACTIVITY_COUNT]({{< ref "activity_count" >}}) built-in variable
-- [CONCAT]({{< ref "concat" >}}) function
-- [DECODE]({{< ref "decode" >}}) function
-- [TO_CHAR]({{< ref "to-char" >}}) function
-- [TO_TIMESTAMP]({{< ref "to-timestamp" >}}) function
-- [CALL]({{< ref "call" >}}) statement
-- [CREATE FUNCTION]({{< ref "create-function" >}}) statement
-- [CREATE LOCAL TEMPORARY TABLE]({{< ref "create-local-temporary-table" >}})
statement
-- [CREATE PROCEDURE]({{< ref "create-procedure" >}}) statement
-- [CREATE VOLATILE TABLE]({{< ref "create-volatile-table" >}}) statement
-- [DECLARE CONDITION]({{< ref "declare-condition" >}}) statement
-- [DECLARE HANDLER]({{< ref "declare-handler" >}}) statement - user-defined
condition
-- [INCLUDE]({{< ref "include" >}}) statement
-- [MAP OBJECT]({{< ref "map-object" >}}) statement
-- [SIGNAL]({{< ref "signal" >}}) statement
-- [.hplsqlrc]({{< ref "configuration##hplsqlrc-file" >}}) configuration file
-- [|| operator to CONCAT]({{< ref "twopipes" >}}) function conversion in SQL
queries
-- Parser for column list in [INSERT]({{< ref "insert" >}}) statement
-- [hplsql.conn.hiveconn]({{< ref "configuration#hplsqlconnhiveconn" >}}) option
-- [hplsql.conn.init.hiveconn]({{< ref "configuration#hplsqlconninithiveconn"
>}}) option
-- [hplsql.conn.convert.hiveconn]({{< ref
"configuration#hplsqlconnconverthiveconn" >}}) option
-- [hplsql.conn.hive2conn]({{< ref "configuration#hplsqlconnhive2conn" >}})
option
-- [hplsql.conn.init.hive2conn]({{< ref "configuration#hplsqlconninithive2conn"
>}}) option
-- [hplsql.conn.convert.hive2conn]({{< ref
"configuration#hplsqlconnconverthive2conn" >}}) option
-- [hplsql.conn.<connection_profile>]({{< ref
"configuration#hplsqlconn-connection_profile" >}}) option
-- [hplsql.conn.init.<connection_profile>]({{< ref
"configuration#hplsqlconninit-connection_profile" >}}) option
-- [hplsql.conn.mysqlconn]({{< ref "configuration#hplsqlconnmysqlconn" >}})
option
-- [SET]({{< ref "assign" >}}) statement - assigning NULL to a variable (Bug
fix)
-- Boolean expressions and predicates (Bug fix)
-## HPL/SQL 0.3 - March 31, 2015
-
-- [TIMESTAMP]({{< ref "timestamp-literal" >}}) literal
-- [INTERVAL]({{< ref "interval" >}}) expressions
-- [SQLSTATE]({{< ref "sqlstate" >}}) built-in variable
-- [CAST]({{< ref "cast" >}}) function
-- [CHAR]({{< ref "char" >}}) function
-- [COALESCE]({{< ref "coalesce" >}}) function
-- [CURRENT_TIMESTAMP]({{< ref "current-timestamp" >}}) function
-- [DATE]({{< ref "date" >}}) function
-- [LEN]({{< ref "len" >}}) function
-- [LENGTH]({{< ref "length" >}}) function
-- [LOWER]({{< ref "lower" >}}) function
-- [SYSDATE]({{< ref "sysdate" >}}) function
-- [TIMESTAMP_ISO]({{< ref "timestamp-iso" >}}) function
-- [TRIM]({{< ref "trim" >}}) function
-- [UPPER]({{< ref "upper" >}}) function
-- [CREATE TABLE]({{< ref "create-table" >}}) statement
-- [DECLARE TEMPORARY TABLE]({{< ref "declare-temporary-table" >}}) statement
-- [DROP TABLE]({{< ref "drop-table" >}}) statement
-- [FOR cursor]({{< ref "for-cursor" >}}) statement
-- [FROM TABLE (VALUES ...)]({{< ref "select" >}}) in SELECT statement
-- [INSERT]({{< ref "insert" >}}) statement
-- [GET DIAGNOSTICS EXCEPTION]({{< ref "get-diagnostics" >}}) statement
-- [RESIGNAL]({{< ref "resignal" >}}) statement
-- [VALUES INTO]({{< ref "values-into" >}}) statement
-- [hplsql.conn.convert.default]({{< ref
"configuration#hplsqlconnconvertdefault" >}}) option
-- [hplsql.dual.table]({{< ref "configuration#hplsqldualtable" >}}) option
-- [hplsql.insert.values]({{< ref "configuration#hplsqlinsertvalues" >}}) option
-- [hplsql.temp.tables]({{< ref "configuration#hplsqltemptables" >}}) option
-- [hplsql.temp.tables.schema]({{< ref "configuration#hplsqltemptablesschema"
>}}) option
-- [hplsql.temp.tables.location]({{< ref
"configuration#hplsqltemptableslocation" >}}) option
-- [VARCHAR2 to STRING]({{< ref "data-types#data-type-conversion" >}})
conversion in CREATE TABLE
-- [NUMBER to DECIMAL]({{< ref "data-types#data-type-conversion" >}})
conversion in CREATE TABLE
-## HPL/SQL 0.1 - February 27, 2015
-
-- Initial release
diff --git a/docs/latest/language/hplsql/troubleshooting.md.bak
b/docs/latest/language/hplsql/troubleshooting.md.bak
deleted file mode 100644
index 2dee3e30..00000000
--- a/docs/latest/language/hplsql/troubleshooting.md.bak
+++ /dev/null
@@ -1,12 +0,0 @@
----
-title: "Apache Hive : HPL/SQL Troubleshooting"
-date: 2026-08-12
----
-
-# Apache Hive : HPL/SQL Troubleshooting
-
-HPL/SQL troubleshooting.
-
-## java.sql.SQLException: Error while processing statement: FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
-
-The tool can connect to HiveServer2 but cannot launch a Map Reduce task most
likely due to security issues. Check your user permissions.
diff --git a/docs/latest/language/hplsql/user-guide/cli.md.bak
b/docs/latest/language/hplsql/user-guide/cli.md.bak
deleted file mode 100644
index e3ec7f4f..00000000
--- a/docs/latest/language/hplsql/user-guide/cli.md.bak
+++ /dev/null
@@ -1,71 +0,0 @@
----
-title: "Apache Hive : HPL/SQL Command Line"
-date: 2026-08-12
----
-
-# Apache Hive : HPL/SQL Command Line
-
-You can run *hplsql* tool from a command line to execute a SQL statement or
HQL script.
-
-**Syntax**:
-
-```
-hplsql -e 'query' | -f file
- [-main procname]
- [-d | --define | -hiveconf | -hivevar var=value ...]
- [-version | --version]
- [-trace | --trace]
- [-H | --help]
-```
-
-**Parameters:**
-
-| Parameter | Description | HPL/SQL Version |
-| --- | --- | --- |
-| -e 'query' | SQL statements to execute | 0.1 |
-| -f file | Execute SQL statements from *file* | 0.1 |
-| -main procname | Entry point (procedure or function name) | 0.3.7 |
-| -d var=value | Variable definition | 0.1 |
-| --define var=value | Variable definition | 0.1 |
-| -hiveconf var=value | Variable definition | 0.1 |
-| -hivevar var=value | Variable definition | 0.1 |
-| -version, --version | Print HPL/SQL version | 0.1 |
-| -trace, --trace | Print trace information | 0.1 |
-| -H, --help | Print help information and exit | 0.1 |
-
-**Notes**:
-
-- -e and -f cannot be specified together
-- if -main option is not specified, HPL/SQL start executing all statements
from the beginning of the script
-- You can use single 'query' and double "query" quotes with -e option
-- Currently -d, --define, -hivevar and -hiveconf are equivalent and allow you
to define input variables.
-
-**Example 1:**
-
-Executing HPL/SQL statements from a script:
-
-```
-hplsql -f script.hql
-```
-
-**Example 2:**
-
-Executing HPL/SQL statements from command line:
-
-```
-hplsql -e "NVL(MAX_PARTITION_DATE(db.sales, local_dt, code='A'),
CURRENT_DATE)"
-```
-
-**Example 3:**
-
-Using variables:
-
-```
-hplsql -e "PRINT a || ', ' || b" -d a=Hello -d b=world
-```
-
-Result:
-
-```
-Hello, world
-```
diff --git a/docs/latest/language/hplsql/user-guide/connections.md.bak
b/docs/latest/language/hplsql/user-guide/connections.md.bak
deleted file mode 100644
index da88cfd5..00000000
--- a/docs/latest/language/hplsql/user-guide/connections.md.bak
+++ /dev/null
@@ -1,99 +0,0 @@
----
-title: "Apache Hive : Connections - HPL/SQL Reference"
-date: 2026-08-12
----
-
-# Apache Hive : Connections - HPL/SQL Reference
-
-HPL/SQL allows you to [work with multiple databases]({{< ref
"multiple-databases" >}}) in a single HPL/SQL script.
-
-## Configuring Connections
-
-Connection information is stored in [plhql-site.xml]({{< ref "configuration"
>}}) configuration file. The default connection profile is defined by
[plhql.conn.default]({{< ref "configuration#plhqlconndefault" >}}) option:
-
-```
-<property>
- <name>plhql.conn.default</name>
- <value>hiveconn</value>
-</property>
-```
-
-## Predefined Connections
-
-[plhql-site.xml]({{< ref "configuration" >}}) contains predefined connections
for some databases:
-
-- **hiveconn** - Embedded Hive JDBC Connection (not requiring a HiveServer)
-
-```
-<property>
- <name>plhql.conn.hiveconn</name>
- <value>org.apache.hadoop.hive.jdbc.HiveDriver;jdbc:hive://</value>
-</property>
-```
-
-- **hive2conn** - HiveServer2 JDBC Connection
-
-```
-<property>
- <name>plhql.conn.hive2conn</name>
- <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://localhost:10000</value>
-</property>
-```
-
-- **db2conn** - IBM DB2 JDBC Connection
-
-```
-<property>
- <name>plhql.conn.db2conn</name>
-
<value>com.ibm.db2.jcc.DB2Driver;jdbc:db2://localhost:50001/dbname;user;pwd</value>
- <description>IBM DB2 connection</description>
-</property>
-```
-
-When using DB2 JDBC driver make sure *db2jcc4.jar* is specified in CLASSPATH.
-
-- **tdconn** - Teradata JDBC Connection
-
-```
-<property>
- <name>plhql.conn.tdconn</name>
- <value>
-
com.teradata.jdbc.TeraDriver;jdbc:teradata://host/database=name,logmech=ldap;usr;pwd
- </value>
-</property>
-```
-
-When using Teradata JDBC driver make sure *teradata-jdbc4-xx.xx.xx.jar*and
*tdgssconfig.jar* (both .jars required) are specified in CLASSPATH.
-
-- **mysqlconn** - MySQL JDBC Connection
-
-```
-<property>
- <name>plhql.conn.mysqlconn</name>
-
<value>com.mysql.jdbc.Driver;jdbc:mysql://localhost/test;user;password</value>
-</property>
-```
-
-When using MySQL JDBC driver make sure *mysql-connector-java-x.x.xx-bin.jar*
is specified in CLASSPATH.
-
-You can modify these connection profiles and specify appropriate connection
details. Set the default connection profile using the [plhql.conn.default]({{<
ref "configuration#plhqlconndefault" >}}) option.
-## Defining a New Connection
-
-PL/HQL allows you to define any connection profile. Just create a new
parameter named *plhql.conn.<your_connection_name>* and specify the connection
details:
-
-```
-<value>JDBC Driver;JDBC Connection String;User;Password</value>
-```
-
-For example, to create a new connection *sales* that points to the *sales_db*
database in MySQL add the following section to your [plhql-site.xml]({{< ref
"configuration" >}}) file:
-
-```
-<property>
- <name>plhql.conn.sales</name>
- <value>com.mysql.jdbc.Driver;jdbc:mysql://localhost/sales_db;paul;pwd</value>
-</property>
-```
-
-Read your JDBC driver documentation how to properly specify the connection
string and available options.
-
-Once you configured the connections, read how to [use them in PL/HQL
scripts]({{< ref "multiple-databases" >}}).
diff --git a/docs/latest/language/hplsql/user-guide/hive.md.bak
b/docs/latest/language/hplsql/user-guide/hive.md.bak
deleted file mode 100644
index 78ffb061..00000000
--- a/docs/latest/language/hplsql/user-guide/hive.md.bak
+++ /dev/null
@@ -1,41 +0,0 @@
----
-title: "Apache Hive : Invoke Hive CLI - PL/HQL Reference"
-date: 2026-08-12
----
-
-# Apache Hive : Invoke Hive CLI - PL/HQL Reference
-
-*hive* allows you to invoke Hive CLI (command line tool) to execute a SQL
statement or HQL script.
-
-**Syntax**:
-
-```
-hive -e 'query' | -f file [-hiveconf var=expr ...]
-```
-
-**Parameters:**
-
-| **Parameter** | **Description** |
-| --- | --- |
-| -e 'query' | SQL statements to execute |
-| -f file | Execute SQL statements from *file* |
-| -hiveconf var=expr | Hive variables |
-
-**Notes**:
-
-- -e and -f cannot be specified together
-- Using -hiveconf you can specify a value from an expression
-
-**Example 1:**
-
-```
-hive -f script.hql -hiveconf cr_date=NVL(var, '1970-01-01')
-```
-
-**Example 2:**
-
-```
-hive -e 'SELECT ' || cols || ' FROM ' || table || ' LIMIT 3'
-```
-
-**Compatibility**: Apache Hive.
diff --git a/docs/latest/language/hplsql/user-guide/multiple-databases.md.bak
b/docs/latest/language/hplsql/user-guide/multiple-databases.md.bak
deleted file mode 100644
index 24a62509..00000000
--- a/docs/latest/language/hplsql/user-guide/multiple-databases.md.bak
+++ /dev/null
@@ -1,48 +0,0 @@
----
-title: "Apache Hive : Working with Multiple Databases in HPL/SQL"
-date: 2026-08-12
----
-
-# Apache Hive : Working with Multiple Databases in HPL/SQL
-
-HPL/SQL allows you to access multiple databases simultaneously from a single
HPL/SQL script.
-
-## Why Multiple Databases?
-
-Hadoop extends, not replaces a traditional data warehouse, so you have to work
with different systems for different type of workloads.
-
-Most SQL-on-Hadoop solutions are good for querying large volumes of data
rather than transaction processing. Note that even Hive stores its own metadata
is a separate database (MySQL, PostgreSQL, Oracle etc.).
-
-When you use Hive or other SQL-on-Hadoop tool to query your data, you can use
a RDBMS or NoSQL to:
-
-- Write log and audit records
-- Access look-up or dimension tables
-- Read and write configuration parameters
-- Save query results and so on.
-
-## Configuring and Using Connections
-
-Before you can work with multiple databases, you have to [configure
connections]({{< ref "connections" >}}).
-
-HPL/SQL connects to a database only when it executes the first SQL statement
for this database, the tool does not connect to any database in advance.
-
-Once connected, HPL/SQL holds and re-uses the connection until the script
completes.
-
-## Default Connection
-
-By default, HPL/SQL uses the connection profile defined by the
[hplsql.conn.default]({{< ref "configuration#hplsqlconndefault" >}}) option.
-
-## Map Database Objects to Use Other Connections
-
-Once you configured multiple connection profiles you can use [MAP OBJECT]({{<
ref "map-object" >}}) statement to map a table or view to the specified
connection. Then when accessing in SQL statements HPL/SQL will use appropriate
connection for the object:
-
-For example, you can run SELECT in Hive, but log messages to MySQL:
-
-```
-MAP OBJECT log TO log.log_data AT mysqlconn;
-
-DECLARE cnt INT;
-SELECT count(*) INTO cnt FROM sales.users WHERE local_dt = CURRENT_DATE;
-
-INSERT INTO log (message) VALUES ('Number of users: ' || cnt);
-```