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!
