title: How to get the distinct elements in an array in hive
body: <p>I have a table with one column of type <code>array&lt;bigint&gt;</code> with dynamic size for each row. 
  example :</p>
  
  <pre><code>          1  [100,200] 
            2  [100,300,500,600]
            3  [200,300]
  </code></pre>
  
  <p>The result should be distinct values from this column of array which should be </p>
  
  <pre><code>100
  200
  300
  500
  600
  </code></pre>