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

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

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

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)