hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Gates <ga...@hortonworks.com>
Subject Re: Hive 0.14 SQL Inserts Complex Data Types
Date Tue, 06 Jan 2015 01:07:18 GMT
No, because insert...values writes the values to a local file, builds a 
temp table over that local file, then rewrites the query to "insert into 
X select from tmptable".  The expressions aren't evaluated before being 
written to the file.  More work would need to be done to write the 
"pre-expression" data to the file and then have the query re-write 
handle inserting the expressions back into the insert statement.

Alan.

> Jason Dere <mailto:jdere@hortonworks.com>
> December 19, 2014 at 10:55
> There are UDFs to create complex types, would something like this work?
>     INSERT .. VALUES select map('key1', 'val1', 'key2', 'val2');
>
>
>
>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or 
> entity to which it is addressed and may contain information that is 
> confidential, privileged and exempt from disclosure under applicable 
> law. If the reader of this message is not the intended recipient, you 
> are hereby notified that any printing, copying, dissemination, 
> distribution, disclosure or forwarding of this communication is 
> strictly prohibited. If you have received this communication in error, 
> please contact the sender immediately and delete it from your system. 
> Thank You.
> Skyler Beckman <mailto:Skyler.Beckman@livetv.net>
> December 19, 2014 at 8:50
>
> Thanks
>
> *From:*Alan Gates [mailto:gates@hortonworks.com]
> *Sent:* Friday, December 19, 2014 11:35 AM
> *To:* user@hive.apache.org
> *Subject:* Re: Hive 0.14 SQL Inserts Complex Data Types
>
> Hive does not support literals for complex types, so it is not 
> possible to use them in INSERT...VALUES clauses.
>
> Alan.
>
>
> *Skyler Beckman* <mailto:Skyler.Beckman@livetv.net>
>
> December 17, 2014 at 9:59
>
> With 0.14 is it possible to use the INSERT…VALUES statement to insert 
> data into a table with complex types like arrays, maps, etc? We will 
> never be loading data from a file which is why I ask.
>
> -- 
>
> Sent with Postbox <http://www.getpostbox.com>
>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or 
> entity to which it is addressed and may contain information that is 
> confidential, privileged and exempt from disclosure under applicable 
> law. If the reader of this message is not the intended recipient, you 
> are hereby notified that any printing, copying, dissemination, 
> distribution, disclosure or forwarding of this communication is 
> strictly prohibited. If you have received this communication in error, 
> please contact the sender immediately and delete it from your system. 
> Thank You.
>
> Alan Gates <mailto:gates@hortonworks.com>
> December 19, 2014 at 8:35
> Hive does not support literals for complex types, so it is not 
> possible to use them in INSERT...VALUES clauses.
>
> Alan.
>
>
> Skyler Beckman <mailto:Skyler.Beckman@livetv.net>
> December 17, 2014 at 9:59
>
> With 0.14 is it possible to use the INSERT…VALUES statement to insert 
> data into a table with complex types like arrays, maps, etc? We will 
> never be loading data from a file which is why I ask.
>

-- 
Sent with Postbox <http://www.getpostbox.com>

-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.

Mime
View raw message