External Tables for Nested JSON with Trino
To process JSON files we have in our Min.IO data lake, we wanted to create an external table with our Trino (formerly named PrestoSQL) instance. Often, JSON contains nested fields with arrays and objects. Although Trino uses Hive Metastore for storing the…