28787
DISCUSSIONS
102102
MEMBERS
3161
ARTICLES
Hello,
I'm doing a simple oozie's workflow with sqqop's action.
this is the xml's code
<workflow-app name="Sqoop" xmlns="uri:oozie:workflow:0.4"> <start to="Sqoop"/> <action name="Sqoop"> <sqoop xmlns="uri:oozie:sqoop-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <command>import --connect jdbc:mysql://10.0.0.221/db --username cloudera --password cloudera --table test -m 1 --target-dir /user/albert</command> </sqoop> <ok to="end"/> <error to="kill"/> </action> <kill name="kill"> <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message> </kill> <end name="end"/> </workflow-app>
When i launch my job with hue or line-command, starts the oozie-launcher.
My oozie laucher, never finish, it is always stay at 95%.
If i kill the job oozie-launcher, starts the oozie-sqoop and it do his work very good.
But i don't understand why the oozie-launcher doesnt' work well!
This is my output
>>> Invoking Sqoop command line now >>> 12280 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration. 12510 [main] INFO org.apache.sqoop.Sqoop - Running Sqoop version: 1.4.4-cdh5.0.1 12640 [main] WARN org.apache.sqoop.tool.BaseSqoopTool - Setting your password on the command-line is insecure. Consider using -P instead. 12748 [main] WARN org.apache.sqoop.ConnFactory - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration. 13131 [main] INFO org.apache.sqoop.manager.MySQLManager - Preparing to use a MySQL streaming resultset. 13131 [main] INFO org.apache.sqoop.tool.CodeGenTool - Beginning code generation 15107 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `test` AS t LIMIT 1 15202 [main] INFO org.apache.sqoop.manager.SqlManager - Executing SQL statement: SELECT t.* FROM `test` AS t LIMIT 1 15206 [main] INFO org.apache.sqoop.orm.CompilationManager - HADOOP_MAPRED_HOME is /opt/cloudera/parcels/CDH-5.0.1-1.cdh5.0.1.p0.47/lib/hadoop-mapreduce 23112 [main] INFO org.apache.sqoop.orm.CompilationManager - Writing jar file: /tmp/sqoop-yarn/compile/ab1d242ba1b3a0869bab06c1eb20c02f/test.jar 23140 [main] WARN org.apache.sqoop.manager.MySQLManager - It looks like you are importing from mysql. 23140 [main] WARN org.apache.sqoop.manager.MySQLManager - This transfer can be faster! Use the --direct 23140 [main] WARN org.apache.sqoop.manager.MySQLManager - option to exercise a MySQL-specific fast path. 23140 [main] INFO org.apache.sqoop.manager.MySQLManager - Setting zero DATETIME behavior to convertToNull (mysql) 23151 [main] INFO org.apache.sqoop.mapreduce.ImportJobBase - Beginning import of test 23232 [main] WARN org.apache.sqoop.mapreduce.JobBase - SQOOP_HOME is unset. May not be able to find all job dependencies. 25731 [main] INFO org.apache.sqoop.mapreduce.db.DBInputFormat - Using read commited transaction isolation Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat Heart beat
Someone can help me?
Thank-you