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!
