Trino | Support by cloudimg

Overview

Trino is a fast, distributed SQL query engine designed to run interactive analytic queries over data sources of any size, from gigabytes to petabytes. Formerly known as PrestoSQL, Trino lets you query data where it lives using standard ANSI SQL, joining across many systems in a single query. This image delivers Trino fully installed and configured as a single-node coordinator and worker, with a supported Java 25 runtime bundled in, so a working SQL query engine is running within minutes of launch.

Application Stack

The Trino 481 server installed under /opt/trino and run by a dedicated unprivileged service account. A bundled Eclipse Temurin 25 JRE pinned to the engine so it always runs on the Java version Trino requires. The engine configuration, connector catalogs and node data directory stored on a dedicated data disk so the engine state is independently resizable. A systemd service that starts Trino on boot and restarts it on failure. An nginx reverse proxy that publishes the Web UI, the query REST API and the JDBC and CLI endpoint on port 80 behind HTTP Basic authentication.

Query Engine

Run ANSI SQL through the built-in Web UI, the Trino command line client, your favourite SQL tool over JDBC or the REST API. The image ships the tpch connector with industry standard sample data, the memory connector for writable in-memory tables and the jmx connector for engine metrics, so you can run SELECT, CREATE TABLE and aggregate queries the moment the instance boots. Add connectors for PostgreSQL, MySQL, Apache Iceberg, Hive, ClickHouse, MongoDB, object storage and dozens more by dropping a catalog properties file in the configuration directory.

Secure First Boot

On the first boot of your instance a one shot service generates a fresh admin password, unique to that instance, writes it into the nginx credentials file and writes the password to a root only file. The engine itself binds to loopback only and is never exposed without authentication. No shared or default credentials ship in the image.

Ready To Use

The Trino Web UI is served on port 80 through nginx. Sign in with the generated administrator credentials to watch queries execute, inspect query plans and monitor cluster state. Point your BI tool, dbt project or JDBC application at the instance on port 80 using the same credentials.

cloudimg Support

24/7 technical support by email and chat. Help with deployment, connector and catalog configuration, query tuning, memory and JVM sizing, BI and JDBC integration, and TLS.

Use Cases

Interactive analytics and ad hoc SQL over data lakes. A federated query layer joining across databases, object storage and message systems. The query engine behind dbt, BI dashboards and notebooks. Lakehouse SQL over Apache Iceberg, Delta Lake and Hudi. A drop in successor to a self managed Presto cluster.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.