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
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