issue while inserting data into hive through spark

[#1]

Not able to insert data into hive table through spark

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)

[#2 · Accepted solution]

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

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

[#3]

@nyadav

Thanks for the information . I was able to insert after creating the dataframe.