Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-24338

HPL/SQL missing features

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • hpl/sql
    • None

    Description

      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

      Attachments

        Activity

          People

            amagyar Attila Magyar
            amagyar Attila Magyar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: