Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
Copy link to this message
-
sqoop export - parse exception
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.
+
Jarek Jarcec Cecho 2013-06-09, 14:57
+
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB