Hello, we have a dremio to dremio connection in dremio1 we have a table that has array field that for strange reason are recognized as string as show here Dremio to Dremio with array column in table so we want create a new table first converting to array, but the select works but saving with CTA not work, I attach both profiles.
@dch or @balaji.ramaswamy can you help me please?
Hello @balaji.ramaswamy not is not the same, because select works but CTA not work
@dacopan If the CTAS works without the VERBS field being selected then it seems like the limitation,
Does the CTAS work without the CONVERT_FROM_JSON?
If it does, then you can create the table as VERBS as type VARCHAR and then do the convert_from locally?
convert_from(VERBS, 'JSON') AS VERBS