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

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

java - Gradle dependencies: compile project by relative path -

ruby on rails - Object doesn't support #inspect when used with .include -