hadoop - 无法使用oozie运行sqoop

Question

当我从 CLI 运行以下 sqoop 命令时，我能够将数据导出到 OracleDB，但是当我使用 oozie 工作流运行相同的命令时，我遇到了问题。

直接从 CLI 运行的命令:

sqoop export --connect jdbc:oracle:thin:@192.168.245.1:1521:XE --username HR --password HR --table HR.REVIEW_FINAL --export-dir /user/cloudera/Review/hive/review_final --input-fields-terminated-by '\001'

以下是我通过 Oozie 使用的内容:

<command>export --connect jdbc:oracle:thin:@192.168.245.1:1521:XE --username HR --password HR --table HR.REVIEW_FINAL --export-dir /user/cloudera/Review/hive/review_final --input-fields-terminated-by '\001'</command>

我在日志中看到的异常:

java.io.IOException: Can't export data, please check failed map task logs
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:112)
at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:39)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:140)
at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:672)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1438)
at org.apache.hadoop.mapred.Child.main(Child.java:262)

引起:java.lang.RuntimeException:无法解析输入数据:

Answer 1

--input-fields-terminated-by '\001'

改成

--input-fields-terminated-by \001

祝你好运!