HPL/SQL is included to Apache Hive since version 2.0
This is an old revision of the document!
SQLSTATE built-in variable contains a 5-character return status of the last SQL statement.
SQLSTATE status code consists of a 2-character class code followed by a 3-character subclass code. Class code 00 (SQLSTATE '00000' i.e.) means the successful completion.
SET plhql.onerror = seterror; -- Prevent raising an exception SELECT 1 FROM abc.abc; PRINT SQLSTATE;
Compatibility: IBM DB2.
Version: PL/HQL 0.03