title: Spark dataframe negate filter conditions
body: <p>I am trying apply a negation of filter condition on the DataFrame as shown below.</p>
  
  <pre><code>!(`Ship Mode` LIKE '%Truck%')
  </code></pre>
  
  <p>Which is throwing an exception below</p>
  
  <pre><code>Exception in thread "main" java.lang.RuntimeException: [1.3] failure: identifier expected
  
  (!(`Ship Mode` LIKE '%Truck%'))
    ^
      at scala.sys.package$.error(package.scala:27)
      at org.apache.spark.sql.catalyst.SqlParser.parseExpression(SqlParser.scala:47)
      at org.apache.spark.sql.DataFrame.filter(DataFrame.scala:748)
      at Main.main(Main.java:73)
  </code></pre>
  
  <p>Where as the same kind of negative filter conditions are working fine in MySQL. Please find below</p>
  
  <pre><code>mysql&gt; select count(*) from audit_log where !(operation like '%Log%' or operation like '%Proj%');
  +----------+
  | count(*) |
  +----------+
  |      129 |
  +----------+
  1 row in set (0.05 sec)
  </code></pre>
  
  <p>Can anyone please let me know if this is planned to be fixed in Spark DataFrames in future releases or should I raise a JIRA.</p>