sqoop-import --connect jdbc:oracle:thin:@localhost:1521:ORCL --table MOVIEDEMO.CAST --fields-terminated-by '\t' --lines-terminated-by '\n' --username MOVIEDEMO --password welcome1

sqoop-import --connect jdbc:oracle:thin:@localhost:1521:ORCL --username MOVIEDEMO --password welcome1 --query 'select * from moviedemo.cast where $CONDITIONS' --target-dir ${nameNode}/user/oracle/MOVIEDEMO.CAST --m 1 --incremental append --check-column cast_id --last-value 10400

e())}]</message>
    </kill>
    <action name="sqoop-cb9f">
        <sqoop xmlns="uri:oozie:sqoop-action:0.2">
            <job-tracker>${jobTracker}</job-tracker>
            <name-node>${nameNode}</name-node>
        <prepare>
                  <delete path="${nameNode}/user/oracle/MOVIEDEMO.CAST"/>
            </prepare>
        <arg>import</arg>
        <arg>--connect</arg>
        <arg>jdbc:oracle:thin:@localhost:1521:ORCL</arg>
        <arg>--query</arg>
        <arg>'select * from moviedemo.cast where \$CONDITIONS'</arg>
        <arg>--username</arg>
        <arg>MOVIEDEMO</arg>
        <arg>--password</arg>
        <arg>welcome1</arg>
        <arg>--incremental</arg>
        <arg>append</arg>
        <arg>--check-column</arg>
        <arg>cast_id</arg>
        <arg>--last-value</arg>
        <arg>30</arg>
        <arg>-m</arg>
        <arg>1</arg>
        <arg>--target-dir</arg>
        <arg>${nameNode}/user/oracle/MOVIEDEMO.CAST</arg>
        </sqoop>
        <ok to="End"/>
        <error to="Kill"/>
    </action>
    <end name="End"/>
</workflow-app>
histor

sqoop job --create aqua_inc_job -- import --connect jdbc:oracle:thin:@localhost:1521:ORCL --query 'select * from moviedemo.cast where $CONDITIONS' --target-dir ${nameNode}/user/oracle/MOVIEDEMO.CAST --m 1 --incremental append --check-column cast_id

sqoop job --create aqua_imp --meta-connect "jdbc:hsqldb:hsql://localhost:16000/sqoop" -- import --connect jdbc:oracle:thin:@localhost:1521:ORCL --username MOVIEDEMO --password welcome1 --query 'select * from moviedemo.cast where $CONDITIONS' --target-dir ${nameNode}/user/oracle/MOVIEDEMO.CAST --m 1 --incremental append --check-column cast_id

sqoop job --exec aqua_imp --meta-connect jdbc:hsqldb:hsql://localhost:16000/sqoop