Read string as array<string> in hive sql

Question

I am working on hive, reading some fields from JSON string through hive query. One field in JSON string is actually an array of string but stored as string like {... , 'arrText' : '["a","b","c"]',... }

I want to read this string as array of string in hive query itself.

hive (joshua)> 
              > select some_function('["a","b","c"]');
OK
["a","b","c"]
Time taken: 0.134 seconds, Fetched: 1 row(s)

Can I have something (hive built in) in place of some_function & get it done rather than writing UDF for it?

Thanks in advance

Swapnil Chougule · Accepted Answer · 2020-06-20 11:00:58Z

3

One way to do it without udf is use some pre-defined hive functions like split, regex extract etc

select split(regexp_extract('["a","b","c"]','^\\["(.*)\\"]$',1),'","');
=> ["a","b","c"]

Even it can handle intermediate commas

select split(regexp_extract('["a","b,c","d"]','^\\["(.*)\\"]$',1),'","');
=> ["a","b,c","d"]

Hop it helps

answered Jun 20, 2020 at 11:00

Swapnil Chougule

7359 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read string as array<string> in hive sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related