sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Szabolcs Vasas <va...@cloudera.com>
Subject Re: Can't parse input data
Date Sun, 22 Oct 2017 12:39:45 GMT
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 <
ajanacs@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>

Mime
View raw message