sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From VKing Gorri <vkinggo...@yahoo.com>
Subject Re: Import Blank values from MySQL
Date Wed, 17 Jul 2013 20:37:59 GMT
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 <jarcec@apache.org>
To: user@sqoop.apache.org; VKing Gorri <vkinggorri@yahoo.com> 
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!
Mime
View raw message