title: Delete from Hive table using Spark
body: <p>I am using Hive 1.2.1 and Spark 1.6, and the issue is I am unable to do a simple delete operation in a Hive table using the spark shell. Since hive supports ACID since 0.14, I was hoping it would be allowed in Spark.</p>
  
  <pre><code> 16/01/19 12:44:24 INFO hive.metastore: Connected to metastore.
  
  
   scala&gt; hiveContext.sql("delete from testdb.test where id=2");
  
  
   16/01/19 12:44:51 INFO parse.ParseDriver: Parsing command: delete from    
   testdb.test where id=2
   16/01/19 12:44:52 INFO parse.ParseDriver: Parse Completed
  
   org.apache.spark.sql.AnalysisException:
   Unsupported language features in query: delete from testdb.test where id=2
   TOK_DELETE_FROM 1, 0,12, 12
     TOK_TABNAME 1, 4,6, 12
      testdb 1, 4,4, 12
       test 1, 6,6, 19
       ......
  
   scala.NotImplementedError: No parse rules for TOK_DELETE_FROM:
   TOK_DELETE_FROM 1, 0,12, 12
   TOK_TABNAME 1, 4,6, 12
    testdb 1, 4,4, 12
    ......
  </code></pre>