Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oozie Execution Error

Highlighted

Oozie Execution Error

Explorer

I have created the external table in hive and created the script.hql file to load the data from hdfs to hive

"LOAD DATA INPATH '/tmp/hive-input/test/nmg.csv' OVERWRITE INTO TABLE nmg;"

Then created the workflow.xml file

I have created the job.properties file in root like this

nameNode=hdfs://sandbox.hortonworks.com:8020 jobTracker=http://ip-10-0-0-51:8050 queueName=default exampleRoot=example oozie.use.system.libpath=true oozie.libpath=/user/oozie/share/lib oozie.wf.application.path=${nameNode}/tmp/oozie-hive inputPath=${nameNode}/tmp/hive-input/test/*

The file which i am loading to hive is store the following HDFS folder(/tmp/hive-input/test/nmg.csv)

Then i am running the hive with oozie,

oozie job -oozie http://ip-10-0-0-51:11000/oozie -config job.properties -run

but i got error, please help me to resolve this error.

3 REPLIES 3
Highlighted

Re: Oozie Execution Error

Expert Contributor

Can you put in the error stack here? Looks like the error did not come through yet .

Highlighted

Re: Oozie Execution Error

Explorer

In have some problem in my server, so i am not able to get the log files. I will share u soon.

Highlighted

Re: Oozie Execution Error

Explorer

When i am running the oozie with hive, it automatically suspended and shows the following error

"JA006: Call From sandbox.hortonworks.com//ip-10-0-0-51to sandbox.hortonworks.com:10020 failed on connection exception: java.net.ConnectException: Connection refused; For more details see: http://wiki.apache.org/hadoop/ConnectionRefused" please help me to resolve this error.

Don't have an account?
Coming from Hortonworks? Activate your account here