Search results
Federated queries in Trino can access your object storage, your main relational databases, and your new streaming or NoSQL system, all in the same query. Trino completely changes what is possible in this central data consumption layer.
Trino is a distributed query engine that processes data in parallel across multiple servers. There are two types of Trino servers, coordinators and workers. The following sections describe these servers and other components of Trino’s architecture. Cluster# A Trino cluster consists of a coordinator and many workers.
Overview. Trino is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources. Use cases. Trino concepts.
Trino concepts. Installation. Deploying Trino. Trino in a Docker container. Trino on Kubernetes with Helm. RPM package. Improve query processing resilience. Clients. Command line interface.
What Trino is not. Since Trino is being called a database by many members of the community, it makes sense to begin with a definition of what Trino is not. Do not mistake the fact that Trino understands SQL with it providing the features of a standard database.
May 31, 2023 · If you check the Trino documentation, it starts with a definition of what Trino isn’t. But we’ll start with what Trino is: a distributed SQL query engine written in Java. If you have a SQL query, Trino can process and run it on an extremely wide variety of data sources and return a result to you that you’d expect from that SQL query.
Trino is an ANSI SQL compliant query engine. This standard compliance allows Trino users to integrate their favorite data tools, including BI and ETL tools with any underlying data source. Trino validates and translates the received SQL statements into the necessary operations on the connected data source.
External resources. SQL at Any Scale, on Any Storage, in Any Environment. Monthly newsletter on Trino and surrounding technologies. Trino is a high performance, distributed SQL query engine for big data.
Trino requires a 64-bit version of Java 22, with a minimum required version of 22.0.1 and a recommendation to use the latest patch version. Earlier major versions such as Java 8, Java 11, Java 17 or Java 21 do not work. Newer versions such as Java 23 are not supported – they may work, but are not tested.
Trino also supports complex aggregations using the GROUPING SETS, CUBE and ROLLUP syntax. This syntax allows users to perform analysis that requires aggregation on multiple sets of columns in a single query.
