title: How do we convert a string into Array in hive?
body: <p>I am using hive 1.1</p>
  
  <pre><code> hive&gt; select country from releases limit 1;
   OK
   ["us","ca","fr"]
  </code></pre>
  
  <p>For now country  is of type string in hive . How do I convert that into Array[String]?</p>
  
  <p>I tried the below, but it is throwing error</p>
  
  <pre><code> hive&gt; select country, cast(country as Array[String]) from releases limit 1;
   FAILED: ParseException line 1:48 cannot recognize input near 'Array' '[' 'String' in primitive type specification
  </code></pre>
  
  <p>Can someone help me to do the typecasting?</p>