Re: Spark cannot find tables in Oracle database

Thanks Guys for help! Georg's proposal fixed the issue. Thanks a lot. On Sun, Feb 11, 2018 at 7:59 AM, Georg Heiler wrote: > I had the same problem. You need to uppercase all tables prior to storing > them in oracle. > Gourav Sengupta

Re: Spark cannot find tables in Oracle database

I had the same problem. You need to uppercase all tables prior to storing them in oracle. Gourav Sengupta schrieb am So. 11. Feb. 2018 um 10:44: > Hi, > > since you are using the same user as the schema, I do not think that there > is an access issue. Perhaps you might

Re: Spark cannot find tables in Oracle database

Hi, since you are using the same user as the schema, I do not think that there is an access issue. Perhaps you might want to see whether there is anything case sensitive about the the table names. I remember once that the table names had to be in small letters, but that was in MYSQL. Regards,

Re: Spark cannot find tables in Oracle database

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 wrote: > > Hi, > > I am following >

Spark cannot find tables in Oracle database

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 =