Re: Spark on Oracle available as an Apache licensed open source repo

2022-01-14 Thread Harish Butani
Look at the pushdown plans for all the TPCDS queries here We push Joins, Aggregates, Windowing etc, as I said we can do complete pushdown of 95 of 99 TPCDS queries. The Generic JDBC Datasource push single table scans, filters and

Re: Spark on Oracle available as an Apache licensed open source repo

2022-01-14 Thread Mich Talebzadeh
Hello, Thanks for this info. Have you tested this feature on Oracle on-premise say, 11c, 12c besides ADW in Cloud? I can see the transactional feature useful in terms of commit/rollback to Oracle but I cannot figure out the performance gains in your blog etc. My concern is we currently connect

Spark on Oracle available as an Apache licensed open source repo

2022-01-13 Thread Harish Butani
Spark on Oracle is now available as an open source Apache licensed github repo . Build and deploy it as an extension jar in your Spark clusters. Use it to combine Apache Spark programs with data in your existing Oracle databases without expensive data