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

["Attila Magyar (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-24338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17223661#comment-17223661 ] 

Attila Magyar commented on HIVE-24338:
--------------------------------------

The ForAll is mainly an optimization to avoid sending statements line by line to the DB. Named parameters are not that widely used as far as I know.

Goto and label is mostly used for error handling. Bulk collect can be useful for selecting into an array but it requires an Table or Array type first and type declarations first.

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