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?