hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Kerzner <mark.kerz...@shmsoft.com>
Subject Re: How does COLLECTION ITEMS work in Hive?
Date Wed, 05 Oct 2011 00:46:10 GMT
Thank you, I found very few examples, and this old Jira helped the best

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

On Tue, Oct 4, 2011 at 7:23 PM, Steven Wong <swong@netflix.com> wrote:

> COLLECTION ITEMS refers to the ARRAY column type. For more info on arrays,
> see:****
>
> ** **
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL****
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF****
>
> ** **
>
> ** **
>
> *From:* Mark Kerzner [mailto:mark.kerzner@shmsoft.com]
> *Sent:* Tuesday, October 04, 2011 9:28 AM
> *To:* Hive user
> *Subject:* How does COLLECTION ITEMS work in Hive?****
>
> ** **
>
> Hi, expert,
>
> I see this clause in CREATE TABLE --****
>
> ** **
>
> COLLECTION ITEMS TERMINATED BY
>
> How does it work? Does Hive create a new row for each collection item, repeating the
other elements? If not, how does it treat collection items?
>
> Thank you,
> Mark****
>
> ** **
>

Mime
View raw message