This is an automated email from the ASF dual-hosted git repository.

zabetak pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/hive-site.git


The following commit(s) were added to refs/heads/main by this push:
     new 6894bbea Remove commented out HPL/SQL documentation (#127)
6894bbea is described below

commit 6894bbea20184f6b9fd4458d7906bb8676380dea
Author: Thomas Rebele <[email protected]>
AuthorDate: Fri Nov 20 11:00:14 2026 +0100

    Remove commented out HPL/SQL documentation (#127)
---
 content/docs/latest/language/hplsql/_index.md      |   8 -
 content/docs/latest/language/hplsql/new.md.bak     | 222 ------------------
 .../latest/language/hplsql/troubleshooting.md.bak  |  12 -
 .../latest/language/hplsql/user-guide/cli.md.bak   |  71 ------
 .../language/hplsql/user-guide/configuration.md    | 258 +--------------------
 .../language/hplsql/user-guide/connections.md.bak  |  99 --------
 .../language/hplsql/user-guide/conversion.md       |   2 -
 .../latest/language/hplsql/user-guide/hive.md.bak  |  41 ----
 .../hplsql/user-guide/multiple-databases.md.bak    |  48 ----
 .../latest/language/hplsql/user-guide/udf-sproc.md |  26 +--
 10 files changed, 2 insertions(+), 785 deletions(-)

diff --git a/content/docs/latest/language/hplsql/_index.md 
b/content/docs/latest/language/hplsql/_index.md
index aad25f5d..b412ed5d 100644
--- a/content/docs/latest/language/hplsql/_index.md
+++ b/content/docs/latest/language/hplsql/_index.md
@@ -22,14 +22,10 @@ Initially it was provided as a stand alone command line 
tool. As a part of ([HIV
 - [Why HPL/SQL]({{< ref "why" >}})
 - [Key Features]({{< ref "features" >}})
 - [Get Started]({{< ref "start" >}})
-<!-- - [What's New]({{< ref "new" >}}) -->
 
 ## User Guide
 
-<!-- - [Command Line]({{< ref "cli" >}}) -->
 - [Configuration]({{< ref "configuration" >}})
-<!-- - [Connections]({{< ref "connections" >}}) -->
-<!-- - [Working with Multiple Databases]({{< ref "multiple-databases" >}}) -->
 - [User-Defined Functions and Stored Procedures]({{< ref "udf-sproc" >}})
 - [On-the-Fly SQL Conversion]({{< ref "conversion" >}})
 - [UDF to Run HPL/SQL Scripts from Hive Queries]({{< ref "udf" >}})
@@ -167,10 +163,6 @@ Initially it was provided as a stand alone command line 
tool. As a part of ([HIV
 
 - [UTL_FILE Package]({{< ref "utl-file" >}})
 
-<!-- ## Troubleshooting
-
-- [Troubleshooting]({{< ref "troubleshooting" >}}) -->
-
 ## Compatibility
 
 - [Oracle PL/SQL]({{< ref "plsql" >}})
diff --git a/content/docs/latest/language/hplsql/new.md.bak 
b/content/docs/latest/language/hplsql/new.md.bak
deleted file mode 100644
index 6ebb420b..00000000
--- a/content/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/content/docs/latest/language/hplsql/troubleshooting.md.bak 
b/content/docs/latest/language/hplsql/troubleshooting.md.bak
deleted file mode 100644
index 2dee3e30..00000000
--- a/content/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/content/docs/latest/language/hplsql/user-guide/cli.md.bak 
b/content/docs/latest/language/hplsql/user-guide/cli.md.bak
deleted file mode 100644
index e3ec7f4f..00000000
--- a/content/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/content/docs/latest/language/hplsql/user-guide/configuration.md 
b/content/docs/latest/language/hplsql/user-guide/configuration.md
index fcc1c634..e564685f 100644
--- a/content/docs/latest/language/hplsql/user-guide/configuration.md
+++ b/content/docs/latest/language/hplsql/user-guide/configuration.md
@@ -7,263 +7,7 @@ date: 2026-08-12
 
 You can set all options dynamically using the [SET]({{< ref "assign" >}}) 
statement in a HPL/SQL script: `SET option=value;` 
 
-<!-- The below content is commented because these configuartions are not 
applicable now. Initially HPLSQL was provided as a stand alone command line 
tool which was supporting multiple databases including Hive. As a part of 
([HIVE-24230](https://issues.apache.org/jira/browse/HIVE-24230)) HPL/SQL has 
been re-architected to an integrated part of HiveServer (HS2). So these 
configurations are not applicable now and this content is commented for history 
purpose as http://hplsql.org/doc site is [...]
-
-<!-- HPL/SQL configuration is stored in *hplsql-site.xml* file. This file 
stores options in the following format:
-
-```
-<configuration>
-<property>
-  <name></name>
-  <value></value>
-  <description></description>
-</property>
-</configuration>
-```
-
-Note that you can set all options dynamically using the [SET]({{< ref "assign" 
>}}) statement in a HPL/SQL script: `SET option=value;` 
-
-## .hplsqlrc File
-
-*.hplsqlrc* file is automatically executed when you launch *hplsql* tool. In 
this file you can define user-defined SQL functions and stored procedures that 
can be later used in your HPL/SQL scripts.
-
-.hplsqlrc file is loaded from a CLASSPATH directory. Note that you can also 
run statements per each connection, see [splsql.conn.init.default]({{< ref 
"configuration#hplsqlconninitdefault" >}}) for details.
-
-If *.hplsqlrc* does not exist, HPL/SQL also tries to execute *hplsqlrc* file.
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.default
-
-The *hplsql.conn.default* option specifies the default connection profile. The 
default value is *hiveconn*. You can use the [SET]({{< ref "assign" >}}) 
statement in a HPL/SQL script to change the default profile at runtime:
-
-```
-SET hplsql.conn.default = <new_connection_profile>;
-```
-
-For information about connection profiles, see [Connections]({{< ref 
"connections" >}}) and [Working with Multiple Databases]({{< ref 
"multiple-databases" >}}).
-
-Version: HPL/SQL 0.1
-
-## hplsql.conn.hiveconn
-
-The *hplsql.conn.hiveconn* option specifies the connection profile for Hive 
embedded JDBC connection (not requiring a HiveServer):
-
-```
-<property>
-  <name>hplsql.conn.hiveconn</name>
-  <value>org.apache.hadoop.hive.jdbc.HiveDriver;jdbc:hive://</value>
-</property> 
-```
-
-You can use this profile when you run HPL/SQL tool on a host containing the 
Hive client (typically, a node of the Hadoop cluster).
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.init.hiveconn
-
-The *hplsql.conn.init.hiveconn* option defines SQL statements to execute after 
establishing a connection to the [hiveconn]({{< ref 
"configuration#hplsqlconnhiveconn" >}}) profile. You can use this option to 
specify job queue, execution engines in Hive etc.
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.init.hiveconn</name>
-  <value>
-     set mapred.job.queue.name=dev;
-     set hive.execution.engine=mr; 
-     use sales_db;
-  </value>
-</property>
-```
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.convert.hiveconn
-
-The *hplsql.conn.convert.hiveconn* option defines whether on-the-fly SQL 
conversion is enabled for the [hiveconn]({{< ref 
"configuration#hplsqlconnhiveconn" >}}) profile. The default value is *true*.
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.convert.hiveconn</name>
-  <value>true</value>
-</property>
-```
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.hive2conn
-
-The *hplsql.conn.hive2conn* option specifies the connection profile for 
HiveServer2 JDBC:
-
-```
-<property>
-  <name>hplsql.conn.hive2conn</name>
-  
<value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://localhost:10000;user;pwd</value>
-</property> 
-```
-
-You can use this profile when you run HPL/SQL tool on a remote host.
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.init.hive2conn
-
-The *hplsql.conn.init.hive2conn* option defines SQL statements to execute 
after establishing a connection to the [hive2conn]({{< ref 
"configuration#hplsqlconnhive2conn" >}}) profile. You can use this option to 
specify job queue, execution engines in Hive etc.
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.init.hiveconn2</name>
-  <value>
-     set mapred.job.queue.name=dev;
-     set hive.execution.engine=mr; 
-     use sales_db;
-  </value>
-</property>
-```
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.convert.hive2conn
-
-The *hplsql.conn.convert.hive2conn* option defines whether on-the-fly SQL 
conversion is enabled for the [hive2conn]({{< ref 
"configuration#hplsqlconnhiveconn" >}}) profile. The default value is *true*.
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.convert.hive2conn</name>
-  <value>true</value>
-</property>
-```
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.db2conn
-
-The *hplsql.conn.db2conn* option specifies the connection profile for a IBM 
DB2 database:
-
-```
-<property>
-  <name>hplsql.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.
-
-Set appropriate login information and use this profile if you need to work 
with a DB2 database from a HPL/SQL script.
-
-Version: HPL/SQL 0.3.7
-
-## hplsql.conn.tdconn
-
-The *hplsql.conn.tdconn* option specifies the connection profile for a 
Teradata database:
-
-```
-<property>
- <name>hplsql.conn.tdconn</name>
- <value>
- 
com.teradata.jdbc.TeraDriver;jdbc:teradata://host/database=name,logmech=ldap;usr;pwd
- </value>
- <description>Teradata connection</description>
-</property> 
-```
-
-When using Teradata JDBC driver make sure *teradata-jdbc4-xx.xx.xx.jar* and 
*tdgssconfig.jar* (both .jars required) are specified in CLASSPATH.
-
-Set appropriate login information and use this profile if you need to work 
with a Teradata database from a HPL/SQL script.
-
-Version: HPL/SQL 0.3.7
-
-## hplsql.conn.mysqlconn
-
-The *hplsql.conn.mysqlconn* option specifies the connection profile for a 
MySQL database:
-
-```
-<property>
-  <name>hplsql.conn.mysqlconn</name>
-  <value>com.mysql.jdbc.Driver;jdbc:mysql://localhost/test;user;pwd</value>
-  <description>MySQL connection</description>
-</property> 
-```
-
-When using MySQL JDBC driver make sure *mysql-connector-java-x.x.xx-bin.jar* 
is specified in CLASSPATH.
-
-Set appropriate login information and use this profile if you need to work 
with a MySQL database from a HPL/SQL script.
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.<connection_profile>
-
-The *hplsql.conn.<connection_profile>* option defines the connection profile 
*<connection_profile>*. 
-
-The *value* tag contains information about JDBC driver, connection string, 
user and password separated by semicolon (;)
-
-```
-<value>JDBC Driver;JDBC Connection String;User;Password</value>
-```
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.sales_conn</name>
-  <value>com.mysql.jdbc.Driver;jdbc:mysql://localhost/sales_db;paul;pwd</value>
-</property>
-```
-
-For information about connection profiles, see [Connections]({{< ref 
"connections" >}}) and [Working with Multiple Databases]({{< ref 
"multiple-databases" >}}).
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.conn.init.<connection_profile>
-
-The *hplsql.conn.init.<connection_profile>* option defines SQL statements to 
execute after establishing a connection to the *<connection_profile>*. You can 
use this option to specify the current database, schema or set session options.
-
-For example:
-
-```
-<property>
-  <name>hplsql.conn.init.sales_conn</name>
-  <value>
-     use sales_db;
-  </value>
-</property>
-```
-
-If you need to execute multiple SQL statements use semicolon (;) to separate 
them.
-
-Version: HPL/SQL 0.3.1
-
-## hplsql.dual.table
-
-The *hhplsql.dual.table* option defines a single row, single column table that 
HPL/SQL can use for internal operations. 
-
-Note that Hive allows you to execute SELECT statement without FROM clause 
since version 0.14 only. Using this option and Hive 0.13 and earlier, you can 
force HPL/SQL to automatically add FROM *hhplsql.dual.table* to any SELECT 
statement that does not have FROM. 
-
-The default value is **default.dual** for HPL/SQL 0.3.13 and earlier, and 
empty since HPL/SQL 0.3.17. So now HPL/SQL does not add FROM 
*hhplsql.dual.table*, by default.
-
-Note that the table must exist in the database, HPL/SQL can only use an 
existing table. 
-
-Version: HPL/SQL 0.3 introduced, HPL/SQL 0.3.17 default value changed.
-
-## hplsql.insert.values
-
-The *hplsql.insert.values* option defines how HPL/SQL executes INSERT VALUES 
statement in Hive.
-
-If *hplsql.insert.values* is set to **native** HPL/SQL relies on the database 
that must support INSERT VALUES syntax. Note that INSERT VALUES is available in 
Hive since version 0.14 only and can only be performed on tables that support 
ACID.
-
-If *hplsql.insert.values* is set to **select** HPL/SQL transforms VALUES 
clause to the list of SELECT FROM dual UNION ALL ... clauses.
-
-The default value is **native**. For more information, see [INSERT 
Statement]({{< ref "insert" >}}).
-
-Version: HPL/SQL 0.3 -->
+<!-- Version: HPL/SQL 0.3 -->
 
 ## hplsql.onerror
 
diff --git a/content/docs/latest/language/hplsql/user-guide/connections.md.bak 
b/content/docs/latest/language/hplsql/user-guide/connections.md.bak
deleted file mode 100644
index da88cfd5..00000000
--- a/content/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/content/docs/latest/language/hplsql/user-guide/conversion.md 
b/content/docs/latest/language/hplsql/user-guide/conversion.md
index eb297787..2b77fccd 100644
--- a/content/docs/latest/language/hplsql/user-guide/conversion.md
+++ b/content/docs/latest/language/hplsql/user-guide/conversion.md
@@ -38,8 +38,6 @@ CREATE TABLE dept
 );
 ```
 
-<!-- On-the-fly conversion is enabled by default and set using 
[hplsql.conn.convert.default]({{< ref "configuration#hplsqlconnconvertdefault" 
>}}) option. -->
-
 ## Data Types
 
 Conversions for data types in CREATE TABLE statements:
diff --git a/content/docs/latest/language/hplsql/user-guide/hive.md.bak 
b/content/docs/latest/language/hplsql/user-guide/hive.md.bak
deleted file mode 100644
index 78ffb061..00000000
--- a/content/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/content/docs/latest/language/hplsql/user-guide/multiple-databases.md.bak 
b/content/docs/latest/language/hplsql/user-guide/multiple-databases.md.bak
deleted file mode 100644
index 24a62509..00000000
--- a/content/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);  
-```
diff --git a/content/docs/latest/language/hplsql/user-guide/udf-sproc.md 
b/content/docs/latest/language/hplsql/user-guide/udf-sproc.md
index da159941..bbd7c17e 100644
--- a/content/docs/latest/language/hplsql/user-guide/udf-sproc.md
+++ b/content/docs/latest/language/hplsql/user-guide/udf-sproc.md
@@ -43,33 +43,9 @@ DROP PROCEDURE set_message;
 DROP FUNCTION hello;
 ```
 
-
-<!-- The below content is commented because this content is not applicable 
now. Initially HPLSQL was provided as a stand alone command line tool which was 
supporting multiple databases including Hive. As a part of 
([HIVE-24230](https://issues.apache.org/jira/browse/HIVE-24230)) HPL/SQL has 
been re-architected to an integrated part of HiveServer (HS2). So this content 
is commented for history purpose as http://hplsql.org/doc site is not up where 
the contet is maintained. For the same purp [...]
-
-<!-- ## Permanent Functions and Stored Procedures
-
-HPL/SQL allows you to share functions and procedures between HPL/SQL scripts 
so you do not need to put their content to every script. 
-
-Unlike databases that typically store functions and stored procedures in the 
database catalog, HPL/SQL stores them in local files. There are several options 
how to you can include functions and procedures:
-
-- Use *.hplsqlrc* file
-
-You can put your functions and procedures to *.hplsqlrc* file. The content of 
this file is automatically executed when you start *hplsql* tool. For more 
information, see [.hplsqlrc]({{< ref "configuration#hplsqlrc-file" >}}) file. 
-
-- INCLUDE statement
-
-Using [INCLUDE]({{< ref "include" >}}) statement you can load function and 
procedures definitions from any file. Note that you can also use [INCLUDE]({{< 
ref "include" >}}) statements in [.hplsqlrc]({{< ref 
"configuration#hplsqlrc-file" >}}) file. 
-
-## Using HPL/SQL User-Defined Functions in Hive Queries
-
-HPL/SQL allows you to invoke user-defined functions written in HPL/SQL 
language from Hive queries the same way as you use HQL built-in functions.
-
-HPL/SQL CLI tool automatically puts referenced HPL/SQL functions and 
procedures to Distributed Cache, registers the Hive UDF and modifies the 
function call in the SQL statements. For more information, see [Hive UDF to Run 
HHPL/SQL Scripts]({{< ref "udf" >}}).
-
-**Version**: HPL/SQL 0.3.1 -->
+<!-- **Version**: HPL/SQL 0.3.1 -->
 
 See also:
 - [CALL]({{< ref "call" >}})
 - [CREATE FUNCTION]({{< ref "create-function" >}})
 - [CREATE PROCEDURE]({{< ref "create-procedure" >}})
-<!-- - [INCLUDE]({{< ref "include" >}}) -->

Reply via email to