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.

Error while submitting pig job using oozie workflow

Highlighted

Error while submitting pig job using oozie workflow

Explorer

I have created cluster on azure HDInsight .I have created instance of oozie .

I want to execute pig script using OOZIE.

I have created workflow for executing pig job.But while submitting workflow it throws an error.

Here i am describing the steps i have performed.

15133-1.png

15140-2.png

15135-3.png

15136-4.png

15139-6.png

3 REPLIES 3
Highlighted

Re: Error while submitting pig job using oozie workflow

Guru

Hello @priyal patel,

Please make sure that your Oozie server is running and reachable while you are submitting this workflow.

It will be tough to tell the issue without knowing the exact error you are getting. To see the real error, go to your browser's Console > Network section. Then click on 'Submit' again in the workflow UI. You should see request and response in the Network console. That is where you'll find the error. Please paste those request and response here.

Hope this helps !

Highlighted

Re: Error while submitting pig job using oozie workflow

Explorer

Browser's Console

15167-console.png

https://hdpcluster1.azurehdinsight.net/api/v1/views/Workflow%20Manager/versions/1.0.0/instances/WF/r... Failed to load resource: the server responded with a status of 400 (Bad Request)

15168-consle3.png

POST https://hdpcluster1.azurehdinsight.net/api/v1/views/Workflow%20Manager/vers…temLibPath=true&ooziecon... 400 (Bad Request)

Here is the network section screen shot,

15169-console1.png

I have created instance of OOZIE workflow manager in ambari

but while clicking on quick links of oozie,

15174-o2.png

while clicking on oozie web UI , it throws error

15175-o3.png

Highlighted

Re: Error while submitting pig job using oozie workflow

Explorer

This is my workflow.xml File,

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<workflow-app xmlns="uri:oozie:workflow:0.5" name="PigNewjob">

<start to="pig"/>

<action name="pig">

<pig>

<job-tracker>${resourceManager}</job-tracker>

<name-node>${nameNode}</name-node>

<configuration>

<property> <name>hive.metastore.uris</name>

<value>thrift://hn0-hdpclu.0ntyjy32iorefkwgx2lgsv5fqc.ix.internal.cloudapp.net:9083,thrift://hn1-hdpclu.0ntyjy32iorefkwgx2lgsv5fqc.ix.internal.cloudapp.net:9083</value>

</property>

</configuration>

<script>/Oozie/PigScript/salaryscript-2017-05-06_12-10-15_731.pig</script>

<file>/Oozie/PigScript/salaryscript-2017-05-06_12-10-15_731.pig</file>

</pig>

<ok to="end"/>

<error to="kill"/>

</action>

<kill name="kill">

<message>${wf:errorMessage(wf:lastErrorNode())}</message>

</kill>

<end name="end"/>

</workflow-app>

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