Hi Zheng,
I can have the data in the format you have mentioned. Please advise how
I can have list of maps in this format as a field in a table.
Thanks,
Rakesh
-----Original Message-----
From: Zheng Shao [mailto:[email protected]]
Sent: Thursday, July 02, 2009 1:58 AM
To: [email protected]
Subject: Re: How to store list of maps?
Hi Rakesh,
Internally Hive does support list of maps, and even more nested levels.
However, we didn't open it up for the "create table" command yet. That
shouldn't be hard to do though.
We will require the list to be separated by ^B, and map items to be
separated by ^C, while map key and value separated by ^D.
Is that a format that you can produce?
Zheng
On Wed, Jul 1, 2009 at 1:19 PM, Rakesh Setty<[email protected]> wrote:
> Hi,
>
>
>
> I need to store a list of maps as one of the fields of a record.
> The documentation suggests that arrays are supported only for primitive data
> types. Is there any way to do this in Hive? One solution that I can think of
> is to store the maps in a separate table and relate them to the base table.
> But I would like to know the best solution. Please let me know what would be
> the best way to do this.
>
>
>
> Thanks,
>
> Rakesh
--
Yours,
Zheng
