Perfect. Thanks
On Tue, Mar 16, 2010 at 11:36 AM, Sonal Goyal <[email protected]> wrote: > 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 >> >> >> >
