[HIVE-24338] HPL/SQL missing features

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: hpl/sql
• Target Version/s: 4.0.0
• Assignee: Attila Magyar
• Reporter: Attila Magyar
• Created: 30/Oct/20 13:46
• Updated: 12/Jul/21 14:37
• Resolved: 12/Jul/21 14:37

Description

There are some features which are supported by Oracle's PL/SQL but not by HPL/SQL. This Jira is about to prioritize them and investigate the feasibility of the implementation.

• ForAll syntax like: ForAll j in i..j save exceptions
• Bulk collect: : Fetch cursor Bulk Collect Into list Limit n;
• Type declartion: Type T_cab is TABLE of
• TABLE datatype
• GOTO and LABEL
• Global variables like $$PLSQL_UNIT and others
• Named parameters func(name1 => value1, name2 => value2);
• Built in functions: trunc, lpad, to_date, ltrim, rtrim, sysdate