Re: [Spark SQL]: Can complex oracle views be created using Spark SQL

Hi, I did some investigation on this and created a dataframe on top of the underlying view in Oracle database. Let assume that our oracle view is just a normal view as opposed to materialized view, something like below where both sales and costs are FACT tables CREATE OR REPLACE FORCE EDITIONABL

Re: [Spark SQL]: Can complex oracle views be created using Spark SQL

Hi Gaurav, What version of Spark will you be using? Have you tried a simple example of reading one of the views through JDBC connection to Oracle yourself HTH view my Linkedin profile *Disclaimer:* Use it at your own risk. Any an