刚安装配置好oozie服务,测试以下的oozie调度hive脚本加载数据到表里面,报Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [40000],根据以下脚本及执行步骤分析问题及解决问题。
1、job.properties脚本:
nameNode=hdfs://192.168.240.138:8020
jobTracker=192.168.240.138:8032
queueName=default
examplesRoot=user/root/oozie/hive/hive_action
oozie.use.system.libpath=true
oozie.wf.application.path=${nameNode}/${examplesRoot}/workflow.xml
2、workflow.xml脚本:
3、hive的脚本insert.sql:
insert into student(id,name) values(1,‘zhangsan’);
4、上传到hdfs并执行命令:
oozie job -oozie http://hadoop05:11000/oozie -config ./job.properties -run