How to check isEmpty on Column Data Spark scala
<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>