Created on 05-30-2016 12:23 PM - edited 08-19-2019 04:40 AM
He is my job. properties and workflow.xml
job.properties
nameNode=hdfs://sandbox.hortonworks.com:8020
jobTracker=sandbox.hortonworks.com:8050
queueName=default
examplesRoot=examples
oozie.use.system.libpath=true
oozie.libpath=${nameNode}/user/${user.name}/share/lib
oozie.wf.application.path=${nameNode}/user/${user.name}/${examplesRoot}/apps/sqoop/
here is my workflow.xml
<workflow-app name="sqoop-hbase-wf" xmlns="uri:oozie:workflow:0.4">
<start to="sqoop-import"/>
<action name="sqoop-import">
<sqoop xmlns="uri:oozie:sqoop-action:0.2">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<job-xml>/user/root/hbase-site.xml</job-xml>
<command>import --connect "jdbc:sqlserver://ip:port;database=ESP" --table bundle_plan_package --username omkar --password tarpass --incremental append --check-column packageid --hbase-table bundle_plan_package --column-family bundleid</command>
<file>/user/root/sqljdbc4.jar#sqljdbc4.jar</file>
<file>/user/root/hbase/hbase-client.jar#hbase-client.jar</file>
<file>/user/root/hbase/hbase-common.jar#hbase-common.jar</file>
<file>/user/root/hbase/hbase-protocol.jar#hbase-protocol.jar</file>
<file>/user/root/hbase/htrace-core-3.1.0-incubating.jar#htrace-core-3.1.0-incubating.jar</file>
<file>/user/root/hbase/hbase-server.jar#hbase-server.jar</file>
<file>/user/root/hbase/hbase-hadoop-compat.jar#hbase-hadoop-compat.jar</file>
<file>/user/root/hbase/high-scale-lib-1.1.1.jar#high-scale-lib-1.1.1.jar</file>
</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>
Created 06-02-2016 11:50 AM
i resolved this by adding hbase/lib metrics-core-2.2.0.jar to /user/root/hbase/ and definer in <file>metrics-core-2.2.0.jar#metrics-core-2.2.0.jar</file>
Created 05-30-2016 06:24 PM
Can you please click on magnifier icon at the end of your console url (middle window in your screenshot), that will take you to resource manager UI --> Then click on Mapper --> logs --> check stderr logs
This looks like classnotfound exception.
Created 06-02-2016 11:50 AM
i resolved this by adding hbase/lib metrics-core-2.2.0.jar to /user/root/hbase/ and definer in <file>metrics-core-2.2.0.jar#metrics-core-2.2.0.jar</file>