The easy mistake is to look inside an Iceberg table directory, see .avro files under metadata/, and assume the table data is Avro.

That is not the right mental model.

Iceberg is the table format. Parquet, ORC, and Avro are file formats that an Iceberg table can point to. In a common Trino lakehouse table, Iceberg metadata uses JSON and Avro files, while the actual table rows live in Parquet files.

The main rule:

Trino can feel hard to learn because the execution vocabulary is unfamiliar: coordinator, worker, catalog, connector, split, stage, task, driver, operator, page, block.

The useful way to learn Trino is to follow one query through the system and keep asking the same question:

1. Create schema on target cluster

   We can use show create table to get the create table sql of the table we would like to clone.

   bash

   Read more...

    Hive