Hi Tim, You can use the explode UDTF. More here:
http://wiki.apache.org/hadoop/Hive/LanguageManual/LateralView HTH Thanks and Regards, Sonal On Tue, Mar 16, 2010 at 3:32 PM, Tim Robertson <[email protected]>wrote: > Hi all, > > I have a table of 2 columns of strings, with example row as: > > Col1 Col2 > 123 23,34,45,67... up to around 1 million > > I'd like to expand the comma separated values to a new taller KVP table: > > Col1 Col2 > 123 23 > 123 34 > 123 45 > 123 67 > 123 .... potentially 1,000,000 rows generated > > Can someone please point me in the right direction? > > Thanks > Tim > > >
