Sqoop Export record count mismatch issue ..

[Raju Rathi <ra...@gmail.com>]

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

Re: Sqoop Export record count mismatch issue ..

[Abhishek Singh <23...@gmail.com>]

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 <ra...@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
>
>
>