I've the DDL as below.
Create or replace table test
(
prices ARRAY<STRUCT<Ord:STRING:,Vndr:STRING,Prc:STRING>>
)
using delta
location "path"
Now I want to flatten the JSON and I've tried as below but it's throwing an error, "[UNRESOLVED.COLUMN.WITH_SUGGESTION]'
select explode(output.prices) as prices
from table
If I use 'select prices.ord from table' then I see the value as ["5"] with square brackets. I don't want to see the square brackets in the result.
Any help?