Re: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

iver properties via --driver-java-options >> >> >> >> Sent from Mail for Windows 10 >> >> >> >> From: Mich Talebzadeh >> Sent: 22 декабря 2016 г. 0:40 >> To: user @spark >> Subject: Has anyone managed to connec

Re: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

Windows 10 > > > > *From: *Mich Talebzadeh > *Sent: *22 декабря 2016 г. 0:40 > *To: *user @spark > *Subject: *Has anyone managed to connect to Oracle via JDBC from Spark > CDH 5.5.2 > > > This works with Spark 2 with Oracle jar file added to > > $SPARK_HOME/co

RE: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

h.talebza...@gmail.com> Sent: 22 декабря 2016 г. 0:40 To: user @spark<mailto:user@spark.apache.org> Subject: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2 This works with Spark 2 with Oracle jar file added to $SPARK_HOME/conf/ spark-defaults.conf spark.dri

Re: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

Hi Mich, Can you try placing these jars in Spark Classpath. It should work . Thanks, Divya On 22 December 2016 at 05:40, Mich Talebzadeh wrote: > This works with Spark 2 with Oracle jar file added to > > $SPARK_HOME/conf/ spark-defaults.conf > > > > > spark.driver.extraClassPath /home/hdu

Re: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

thanks Ayan, do you mean "driver" -> "oracle.jdbc.OracleDriver" we added that one but did not work! Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

Try providing correct driver name through property variable in the jdbc call. On Thu., 22 Dec. 2016 at 8:40 am, Mich Talebzadeh wrote: > This works with Spark 2 with Oracle jar file added to > > > > > > $SPARK_HOME/conf/ spark -defaults.conf > > > > > > > > > > > > > > > spark.driver.extraClassPa

Has anyone managed to connect to Oracle via JDBC from Spark CDH 5.5.2

This works with Spark 2 with Oracle jar file added to $SPARK_HOME/conf/ spark-defaults.conf spark.driver.extraClassPath /home/hduser/jars/ojdbc6.jar spark.executor.extraClassPath/home/hduser/jars/ojdbc6.jar and you get cala> val s = HiveContext.read.format("jdbc").options( |