hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Malak (JIRA)" <>
Subject [jira] [Created] (HIVE-4771) Support subqueries in INSERT for array types
Date Thu, 20 Jun 2013 22:09:20 GMT
Michael Malak created HIVE-4771:

             Summary: Support subqueries in INSERT for array types
                 Key: HIVE-4771
             Project: Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Michael Malak

Since Hive supports SQL1999-style array types for columns, it would be nice for there to be
a way to INSERT non-static data into such columns -- i.e. from another table based on a complex
query as opposed to loading from a static file, loading from hard-coded values within the
INSERT query, or copying complete arrays verbatim from another table.

An example can be found at:

CREATE TABLE table_a(a int, b int, c int[]);

  SELECT a, b, ARRAY(SELECT c FROM table_c WHERE table_c.parent =
  FROM table_b

This should be implemented after regular correlated and uncorrelated subqueries are implemented: "Support uncorrelated subqueries in the WHERE
clause" "Support correlated subqueries in the WHERE

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message