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" >}}) -->