Spark JDBC query isn't working for Oracle Databases

User15725630784 — Fri, 14 May 2021 19:26:30 GMT

I am trying to read with the following syntax

val df = spark.read

.format("jdbc")

.option("url", "<url>")

.option("query", "SELECT * FROM oracle_test_table)")

.option("user", "<user>")

.option("password", "<password>")

.option("driver", "oracle.jdbc.driver.OracleDriver")

.load()

df.show()

and am getting the following error

java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

topic Spark JDBC query isn't working for Oracle Databases in Data Engineering