title: Spark specify multiple logical condition in where clause of spark dataframe
body: <p>While defining the multiple logical/relational condition in spark scala dataframe getting the error as mentioned below. But same thing is working fine in scala</p>
  
  <p>Python code:</p>
  
  <pre><code>df2=df1.where(((col('a')==col('b')) &amp; (abs(col('c')) &lt;= 1))
   | ((col('a')==col('fin')) &amp; ((col('b') &lt;= 3) &amp; (col('c') &gt; 1)) &amp; (col('d') &lt;= 500))
   | ((col('a')==col('b')) &amp; ((col('c') &lt;= 15) &amp; (col('c') &gt; 3)) &amp; (col('d') &lt;= 200))
   | ((col('a')==col('b')) &amp; ((col('c') &lt;= 30) &amp; (col('c') &gt; 15)) &amp; (col('c') &lt;= 100)))
  </code></pre>
  
  <p>Tried for scala equivalent:</p>
  
  <pre><code>val df_aqua_xentry_dtb_match=df_aqua_xentry.where((col("a") eq col("b")) &amp;  (abs(col("c") ) &lt;= 1))
  </code></pre>
  
  <pre><code> notebook:2: error: type mismatch;
   found   : org.apache.spark.sql.Column
   required: Boolean
  </code></pre>
  
  <pre><code>val df_aqua_xentry_dtb_match=df_aqua_xentry.where((col("a") eq col("b")) &amp;  (abs(col("c") ) &lt;= 1))
  </code></pre>
  
  <p>How to define multiple logical condition in spark dataframe using <code>scala</code></p>