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 <email@example.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?Thanks,Szabolcs--On Fri, Oct 20, 2017 at 11:48 AM, Ajana Chandiruthil Sathian <firstname.lastname@example.org> 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 64Any kind of help is really appreciated!