hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Singh <23singhabhis...@gmail.com>
Subject Re: Sqoop Export record count mismatch issue ..
Date Fri, 06 May 2016 09:20:11 GMT
Hi Raju,

This could be an issue with the delimiters specified in your csv file. Do
you find any extra new line characters? Please check for line breaks.

I hope this gives some clue.

Regards,
Abhishek Singh
23singhabhishek@gmail.com

On Tue, May 3, 2016 at 2:23 AM, Raju Rathi <raju.rathi1112@gmail.com> wrote:

> Hello All ,
>
> I am running below sqoop Job to export CSV file data into my Sql however I
> see strange behavior where number of record exported into table is more
> then number of record present in CSV file . CSV file present under location
>   $USER_DIR has 108 rows while after export , I can see 114 record
> present in DB . please advice what could be root cause .
>
>
>  sqoop export \
>
> -Dmapred.job.queue.name=$MY_QUEUE \
>
> --connect $MY_SQL_URL \
>
> --direct \
>
> -m 1 \
>
> --table $USER_TBL \
>
> --export-dir $USER_DIR \
>
> --username $MYSQL_USERNMAE \
>
> --password $MYSQL_PWD;
>
>
> Thanks ,
>
> Raju Rathi
>
>
>

Mime
View raw message