python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - starburst

Cast JSON to varchar with Trino

I'm trying to cast JSON object from table column to varchar with Trino I tried with these docs here but every time throws an error. https://trino.io/docs/current/functions/json.html If someone can pos...
test-img

Borislav Blagoev

sql

json

presto

trino

starburst

Votes: 0

Answers: 1

Latest Answer

Use json_format/json_parse to handle json object conversions instead of casting: select json_parse('{"property": 1}') objstring_to_json, json_format(json '{"property": 2}') jsonobj...
test-img

Guru Stron

Posts

Questions

Blogs

Jobs