How do I create json object in dremio

#1

I would like to be able to create a struct column in dremio. I tried this

select convert_to(name, ‘json’) from
(select ‘steve’ as name) t

I want the output to be like this {“name” : “steve”}. How do I get this please

#2

@fundamentals You have to use convert_from, try the below

select convert_fromJSON('{"name" : "steve"}')

OR

select convert_from('{"name" : "steve"}','JSON')