[
https://issues.apache.org/jira/browse/HIVE-24338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Attila Magyar reassigned HIVE-24338:
------------------------------------
> 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
> Priority: Major
>
> 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)
