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.kerz...@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
