Support Questions
Find answers, ask questions, and share your expertise

Error while connecting Oracle DB using spark in HDP 3.0.1

Error while connecting Oracle DB using spark in HDP 3.0.1

I am running the below code to load oracle data to hive but I am getting the error mentioned below.

spark-submit --driver-class-path /app/ojdbc5.jar /app/raci.py


Driver stacktrace: 18/09/27 16:30:47 INFO DAGScheduler: Job 0 failed: saveAsTable at NativeMethodAccessorImpl.java:0, took 5.097862 s 18/09/27 16:30:47 ERROR FileFormatWriter: Aborting job null. org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 0.0 failed 4 times, most recent failure: Lost task 0.3 in stage 0.0 (TID 3, hadoopslave2, executor 1): java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

Don't have an account?