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

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

Hi Team, We have lots of complex oracle views ( containing multiple tables, joins, analytical and aggregate functions, sub queries etc) and we are wondering if Spark can help us execute those views faster. Also we want to know if those complex views can be implemented using Spark SQL? Thanks an