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.
Please take a look at this thread for a response: