Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Import Blank values from MySQL

Copy link to this message
Re: Import Blank values from MySQL
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]>
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.


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!