Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

Cloudera Employee

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

See OOZIE-2816 for some detail

View solution in original post

2 REPLIES 2

Explorer

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

Cloudera Employee

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

See OOZIE-2816 for some detail