Re: Oracle Table not resolved [Spark 2.1.1]

2017-08-28 Thread Imran Rajjad
the jdbc url is invalid, but strangely it should have thrown ORA- exception On Mon, Aug 28, 2017 at 4:55 PM, Naga G wrote: > Not able to find the database name. > ora is the database in the below url ? > > Sent from Naga iPad > > > On Aug 28, 2017, at 4:06 AM, Imran Rajjad

Re: Oracle Table not resolved [Spark 2.1.1]

2017-08-28 Thread Naga G
Not able to find the database name. ora is the database in the below url ? Sent from Naga iPad > On Aug 28, 2017, at 4:06 AM, Imran Rajjad wrote: > > Hello, > > I am trying to retrieve an oracle table into Dataset using following code > > String url =

Oracle Table not resolved [Spark 2.1.1]

2017-08-28 Thread Imran Rajjad
Hello, I am trying to retrieve an oracle table into Dataset using following code String url = "jdbc:oracle@localhost:1521:ora"; Dataset jdbcDF = spark.read() .format("jdbc") .option("driver", "oracle.jdbc.driver.OracleDriver") .option("url", url) .option("dbtable",