Oozie script for sqoop not valid

dmishraoc — Fri, 16 Sep 2022 11:16:28 GMT

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.

Re: Oozie script for sqoop not valid

dmishraoc — Fri, 17 Mar 2017 22:49:39 GMT

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

Re: Oozie script for sqoop not valid

gezapeti — Tue, 21 Mar 2017 10:34:59 GMT

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

See OOZIE-2816 for some detail

question Oozie script for sqoop not valid in Archives of Support Questions (Read Only)

Oozie script for sqoop not valid

Re: Oozie script for sqoop not valid

Re: Oozie script for sqoop not valid