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 <[email protected]> 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:[email protected]] > *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**** > > ** ** >
