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.
signature.asc
Description: Digital signature
