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 < [email protected]> 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 <http://www.cloudera.com>
