Yes, that's correct that Sqoop2 should insert new lines at the end of a records. But if that record has many columns say (>15) columns in a record, then after few columns, it inserts a new line .
Example: 1,'346088103340400','3410 9240 5550 778','3710-1690-2390-472','537436268','537 43 6268 ','537-43-6268 ','6816758580 ','681 675 8580 ','681-675-8580 ','(681) 675-8580 ','(681)675-8580 ','1617547959','12.215.42.19 ','','1132286141 ','https://blu162.mail.live.com ','110 Campus Dr. Berkeley CA 94111 ','James ' This is one record which got imported to HDFS in the above mentioned format. After 6th column it inserted a new line and then after each column, it inserted new line. Though this behavior of inserting new lines is not same in all the cases. It inserts new lines randomly after nth column. On Thu, Oct 2, 2014 at 1:12 AM, Abraham Elmahrek <[email protected]> wrote: > Hey there, > > Sqoop2 should insert new lines at the end of a record. In fact, Sqoop2 > should just write CSV. Could you copy/paste an example with Schema? > > -Abe > > On Tue, Sep 30, 2014 at 11:32 PM, shakun grover <[email protected]> > wrote: > > > Hi All, > > > > When I import many columns(say >20 columns) from RDBMS to HDFS, then > Sqoop2 > > inserts a new line in the output file.The newline appears at the end of > > certain fields.Doesn't seem to appear for every single field. > > > > Can you please tell me why this new line is inserted? And is there any > way > > to avoid this? > > > > Thanks in advance!! > > > > > > -- > > Thanks & Regards, > > Shakun Grover > > > -- Thanks & Regards, Shakun Grover
