I am trying to update the value of a record using spark sql in spark shell
I get executed the command Update tablename set age=20 where name=justin, and I am getting the following errors
scala> val teenagers = sqlContext.sql("UPDATE people SET age=20 WHERE name=Justin") java.lang.RuntimeException: [1.1] failure: ``with'' expected but identifier UPDATE found
UPDATE people SET age=20 WHERE name=Justin
^ at scala.sys.package$.error(package.scala:27)
at org.apache.spark.sql.catalyst.AbstractSparkSQLParser.parse(AbstractSparkSQLParser.scala:36) ......
|
Thanks
Sridhar