Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Scoop issue with Oozie


Scoop issue with Oozie



I am trying to import data from teradata to hive using scoop through oozie. Oozie scoop action always fail with error stating that $SQOOP_CONF_DIR is not set.

Error :
2758 [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)

<action name=”generateoffersreport1″>
<sqoop xmlns=”uri:oozie:sqoop-action:0.2″>


<ok to=”emailnotification”/>
<error to=”fail”/>

Shared Libraries inside Oozie:
hadoop fs -ls /user/oozie/share/lib/sqoop
Found 6 items
-rw-r–r– 3 oozie hdfs 163151 2014-10-30 13:47 /user/oozie/share/lib/sqoop/commons-io-2.1.jar
-rw-r–r– 3 oozie hdfs 706710 2014-10-30 13:47 /user/oozie/share/lib/sqoop/hsqldb-
-rw-r–r– 3 oozie hdfs 7890 2014-10-30 13:47 /user/oozie/share/lib/sqoop/oozie-sharelib-sqoop-
-rw-r–r– 3 oozie hdfs 819248 2014-10-30 13:47 /user/oozie/share/lib/sqoop/sqoop-
-rw-r–r– 3 daas hdfs 2405 2015-03-25 22:47 /user/oozie/share/lib/sqoop/tdgssconfig.jar
-rw-r–r– 3 daas hdfs 873860 2015-03-25 22:46 /user/oozie/share/lib/sqoop/terajdbc4.jar

I am not sure where the error is? could you please help on how to resolve it.



Re: Scoop issue with Oozie

Master Guru
Could you share your full failed action log? The WARN about the SQOOP_CONF_DIR can be ignored, and is not the cause of the exit. The real reason is printed likely into the stderr/stdout parts.
Don't have an account?
Coming from Hortonworks? Activate your account here