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

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


+
VKing Gorri 2013-07-17, 06:47
+
Jarek Jarcec Cecho 2013-07-17, 14:52
+
VKing Gorri 2013-07-17, 20:37
Copy link to this message
-
Re: Import Blank values from MySQL
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!