You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Attila Magyar (Jira)" <ji...@apache.org> on 2020/10/30 13:47:00 UTC

[jira] [Assigned] (HIVE-24338) HPL/SQL missing features

     [ 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)