There are UDFs to create complex types, would something like this work?
INSERT .. VALUES select map('key1', 'val1', 'key2', 'val2');
On Dec 19, 2014, at 8:50 AM, Skyler Beckman <skyler.beck...@livetv.net> wrote:
> Thanks
>
> From: Alan Gates [mailto:ga...@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.
>
>
> <image001.jpg>
> Skyler Beckman
> 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
>
> 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.
--
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.
