Support Questions
Find answers, ask questions, and share your expertise

String to array

Contributor

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,

1 REPLY 1

Master Collaborator
; ;