title: how to write not like queries in spark sql using scala api?
body: <p>I want to convert the following query to Spark SQL using Scala API:</p>
  
  <pre class="lang-sql prettyprint-override"><code>select ag.part_id name from sample c join testing ag on c.part=ag.part and concat(c.firstname,c.lastname) not like 'Dummy%' 
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks in advance</p>