Compatibility
Apache Hive : HPL/SQL - Oracle PL/SQL Compatibility
Aug 12, 2026Apache Hive : HPL/SQL - Oracle PL/SQL Compatibility
HPL/SQL compatibility with Oracle PL/SQL and SQL.
Language Elements
Oracle PL/SQL language elements supported by HPL/SQL:
| Feature | Description | Supported | Since |
|---|---|---|---|
| TRUE and FALSE | Boolean literals | Yes | 0.3.13 |
| – comment | Single line comment | Yes | 0.1 |
| /* comment */ | Multi line comment | Yes | 0.1 |
| NOT NULL | Variable constraint | Parser only | 0.3.13 |
| CONSTANT | Constant variable | Yes | 0.3.13 |
| := or DEFAULT | Default clause | Yes | 0.1 |
| %TYPE | Data type attribute | Yes | 0.3.13 |
| SUBTYPE subtype IS type | Subtype | No |
Data Types and Declarations
Oracle PL/SQL data types supported by HPL/SQL: