title: Hive - How to read a column from a table which is of type list
body: <p>I have a Hive table named customer, which has a column named cust_id of list type, with following values:
  <code>cust_id</code></p>
  
  <pre><code>[123,234,456,567]
  
  [345,457,67]    
  
  [89,23,34]    
  </code></pre>
  
  <p>Now I want to read only this specific column cust_id in my select query, which can give all these list values as following separate values of this column cust_id:</p>
  
  <pre><code>cust_id
  
  123
  
  234
  
  456
  
  567
  
  345
  
  457
  
  67
  
  89
  
  23
  
  34
  </code></pre>
  
  <p>Basically I want to fetch all the values of <code>cust_id</code> from this table as one column, to use these values in the where exists or where in clause of my other query. 
  A solution for this would be highly appreciated.</p>