Re: Transpose

2013-03-06 Thread Michel Segel
Sandy, Remember KISS. Don't try to read it in as anything but just a text line. Its really a 3x3 matrix in what looks to be grouped by columns. Your output will drop the initial key, and you then parse the lines and then output it. Without further explanation, it looks like each tuple is uniq

Re: Transpose

2013-03-05 Thread Sandy Ryza
Hi, Essentially what you want to do is group your data points by their position in the column, and have each reduce call construct the data for each row into a row. To have each record that the mapper processes be one of the columns, you can use TextInputFormat with conf.set("textinputformat.reco

Re: Transpose

2013-03-05 Thread Michel Segel
Yes you can. You read in the row in each iteration of Mapper.map() Text input. You then output 3 times to the collector one for each row of the matrix. Spin,sort, and reduce as needed. Sent from a remote device. Please excuse any typos... Mike Segel On Mar 5, 2013, at 9:11 AM, Mix Nin wrote:

Transpose

2013-03-05 Thread Mix Nin
Hi I have data in a file as follows . There are 3 columns separated by semicolon(;). Each column would have multiple values separated by comma (,). 11,22,33;144,244,344;yny; I need output data in below format. It is like transposing values of each column. 11 144 y 22 244 n 33 344 y Can we wri