How to Run a Select statement from SPARK for an oracle table

Asked Sep 22 '20 at 19:04

Active Sep 22 '20 at 21:03

Viewed 457 times

I am trying to run below statement in spark to unload data from oracle using select statement...

val query_result = spark.read.format("jdbc")
           .option("url", "jdbc:oracle:thin:@****:****:****")
           .option("user", "user1").option("password", "****")
           .option("query", "SELECT * FROM TABLE")
           .option("driver", "oracle.jdbc.driver.OracleDriver")
           .option("inferSchema", "true")
           .load()

But i was getting below error

java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

edited Sep 22 '20 at 21:03

mazaneicha

8,794
4
33
52

asked Sep 22 '20 at 19:04

Naveen Kumar

look like your query is invalid – chlebek Sep 22 '20 at 20:29
1

Maybe this will help: https://stackoverflow.com/questions/24580780/ora-00907-missing-right-parenthesis – mazaneicha Sep 22 '20 at 21:06

How to Run a Select statement from SPARK for an oracle table

0 Answers0