HI All,
we have recently migrated from Spark 1.2.1 to Spark 1.4.0, I am fetching
data from an RDBMS using JDBCRDD and register it as temp table to perform
SQL query

Below approach is working fine in Spark 1.2.1:

JDBCRDD --> apply map using Case Class --> apply createSchemaRDD -->
registerTempTable --> perform SQL Query

but now as createSchemaRDD is not supported in Spark 1.4.0

JDBCRDD --> apply map using Case Class with* .toDF()* --> registerTempTable
--> perform SQL query on temptable


JDBCRDD --> apply map using Case Class --> RDD*.toDF()*.registerTempTable
--> perform SQL query on temptable

Only solution I get everywhere is to  use "import sqlContext.implicits._"
after val SQLContext = new org.apache.spark.sql.SQLContext(sc)

But it errors with the two generic errors

*1. error: not found: value sqlContext*

*2. value toDF is not a member of org.apache.spark.rdd.RDD*

Reply via email to