title: Spark SQL filter multiple fields
body: <p>What is the corrent syntax for filtering on multiple columns in the Scala API? If I want to do something like this:</p>
  
  <pre><code>dataFrame.filter($"col01" === "something" &amp;&amp; $"col02" === "something else")
  </code></pre>
  
  <p>or</p>
  
  <pre><code>dataFrame.filter($"col01" === "something" || $"col02" === "something else") 
  </code></pre>
  
  <p>EDIT:</p>
  
  <p>This is what my original code looks like. Everything comes in as a string. </p>
  
  <pre><code>df.select($"userID" as "user", $"itemID" as "item", $"quantity" cast("int"), $"price" cast("float"), $"discount" cast ("float"), sqlf.substring($"datetime", 0, 10) as "date", $"group")
    .filter($"item" !== "" &amp;&amp; $"group" !== "-1")
  </code></pre>