Not able to run Sqoop in Oozie

Lab Support
#1

I’m trying to run few sqoop actions in oozie,
Even when trying for basic sqoop commands like:

sqoop job --list
sqoop list-databases

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

From the video, https://www.youtube.com/watch?v=VlMSWaOnUvs

mysql-connector-java.jar is not present in /user/oozie/share/lib/lib_20180807115631/sqoop/

also getting error while running hive action in oozie
please suggest

#2

Hi @Nathiya,

You can find the MySQL connector JAR at below location on HDFS.

/data/jars/mysql-connector-java-5.1.36-bin.jar

Hope this helps.

Thanks

#3

I am able to run sqoop-list-databases --connect jdbc:mysql://ip-172-31-20-247:3306 --username sqoopuser --password in command line.
but getting error for the same while submitting as OOZIE job in HUE as well as in command line…

tried with /data/jars/mysql-connector-java-5.1.36-bin.jar as well

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

please help me.