Hi VKing, it seems that the log generated with parameter --verbose did not got it through. Would you mind sending it again?
Jarcec
On Wed, Jul 17, 2013 at 01:37:59PM -0700, VKing Gorri wrote:
> Hi Jarcec,
>
> Here are the details...
>
> sqoop version 1.4.2
> cloudera :- CDH-4.2.1-1.cdh4.2.1.p0.5
> MySQL connector :- mysql-connector-java-5.1.24-bin.jar
>
> Command Line -
> sqoop --options-file $CONNECTION_FILE --fields-terminated-by '\007'
> --lines-terminated-by '\n' --verbose --query "$QUERY'${LAST_EXT_DT}' and
> \$CONDITIONS" -m 1 --target-dir $YYYY/$MM/$DD/${TBL_NAME} --null-string '\\N'
> --null-non-string '\\N' >> $LOGFILE 2>&1
>
>
>
> ________________________________
> From: Jarek Jarcec Cecho <[email protected]>
> To: [email protected]; VKing Gorri <[email protected]>
> Sent: Wednesday, July 17, 2013 7:52 AM
> Subject: Re: Import Blank values from MySQL
>
>
> Hi VKing,
> would you mind sharing more information with us? It would be handy to know
> the Sqoop version and entire command line. It would be also great if you
> could share entire Sqoop log generated with parameter --verbose.
>
> Jarcec
>
> On Tue, Jul 16, 2013 at 11:47:15PM -0700, VKing Gorri wrote:
> > Hi,
> >
> > The blank values from MySQL are being imported as '@'. Is there any
> > parameter to handle blank values?
> >
> >
> > I am handling NULL values using the following parameters.
> > --null-string '\\N' --null-non-string '\\N'
> >
> >
> >
> > Thanks!
signature.asc
Description: Digital signature
