生命在于扯淡 2018-06-19 02:21 采纳率: 0%
浏览 2002
已结题

oozie调用sqoop import任务,出现异常

oozie4.3.1 sqoop1.4.7
workflow.xml



<workflow-app xmlns="uri:oozie:workflow:0.5" name="sqoop-import-wf">
    <start to="sqoop-node"/>
    <action name="sqoop-node">
        <sqoop xmlns="uri:oozie:sqoop-action:0.3">
            <job-tracker>${jobTracker}</job-tracker>
            <name-node>${nameNode}</name-node>
        <configuration>
                <property>
                  <name>mapred.job.queue.name</name>
                  <value>${queueName}</value>
                </property>
                <property>
                  <name>oozie.sqoop.log.level</name>
                  <value>WARN</value>
                </property>           
            </configuration>
        <command>import --connect jdbc:mysql://study:3306/test --username root --password 123456 --table terminal_info --where "update_time between 20180615230000 and 20180616225959" --target-dir "/user/hive/warehouse/temp_terminal_info" --append --fields-terminated-by "," --lines-terminated-by "\n" --num-mappers 1 --direct</command>
    </sqoop>
        <ok to="end"/>
        <error to="fail"/>
    </action>

    <kill name="fail">
        <message>Sqoop failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
    </kill>
    <end name="end"/>
</workflow-app>

oozie job log
2018-06-19 10:12:10,615 WARN SqoopActionExecutor:523 - SERVER[study] USER[root] GROUP[-] TOKEN[] APP[sqoop-import-wf] JOB[0000017-180619092621453-oozie-root-W] ACTION[0000017-180619092621453-oozie-root-W@sqoop-node] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

mapreduce job 执行成功了

 Job Name:  oozie:launcher:T=sqoop:W=sqoop-import-wf:A=sqoop-node:ID=0000017-180619092621453-oozie-root-W
User Name:  root
Queue:  root.root
State:  SUCCEEDED
Uberized:   true
Submitted:  Tue Jun 19 10:11:59 CST 2018
Started:    Tue Jun 19 10:12:07 CST 2018
Finished:   Tue Jun 19 10:12:08 CST 2018
Elapsed:    1sec
Diagnostics:    
Average Map Time    1sec 

但是oozie 出现了 Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
也没有其他的日志,请问有碰到这样问题的朋友吗
或者怎么去排查这个问题
求大神帮忙

  • 写回答

3条回答 默认 最新

  • dabocaiqq 2018-06-19 15:47
    关注
    评论

报告相同问题?

悬赏问题

  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的
  • ¥15 r语言蛋白组学相关问题
  • ¥15 Python时间序列如何拟合疏系数模型