Hi sir, Would you mind sharing with us entire sqoop command that you've used for export job that worked?
Jarcec On Thu, Dec 13, 2012 at 04:07:37PM +0800, wzc wrote: > I run into this too, I try add "--fields-terminated-by " and get the right > result. > > refer: > --fields-terminated-by <char>Sets the field separator character > 2012/7/27 Connell, Chuck <[email protected]> > > > Thanks Kathleen, > > > > I read that report and I think mine is different. I do not get an error > > message, but the export yields the wrong result. I will file a jira. > > > > Chuck > > > > > > ________________________________________ > > From: Kathleen Ting [[email protected]] > > Sent: Thursday, July 26, 2012 6:01 PM > > To: [email protected] > > Subject: Re: Possible bug (export) --direct and > > --input-fields-terminated-by '\t' not working correctly? > > > > Chuck, > > > > I think you might be hitting > > https://issues.apache.org/jira/browse/SQOOP-450, fixed in upcoming > > release Sqoop 1.4.2 > > > > Regards, Kathleen > > > > On Thu, Jul 26, 2012 at 6:46 AM, Connell, Chuck > > <[email protected]> wrote: > > > I have a Hive table that has tab-separated fields. I am exporting it to > > MySQL. The export works fine (using --input-fields-terminated-by '\t') and > > I get correct results in MySQL. > > > > > > BUT, when I add the --direct option, the export fails. The source file > > (in Hive warehouse) is not parsed correctly and the tabs are ignored. The > > fields are not separated correctly when placed into MySQL. > > > > > > Anyone else run into this? > > > > > > Chuck Connell > > > Nuance R&D Data Team > > > Burlington, MA > > > > >
signature.asc
Description: Digital signature
