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)
