String to array

[#1]

Hello,

This is my problem, I have a string columns with values that are separated by ';' , and I want to see it as an array using cast. Here is what I want to do:

select cast("hello;how;are;you" as ARRAY(separated by ";"));

It is possible to do this?, I'm using Impala 2.5 on CDH 5.7.

Regards,

[#2]

Please take a look at this thread for a response:

http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Comma-delimited-string-to-individual-ro...