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 <va...@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? > > Thanks, > Szabolcs > > On Fri, Oct 20, 2017 at 11:48 AM, Ajana Chandiruthil Sathian < > ajan...@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 > <http://www.cloudera.com> >
sqooplog.docx
Description: MS-Word 2007 document
