It seems that the root cause of the issue is the following exception:

Error: java.lang.RuntimeException: Can't parse input data:
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm- dd

So I think there is an invalid value in one of the timestamp columns somehow, please check the result set of your query.


On Mon, Oct 23, 2017 at 8:49 AM, Ajana Chandiruthil Sathian <> wrote:
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 <> 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 <> 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

Szabolcs Vasas
Software Engineer