spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jörn Franke <jornfra...@gmail.com>
Subject Re: Spark cannot find tables in Oracle database
Date Sun, 11 Feb 2018 09:22:21 GMT
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 <jiangok2006@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!

Mime
View raw message