@Kuldeep Kulkarni thank you for the reply! I don't have the original environment up anymore so I wasn't able to try it myself, but I appreciate the response. I have heard that an additional issue I would have encountered had I resolved the 'Hive shell has been disabled' was the fact that our Hive is configured to use tez execution engine, and as far as I know, sqoop only supports MapReduce. But I think that is a separate issue from the original post here. ... View more

Thanks for your reply, and thanks for link, I will look. Here are versions of the components I'm using: Oozie version: 4.2.0.2.3.4.0-3485 Sqoop version: 1.4.6.2.3.4.0-3485 Hadoop version: 2.7.1.2.3.4.0-3485 And here is the workflow.xml, items in square brackets were things that I removed because they had sensitive information of some sort in them. <workflow-app name="sqoop-report" xmlns="uri:oozie:workflow:0.4"> <start to="sqoop-from-db2"/> <action name="sqoop-from-db2"> <sqoop xmlns="uri:oozie:sqoop-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <configuration> <property> <name>oozie.use.system.libpath</name> <value>true</value> </property> </configuration> <arg>import</arg> <arg>--connect</arg> <arg>[JDBC URL]</arg> <arg>-m</arg> <arg>1</arg> <arg>--username</arg> <arg>[DB2 USERNAME]</arg> <arg>--password-file</arg> <arg>[PASSWORD FILE]</arg> <arg>--target-dir</arg> <arg>[TARGET DIR]</arg> <arg>--hive-table</arg> <arg>[TARGET TABLE]</arg> <arg>--hive-import</arg> <arg>--query</arg> <arg>[FREE FORM SQL]</arg> </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> ... View more

Sorry for the repeated text in title and detail. ... View more