Spark cannot find tables in Oracle database

[Lian Jiang]

Hi,

I am following
https://spark.apache.org/docs/latest/sql-programming-guide.html#jdbc-to-other-databases
to query oracle database 12.1 from spark shell 2.11.8.

val jdbcDF = spark.read
  .format("jdbc")
  .option("url", "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP)(HOST = 129.106.123.73)(PORT = 1521))(CONNECT_DATA
=(SERVER = DEDICATED)(SERVICE_NAME =
pdb1.subnet1.hadoop.oraclevcn.com)))")
  .option("dbtable", "HADOOP_DEV.SYMBOLINFO")
  .option("user", "hadoop_dev")
  .option("password", "mypassword")
  .load()

This statement failed due to "ORA-00942: table or view does not exist" even
SymbolInfo table does exist in hadoop_dev schema.

Any clue? Thanks!