Hi Szabolcs,

I don' t think this is the issue with the data quality. For the initial load it did not show any issue. Only when I tried to do merge with the incremental with last modified option. Please see the attached document for sqoop log.

On Sun, Oct 22, 2017 at 7:39 AM, Szabolcs Vasas <vasas@cloudera.com> wrote:
Hi Ajana,

Can you please copy and paste the full Sqoop logs and the table definition?
'like Gecko) Chrome/54.0.2840.71 Safari/537.36' seems to be a value in the database, is it possible that there is a data quality issue and one of the columns (e.g. META_MAINT_DT, CNSMR_DEVICE_UID) contains it?


On Fri, Oct 20, 2017 at 11:48 AM, Ajana Chandiruthil Sathian <ajanacs@gmail.com> wrote:
To whomever it may concern,

I could not fix this isseError: java.lang.RuntimeException: Can't parse input data: ' like Gecko) Chrome/54.0.2840.71 Safari/537.36'

Below is the sqoop command.

sqoop-import --connect xxx \

--username xxx \

--password xxx \

--target-dir xxx \

--query "SELECT * FROM (SELECT cd.* , to_char(cd.META_MAINT_DT, 'yyyy-mm-dd') as filedate FROM ODS.table1 cd ') t1 WHERE \$CONDITIONS" \

--incremental lastmodified \

--check-column META_MAINT_DT \

--merge-key CNSMR_DEVICE_UID \

--split-by CNSMR_DEVICE_UID \

--fields-terminated-by '\001' \

-m 64

Any kind of help is really appreciated!

Szabolcs Vasas
Software Engineer