- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Oozie sqoop action Error
- Labels:
-
Apache Oozie
-
Apache Sqoop
Created ‎08-24-2016 09:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to import a oracle table data using sqoop action in oozie. I am getting error as
WARN SqoopActionExecutor:523 - SERVER[****] USER[hadoop] GROUP[-] TOKEN[] APP[sample-wf] JOB[0000134-160802050043050-oozie-oozi-W] ACTION[0000134-160802050043050-oozie-oozi-W@source2landingZone] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
Below is my workflow.xml.
<workflow-app name="sample-wf" xmlns="uri:oozie:workflow:0.1"> <start to="source2landingZone"/> <action name="source2landingZone"> <sqoop xmlns="uri:oozie:sqoop-action:0.2"> <job-tracker>${jobTracker}</job-tracker> <name-node>${nameNode}</name-node> <command>sqoop import --connect jdbc:oracle:thin:@//****:1521/orcl --username *** --password *** --table TEST_SQOOP --target-dir /user/hadoop/generic/test55 -m 1</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>
Created ‎09-07-2016 10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Issue got resolved after copying the file ojdbc6.jar in hdfs, path /user/oozie/share/lib/lib_<ts>/sqoop/ojdbc6.jar.
Then I restarted the yarn RM. Thanks for your help.
Created ‎08-24-2016 07:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have Oracle drive in Sqoop directory? Check /usr/hdp/current/sqoop-client/lib/. If it's not there, pease put it here in classpath.
Created ‎08-25-2016 05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@mqureshi I dont have any such directory as /usr/hdp/current/sqoop-client/lib/. But I am able to import data from oracle database using sqoop. Problem starts while I am trying to do same using oozie sqoop action.
Created ‎08-25-2016 06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Then can you please share more from oozie logs? /var/log/oozie?
Created ‎09-05-2016 04:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make sure you add oracle jdbc driver to the sqoop sharelib in HDFS (find the current sharelib location using 'oozie admin -sharelibliblist sqoop' - For older installations (pre HDP -2.2) you can add the file to /user/oozie/share/lib/sqoop directory
Make sure you either call oozie admin -sharelibupdate or restart oozie after that
Created ‎09-07-2016 10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Issue got resolved after copying the file ojdbc6.jar in hdfs, path /user/oozie/share/lib/lib_<ts>/sqoop/ojdbc6.jar.
Then I restarted the yarn RM. Thanks for your help.
Created ‎09-08-2016 05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Why would you restart the RM for this?
