title: spark sql query to delete with join conditions
body: <p>I'm trying to delete a table values checking with another table, like</p>
  
  <pre><code>DELETE Table1
  FROM Table1 t1
  INNER JOIN Table2 t2 ON t1.Col1 = t2.Col1
  WHERE t2.Col3 IN ('Two-Three','Two-Four')
  </code></pre>
  
  <p>It is not working as I get the above error <code>Exception</code> in thread "main":</p>
  
  <blockquote>
    <p>java.lang.RuntimeException: [1.1] failure: ``with'' expected but
    identifier DELETE found</p>
  </blockquote>