I have written a Sqoop import script to import data from teradata to hive. It's 
working fine when I run it from command line ,but when I put it in Oozie 
workflow and try to execute through oozie I get the below error



2015-04-02 08:50:55,440  INFO ActionEndXCommand:539 - USER[qjdht93] 
GROUP[-TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@sqoop-shell] end executor for wf 
action 0000069-150114201015959-oozie-oozi-W with wf job 
0000069-150114201015959-oozie-oozi-W
2015-04-02 08:50:55,459  INFO ActionEndXCommand:539 - USER[qjdht93] GROUP[-] 
TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@sqoop-shell] ERROR is considered as 
FAILED for SLA
2015-04-02 08:50:55,505  INFO ActionStartXCommand:539 - USER[qjdht93] GROUP[-] 
TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@fail] Start action 
[0000069-150114201015959-oozie-oozi-W@fail] with user-retry state : 
userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2015-04-02 08:50:55,505  WARN ActionStartXCommand:542 - USER[qjdht93] GROUP[-] 
TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@fail] 
[***0000069-150114201015959-oozie-oozi-W@fail***]Action status=DONE
2015-04-02 08:50:55,505  WARN ActionStartXCommand:542 - USER[qjdht93] GROUP[-] 
TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@fail] 
[***0000069-150114201015959-oozie-oozi-W@fail***]Action updated in DB!
2015-04-02 08:50:55,522  INFO ActionEndXCommand:539 - USER[qjdht93] GROUP[-] 
TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[0000069-150114201015959-oozie-oozi-W@fail] end executor for wf action 
0000069-150114201015959-oozie-oozi-W with wf job 
0000069-150114201015959-oozie-oozi-W
2015-04-02 08:50:55,556  WARN CoordActionUpdateXCommand:542 - USER[qjdht93] 
GROUP[-] TOKEN[] APP[sqoop-shell-wf] JOB[0000069-150114201015959-oozie-oozi-W] 
ACTION[-] **E1100: Command precondition does not hold before execution, [, 
coord action is null], Error Code: E1100**`


Below is my workflow.xml

<workflow-app name="sqoop-to-hive" xmlns="uri:oozie:workflow:0.4">

    <start to="sqoop2hive"/>

    <action name="sqoop2hive">

        <sqoop xmlns="uri:oozie:sqoop-action:0.2">

            <job-tracker>${jobTracker}</job-tracker>

            <name-node>${nameNode}</name-node>

            <command>import --connect 
"jdbc:teradata://server.co/database=TS"--driver 
Com.teradata.jdbc.TeraDriver--username sqoop --password sqoop --table test 
--hive-import --hive-  table test</command>

             <archive>tdgssconfig.jar</archive>

            <archive>terajdbc4.jar</archive>

            <file>hive-site.xml</file>

        </sqoop>

        <ok to="end"/>

        <error to="kill"/>

    </action>

    <kill name="kill">

        <message>Action failed</message>

    </kill>

    <end name="end"/>

</workflow-app>

Please suggest

Regards,
Chhaya

Reply via email to