title: PostgresSQL bool_or equivalent in Spark
body: <p>I'm trying to convert a PostgreSQL query to spark   </p>
  
  <pre class="lang-sql prettyprint-override"><code> select 
      bool_or(case when col_1 is null then false else true end),
      bool_or(col_2)
   from fct_table
  </code></pre>
  
  <p>Below is the dataframe I am trying to work with that has col_1 and col_2:</p>
  
  <pre><code>val df = spark.table("fct_table")
  df.agg(
  bool_or(when(col("col_1") isNull,false).otherwise(true))
  bool_or("col_2")
  )
  </code></pre>
  
  <p>I'm doing this in scala and bool_or is not an aggregate function.
  Any help is appreciated.</p>