Hi community!
I have an external snowflake source with JSON column that is stored in varchar in Dremio. I have converted the column and saved the table as a virtual dataset. When I try to get the record from json struct I get the nullpointer exception
Any thoughts on this?
@Greeengooo If you take one record as sample then save as a text under a CSV file, add it to Dremio, then do convert_fromjson(’<json_string>’), like example below, does it give an NPE, trying to narrow down if this is something specific to the Snowflake connector
select convert_fromjson('[{"name":"edberg","rank":1},{"name":"becker","rank":2}]')