Karmasphere Studio would be good for this. It is really a front end for Hadoop however it runs on small amounts of data independently.
On 31 March 2011 17:49, Mark <[email protected]> wrote: > I have these "rows" > > ({(155495400)}) > ({(199027860),(199027860),(149167529),(203508790),(198488630)}) > ({(174255619),(201077556),(199051606),(198778302)}) > > I believe the correct way to explain them would be each row/tuple is a bag > that contains tuples of size 1? Is that right? > > Anyway, is there something native or UDF I can use to convert them to this > format? > > (155495400) > (199027860 199027860 149167529 203508790 198488630) > (174255619 201077556 199051606 198778302) > > Maybe if I explain what we are trying to do it would help. > > We have logs of users to product views in a tab delimited format. > > foo\t1234 > bar\t1234 > foo\t4423 > baz\t5563 > > We simply want product views grouped by user and outputed on 1 line. > > 1234 4423 > 1234 > 5563 > > The above first line would be from the user foo, second bar and third baz. > > Thanks > -- Regards Dave Butler butlerdi-at-pharm2phork-dot-org Also on Skype as pharm2phork Get Skype here http://www.skype.com/download.html ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************
