HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL compatibility with Oracle PL/SQL and SQL.
Oracle PL/SQL language elementes supported by HPL/SQL:
TRUE and FALSE | Boolean literals | ![]() | 0.3.13 |
-- comment | Single line comment | ![]() | 0.1 |
/* comment */ | Multi line comment | ![]() | 0.1 |
NOT NULL | Variable constraint | Parser only ![]() | 0.3.13 |
CONSTANT | Constant variable | ![]() | 0.3.13 |
:= or DEFAULT | Default clause | ![]() | 0.1 |
%TYPE | Data type attribute | ![]() | 0.3.13 |
SUBTYPE subtype IS type | Subtype | ![]() |
Oracle PL/SQL data types supported by HPL/SQL:
Oracle PL/SQL operators and expressions supported by HPL/SQL:
|| Operaror | String concatenation | ![]() | 0.1 |
Oracle PL/SQL statements supported by HPL/SQL:
:= | Assignment statement | ![]() | 0.1 |
CREATE FUNCTION | Create a user-defined function | ![]() | 0.3.1 |
CREATE PACKAGE | Create a package | ![]() | 0.3.13 |
CREATE PROCEDURE | Create a stored procedure | ![]() | 0.3.1 |
NULL | No operation | ![]() | 0.3.13 |
SELECT INTO | Assign values from query | ![]() | 0.1 |