title: Find out null from a Struct data type in spark sql
body: <p>I have a employee table where address is of struct data type and some of the values inside struct are null.So how to find out the rows where we dont have a single null with spark sql.I got the answer for a small table where we have two field in the struct with below..but how to find out if we have more than 100 fields in the struct type ..do we want to create udf or any other approch?</p>
  
  <pre><code>df.filter($"address.city".isNotNull and $"address.pin".isNotNull).show()
  </code></pre>
  
  <p>Thanks in advance</p>