[Hive-user] How does COLLECTION ITEMS work in Hive?

On Tue, Oct 4, 2011 at 7:23 PM, Steven Wong 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
*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****

** **