Need demo video for Sqoop Oozie workflow action


Could you please provide the ITversity demo video for Sqoop Oozie workflow action ? Urgent.


Hi Team,
Any updates on this so far ?


@Lakshmi_Priya Currently, there is no video for oozie sqoop action. Can you try below simple Oozie sqoop action.

step1: Create a file as below:

queueName=default oozie.use.system.libpath=true 

step2: Create a workflow.xml file as below:

<action name="sqoop-node">
    <sqoop xmlns="uri:oozie:sqoop-action:0.2">
            <delete path="${nameNode}/user/${wf:user()}/sqoop_script/"/>
        <command>import --connect "jdbc:mysql://" --username retail_user --password itversity --table orders --driver com.mysql.jdbc.Driver --warehouse-dir /user/username/sqoop_script/ -m 1</command>
    <ok to="end"/>
    <error to="fail"/>

<kill name="fail">
    <message>Sqoop failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
<end name="end"/>

step3: Create a directory and copy a workflow.xml, files in your HDFS path:

hdfs dfs -mkdir /user/username/oozie_demo/simple_sqoop_demo
hdfs dfs -copyFromLocal workflow.xml /user/username/oozie_demo/simple_sqoop_demo

step4: Run oozie from local path:

oozie job -oozie -config /home/username/oozie_demo/pig_demo/

step5: verify output from HDFS path:

hdfs dfs -ls /user/username/sqoop_script/


Hi Annapurna,

ITversity uses yarn - resource manager and application master. So will this code work with Jobtracker parameters ?


@Lakshmi_Priya Yes, I tested it. It’s working.