hadoop - Not able to run sqoop using oozie -
When I'm running a minimum command command from CLI, I'm able to export the data to Oracle DB, but On the same order, I am using the Ozzy workflow, I am having problems.
Command running directly from CLI:
sqoop export --connect jdbc: oracle: thin: @ 192.168 245.1: 1521: XE - User Name HR - Password HR --table HR Review_final - ExportDirectory / User / Cloeder / Review / Hive / Review_Final - Input-field-Terminated-By '\ 001' & lt; Order & gt; Export - Connector jdbc: oracle: thin: @ 192.168.245.1: 1521: xi - -name hr - password hr --table hr. REVIEW_FINAL - Export-DIR / User / Cloeder / Review / Hive / Review_Final - input-field-terminated-by '\ 001' & lt; / Command & gt;
Exceptions that I see in logs:
java.io.IOException: data can not be exported, please see the failed Map Work Log on OG Apache.sqoop.mapreduce.TextExportMapper.map (TextExportMapper.java:1212) at org.apache.sqoop.mapreduce.TextExportMapper.map (TextExportMapper.java39) at org.apache.hadoop.mapreduce.Mapper.run (Mapper.Java : 140) org.apache.sqoop.mapreduce.AutoProgressMapper.run at (AutoProgressMapper.java:64) org.apache.hadoop.mapred.MapTask.RunNewMapper (MapTask.java:672) org.apache.hadoop.mapred on Javax Go to java.security.AccessController.doPrivileged (original method) on .security.auth at org.apache.hadoop.mapred.Child $ 4.run (child.javaociety68) .mapTask.run (MapTask.java:330). Topics on Org.apache.hadoop.security.UserGroupInformation.doAs (UserGroupInformation.java1438 ).Downa (theme java396) org.apache.hadoop.mapred.Child.main (child.javaaxy62)
< P> By: java.lang.RuntimeException: Input data can not be parsed:
< Code> - input-field-end '' 001 ''
change it
- input-field-terminal-by \ 001
Good luck!
Comments
Post a Comment