Thanks Abhijeet for your response. Let me know whether the Sqoop option that you have told me, *--lines-termination-by ','* can be implemented to query the same row in the same fashion only with a minute change that the each row should have maximum 4 values, the next succeeding values should come from the next line and so on, like
1234,1235,1564,1674 1546,2546,5653,6434 6543,6534,7763,6567 and so on. . . On Fri, Jan 18, 2013 at 5:20 PM, abhijeet gaikwad <[email protected]>wrote: > Sqoop does not facilitate what you seek in #1. You will have to build an > ad-hoc system for that! > For #2 if you have only one column in your table, then add this option to > your sqoop command: > --lines-terminated-by ',' > > Thanks, > Abhijeet > On Jan 18, 2013 4:51 PM, "Vineet Mishra" <[email protected]> > wrote: > >> Hallo All, >> >> I am working with Sqoop to query from the database to for my Map/Reduce >> job, the issue I am struggling with is >> >> 1) Is there a way to directly pass the Sqoop Import Result to the Map for >> processing rather than storing it to file system and then processing. >> >> If above can't be done then let me know whether, >> >> 2) I want the format of the file which is coming from the sqoop import >> command to be comma(,) separated single line file, but my output is coming >> as a multi row file. >> >> >> I am querying from the Database fetching a single column of some random >> values, which is coming in the format, >> >> 1234 >> 1235 >> 1564 >> 1674 >> 1546 >> 2546 >> 5653 >> 6434 >> >> the output which I was expecting was, >> >> 1234,1235,1564,1674,1546,2546,5653,6434 >> >> and so on. . . >> >> Urgent!!! >> Sqoop Developers/Users please reply! >> >> >> -- >> Thanks and Regards >> Vineet Mishra >> > -- Thanks and Regards Vineet Mishra
