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 script for sqoop not valid

SOLVED Go to solution

Oozie script for sqoop not valid

Explorer

Hi ,

   I am trying to execute the oozie script to execute Sqoop command.

I am getting error as

Error: E0701 : E0701: XML schema error, cvc-complex-type.2.4.a: Invalid content was found starting with element 'job-traker'. One of '{"uri:oozie:sqoop-action:0.2":job-tracker}' is expected

 

Here is my code.

 

<?xml version="1.0" encoding="UTF-8"?>
<workflow-app name="sample-wf" xmlns="uri:oozie:workflow:0.1">
<start to="myfirstsqoopjob"/>
    <action name="myfirstsqoopjob">
        <sqoop xmlns="uri:oozie:sqoop-action:0.2">
            <job-traker>${jobTracker}</job-tracker>
            <name-node>${nameNode}</name-node>
            <prepare>
                <delete path="${nameNode}/user/cloudera/data/emp_sal"/>
            </prepare>
            <configuration>
                <property>
                    <name>mapred.compress.map.output</name>
                    <value>true</value>
                </property>
            </configuration>
           <command>sqoop import --connect jdbc:mysql://localhost/test --table emp_sal --username root --password cloudera --target-dir /user/cloudera/data/emp_sal --delete-target-dir -m 1 --fields-terminated-by ',' 
           </command>
        </sqoop>
        <ok to="end"/>
        <error to="fail"/>
    </action>
<kill name="fail">
	<message>Sqoop action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
</kill>
<end name="end"/>
</workflow-app>

what is error here with job tracker line.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Oozie script for sqoop not valid

Cloudera Employee

"sqoop" causes errors in the <command> tag. 

See OOZIE-2816 for some detail

2 REPLIES 2

Re: Oozie script for sqoop not valid

Explorer

I could solve it. Dont know what error but is working fine.

Re: Oozie script for sqoop not valid

Cloudera Employee

"sqoop" causes errors in the <command> tag. 

See OOZIE-2816 for some detail