Skip to main content

Querying from Trino

Trino just like Presto allows you to query table formats like Hudi, Delta and Iceberg tables using connectors. Users do not need additional configurations to work with Apache XTable™ (Incubating) synced tables.

For more information and required configurations refer to:

For hands on experimentation, please follow Creating your first interoperable table to create Apache XTable™ (Incubating) synced tables followed by Hive Metastore to register the target table in Hive Metastore. Once done, please follow the below high level steps:

  1. Start the Trino server manually if you are working with a non-managed Trino service: from the trino-server directory run ./bin/launcher run
  2. From the directory where you have installed trino-cli: login to trino-cli by running ./trino-cli
  3. Start querying the table i.e. SELECT * FROM catalog.schema.table;.
Note:

If you are following the example from Hive Metastore, you can query the Apache XTable™ (Incubating) synced Hudi table from Trino using the below query.

sql
SELECT * FROM hudi.hudi_db.<table_name>;