Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

String to array

avatar
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

avatar