Re: Operator push down through JDBC driver

2016-10-25 Thread AnilKumar B
I thought, we can use sqlContext.sql("some join query") API with jdbc, that's why I have asked the above question. But as we can only use sqlContext.read().format("jdbc").options(options).load() and here we can use actual join query of ORACLE source. So this question is not valid. Please ignore

Operator push down through JDBC driver

2016-10-25 Thread AnilKumar B
Hi, I am using Spark SQL to transform data. My Source is ORACLE, In general, I am extracting multiple tables and joining them and then doing some other transformations in Spark. Is there any possibility for pushing down join operator to ORACLE using SPARK SQL, instead of fetching and joining in S