Hi,
I am new bee to Spark and using Spark 1.5.2 version.
I am trying to connect to Oracle DB using Spark API,getting errors :
Steps I followed :
Step 1- I placed the ojdbc6.jar in
/usr/hdp/2.3.4.0-3485/spark/lib/ojdbc6.jar
Step 2- Registered the jar file
sc.addJar("/usr/hdp/2.3.4.0-3485/spark/lib/ojdbc6.jar")
16/02/10 04:27:55 INFO SparkContext: Added JAR
/usr/hdp/2.3.4.0-3485/spark/lib/ojdbc6.jar at
http://xxx.xx.xx.xx:37460/jars/ojdbc6.jar with timestamp 1455096475089
Step 3 :
val loanDepo = sqlContext.load("jdbc", Map("driver" ->
"oracle.jdbc.driver.OracleDriver","url" ->
"jdbc:oracle:thin:@xx.xxx.xxx.xx:1521:dbanme","dbtable"
-> "testtable","user"->"username", "password"->"password"))
> warning: there were 1 deprecation warning(s); re-run with -deprecation for
> details
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
> at
> scala.tools.nsc.interpreter.AbstractFileClassLoader.findClass(AbstractFileClassLoader.scala:83)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
> at
> org.apache.spark.sql.execution.datasources.jdbc.DriverRegistry$.register(DriverRegistry.scala:38)
> at
> org.apache.spark.sql.execution.datasources.jdbc.DefaultSource.createRelation(DefaultSource.scala:41)
> at
> org.apache.spark.sql.execution.datasources.ResolvedDataSource$.apply(ResolvedDataSource.scala:125)
> at org.apache.spark.sql.DataFrameReader.load(Dat
would really appreciate if somebody point me the errors with above
steps/pointers to correct steps.
Thanks,
Divya
