title: hive sql transform big int array to string array
body: <p>I am trying to convert an array of big ints into string array in hive SQL</p>
  
  <p>I've tried using </p>
  
  <pre><code>concat_ws
  </code></pre>
  
  <p>but that gave me an error</p>
  
  <pre><code>Argument 2 of function CONCAT_WS must be "string or array&lt;string&gt;", but "array&lt;bigint&gt;" was found.
  </code></pre>
  
  <p>I tried using </p>
  
  <pre><code>transform(mycolumn) using '/bin/cat' as mycolumn_as_string
  </code></pre>
  
  <p>It gives an error of</p>
  
  <pre><code> cannot recognize input near 'transform' '(' 'mycolumn' in selection target
  </code></pre>
  
  <p>How can I convert this bigint array into an array string?</p>