Sqoop Action Is Not Working On Oozie Hue Workflow (Doc ID 1913200.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Linux x86-64

Symptoms

Executing a sqoop script from HUE/Oozie workflow fails with below error

mapreduce.client.output.filter=FAILED
------------------------

Sqoop command arguments :
  --options-file
  hive_conf.txt
  --query
  SELECT OWNER, SUBOBJECT_NAME, LAST_DDL_TIME, SUBSTR(SUBOBJECT_NAME, 1, 4), OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TABLE SUBPARTITION' AND OWNER = 'ADWG_GPOS' AND OBJECT_NAME = 'GPOS_CP_FADS' AND SUBSTR(SUBOBJECT_NAME, 1, 4) = '3485' AND \$CONDITIONS ORDER BY LAST_DDL_TIME DESC
  --target-dir
  /user/cm5142/testsqoop
=================================================================

>>> Invoking Sqoop command line now >>>

1912 [main] WARN org.apache.sqoop.tool.SqoopTool - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
Intercepting System.exit(1)

<<< Invocation of Main class completed <<<

Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Oozie Launcher failed, finishing Hadoop job gracefully

Oozie Launcher, uploading action data to HDFS sequence file: hdfs://bdauat-ns/user/cm5142/oozie-oozi/0000102-140707175947287-oozie-oozi-W/test-sqoop--sqoop/action-data.seq

Oozie Launcher ends

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms