title: Remove nulls from an array in SQL
body: <p>Want to remove nulls from an array in hive/sql</p>
  
  <p>for example : array is ['1',null] after converting to string values it should be '1' only.</p>
  
  <p>to split the array I am using below:</p>
  
  <pre><code>concat_ws( ",", array_val)
  
  this gives : 1,null
  
  required output : 1
  </code></pre>
  
  <p>Thanks for the help!</p>