title: How to check isEmpty on Column Data Spark scala
body: <p>My data looks like :</p>
  
  <pre><code>[null,223433,WrappedArray(),null,460036382,0,home,home,home]
  </code></pre>
  
  <p>How do I check if the col3 is empty on query in spark sql ? I tried to explode but when I do that the empty array rows are disappearing. Can some suggest me a way to do this. </p>
  
  <p>I tried :</p>
  
  <pre><code>val homeSet = result.withColumn("subscriptionProvider", explode($"subscriptionProvider"))
  </code></pre>
  
  <p>where <code>subscriptionProvider(WrappedArray())</code> is the column having array of values but some arrays can be empty. I need to get the subscriptionProvider with null values and subscriptionProvider array has "Comcast" </p>