Convert Varchar to json Array

1

Hi, the question is pretty simple.
I’m querying a parquet PDS, which has a column that looks like this:

column
empty text
empty text
empty text
'[ { "isActive" : true, "partner" : { "$oid" : "928jf983jf9020" }, "Types" : [ 2.0, 5.0 ], ... },{...}]'

It is a varchar, I want to convert it to a JSON array.

I’ve tried:

select 
CONVERT_FROM(table.column,'JSON') as json_array 
from table

error:

UnsupportedOperationException

What are possible workarounds to this situation?

2

There seems to be some kind of incompatibility with parquet’s text datatype and the JSON converter.
I’ve tried the same thing with dremio’s native text datatype and a CSV PDS, it works fine.
So, the workaround would be to convert the text datatype to dremio’s native (either by binary or whatever)
and then convert it to JSON.

(Oh, and the JSON conversion also doesn’t work for VDS, because when querying a subquery, it cannot know the original SCHEMA).