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

Initial support for TABLE function

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: Parser
    • Labels:
    • Target Version/s:

      Description

      Include support for TABLE function derived table. In SQL standard, it is defined as:

      <table function derived table> ::=
        TABLE <left paren> <collection value expression> <right paren>
      

      Further, include limited support for its usage as LATERAL derived table.

      This will allow Hive to execute queries such as:

      SELECT tf.col1, tf.col2, tf.col3
      FROM
        TABLE(VALUES('A', 10, 30.0),('B', 20, 30.0)) AS tf(col1, col2, col3);
      SELECT tf.col1, tf.col2, tf.col3
      FROM
        (SELECT key, value FROM src) t,
        LATERAL TABLE(VALUES('A', 10, t.key),('B', 20, t.key)) AS tf(col1, col2, col3);
      

      The idea is to rely on AST rewriting for such cases, as TABLE can be implemented using inline UDTF with an array of structs representing the rows in the VALUES clause.

        Attachments

        1. HIVE-18416.01.patch
          1.58 MB
          Jesus Camacho Rodriguez
        2. HIVE-18416.patch
          60 kB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: