Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - RE: sqoop export - parse exception


+
Peleg, Eyal 2013-06-09, 11:45
+
Peleg, Eyal 2013-06-09, 11:39
Copy link to this message
-
Re: sqoop export - parse exception
Jarek Jarcec Cecho 2013-06-09, 14:57
Hi Peleg,
I'm not sure that using the same value for both --input-fields-terminated-by and --input-escaped-by is correct. Is your input really delimited and at the same time escaped by tabulators?

Jarcec

On Sun, Jun 09, 2013 at 11:39:51AM +0000, Peleg, Eyal wrote:
> My export command is as follows:
>
>
> sqoop export --connect 'jdbc:sqlserver://papdb-dev.intel.com:3180;username=epmsysadm;password=s!peruser; DATABASE=AdvancedBIsystem' --table testing --export-dir  /user/eyapeleg/test --input-fields-terminated-by '\t'  --input-escaped-by '\t'  --lines-terminated-by '\n' --username epmsysadm --password 's!peruser'
>
> *note! I used tab delimited format.
>
> I'm able to export the following table:
>
> a              a
> b             b
>
> but  fail to export the next one:
>
> aa           a
> bb           a
>
> I get a parse exception:
>
> java.io.IOException: Could not parse record: aa a
>         at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:80)
>         at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:36)
>         at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
>         at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:183)
>         at org.apache.hadoop.mapred.MapTask.runNewMapper_aroundBody4(MapTask.java:813)
>         at org.apache.hadoop.mapred.MapTask$AjcClosure5.run(MapTask.java:1)
>         at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
> ...
>
> Best Regards,
>
>
>
>
> ---------------------------------------------------------------------
> Intel Electronics Ltd.
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
+
Peleg, Eyal 2013-06-09, 15:36
+
Jarek Jarcec Cecho 2013-06-09, 15:44
+
Peleg, Eyal 2013-06-09, 15:52
+
Jarek Jarcec Cecho 2013-06-09, 16:01
+
Peleg, Eyal 2013-06-09, 16:10
+
Jarek Jarcec Cecho 2013-06-09, 16:20
+
Peleg, Eyal 2013-06-09, 16:29
+
Jarek Jarcec Cecho 2013-06-09, 19:14