Unable to save data from Spark into Hive

[#1]

Hi,

Trying to complete Lab 4 (Riskfactor Analysis with Spark), i got the following error for the last instruction:

%spark hiveContext.sql("create table riskfactor as select * from finalresults")

<console>:28: error: not found: value hiveContext

hiveContext.sql("create table riskfactor as select * from finalresults")

^

Any idea please?

Regards,

[#2 · Accepted solution]

Did u run the import and initialization of hive context like below ?

import org.apache.spark.sql.hive.orc._
import org.apache.spark.sql._

val hiveContext = new org.apache.spark.sql.hive.HiveContext(sc)

If you still face issues, check if hive is running.

[#3]

Now it works fine thank you.