Member since
07-09-2024
1
Post
0
Kudos Received
0
Solutions
07-30-2024
08:19 AM
@Maicat You can not typecast array to the string. There are 2 ways you can use 1. Select the nth object of the array. SELECT level5[0] AS first_genre FROM my_table; WHere 0 is the first object 2. You can flatten it SELECT column1 FROM my_table LATERAL VIEW explode(level5) genre_table AS level5;
... View more