how to write not like queries in spark sql using scala api?
<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>