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]>
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!