Maybe you do not have access to the table/view. Incase of a view it could be also that you do not have access to the underlying table. Have you tried with another sql tool to access it?
> On 11. Feb 2018, at 03:26, Lian Jiang <jiangok2...@gmail.com> wrote: > > 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!
