Attila Magyar created HIVE-24338: ------------------------------------ Summary: HPL/SQL missing features Key: HIVE-24338 URL: https://issues.apache.org/jira/browse/HIVE-24338 Project: Hive Issue Type: Improvement Components: hpl/sql Reporter: Attila Magyar Assignee: Attila Magyar
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 -- This message was sent by Atlassian Jira (v8.3.4#803005)