question Re: I am trying to insert into HIVE table through spark-sql and it fails.. Any help ? in Support Questions

I am trying to insert into HIVE table through spark-sql and it fails.. Any help ?

rakanchi — Fri, 30 Jun 2017 18:58:33 GMT

Below is the query I am using.

scala> sqlContext.sql("insert into table results_test_hive values('XXXXXXXXXX', 'm:X', 0.0)")

Failed with below error, org.apache.spark.sql.AnalysisException: Unsupported language features in query: insert into table results_test_hive values('XXXXXXXXXX', 'm:X', 0.0)

Re: I am trying to insert into HIVE table through spark-sql and it fails.. Any help ?

nyadav — Fri, 30 Jun 2017 19:36:35 GMT

@rakanchi

Spark currently doesn't support "insert into feature", you need to create dataframe and append to the table.

var data = sqlContext.createDataFrame(Seq(("ZZ", "m:x", 34.0))).toDF("pv", "metric", "value") 
data.show() 
data.write.mode("append").saveAsTable("results_test_hive") 
println(sqlContext.sql("select * from results_test_hive").count())