hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Malak <michaelma...@yahoo.com>
Subject Re: INSERT non-static data to array?
Date Wed, 19 Jun 2013 20:35:56 GMT
The example code for inline_table() there has static data.  It's not possible to use a subquery
inside the inline_table() or array() is it?

The SQL1999 way is described here:

http://www.postgresql.org/message-id/20041028232152.GA76168@winnie.fuhr.org


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

INSERT INTO table_a
  SELECT a, b, ARRAY(SELECT c FROM table_c WHERE table_c.parent = table_b.id)
  FROM table_b

________________________________
From: Edward Capriolo <edlinuxguru@gmail.com>
To: "user@hive.apache.org" <user@hive.apache.org>; Michael Malak <michaelmalak@yahoo.com>

Sent: Wednesday, June 19, 2013 2:06 PM
Subject: Re: INSERT non-static data to array?



: https://issues.apache.org/jira/browse/HIVE-3238


This might fit the bill.




On Wed, Jun 19, 2013 at 3:23 PM, Michael Malak <michaelmalak@yahoo.com> wrote:

Is the only way to INSERT data into a column of type array<> to load data from a pre-existing
file, to use hard-coded values in the INSERT statement, or copy an entire array verbatim from
another table?  I.e. I'm assuming that a) SQL1999 array INSERT via subquery is not (yet)
implemented in Hive, and b) there is also no other way to load dynamically generated data
into an array<> column?  If my assumption in a) is true, does a Jira item need to be
created for it?
>

Mime
View raw message