question Re: Unable to save data from Spark into Hive in Archives of Support Questions (Read Only)

Unable to save data from Spark into Hive

wael_horchani1 — Thu, 05 Jan 2017 01:34:47 GMT

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,

nbalaji-elangov — Thu, 05 Jan 2017 02:00:05 GMT

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.

wael_horchani1 — Thu, 05 Jan 2017 02:29:08 GMT

Now it works fine thank you.