Questions tagged [trino]

Trino stands as a powerful open-source distributed SQL query engine designed to effortlessly handle analytic queries on datasets of any scale, from gigabytes up to petabytes in size. Trino serves as the community-driven iteration of Presto, evolving from the rebranding of the original PrestoSQL codebase.

Generate fresh columns from string columns formatted as JSON

I have a table with a single column that is of string type, but the content resembles a JSON structure. The data in the column looks like this: 'old_id' column with values: [{"name":"Entitas Penugasan","id":"6415","value":"HIJRA"}, {"name":"Function","i ...

sqljsonamazon-athenaprestotrino