Trino: The Definitive Guide: SQL at Any Scale, on Any Storage, in Any Environment

by Matt Fuller, Manfred Moser, Martin Traverso, Rachel Roumeliotis

Overview

Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. In the second edition of this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's a data lake using Hive, a modern lakehouse with Iceberg or Delta Lake, a different system like Cassandra, Kafka, or SingleStore, or a relational database like PostgreSQL or Oracle.

Analysts, software engineers, and production engineers learn how to manage, use, and even develop with Trino and make it a critical part of their data platform. Authors Matt Fuller, Manfred Moser, and Martin Traverso show you how a single Trino query can combine data from multiple sources to allow for analytics across your entire organization.

• Explore Trino's use cases, and learn about tools that help you connect to Trino for querying and processing huge amounts of data
• Learn Trino's internal workings, including how to connect to and query data sources with support for SQL statements, operators, functions, and more
• Deploy and secure Trino at scale, monitor workloads, tune queries, and connect more applications
• Learn how other organizations apply Trino successfully

Product Details

ISBN-13:	9781098137236
Publisher:	O'Reilly Media, Incorporated
Publication date:	11/08/2022
Edition description:	2nd ed.
Pages:	319
Product dimensions:	7.00(w) x 9.19(h) x 0.67(d)

About the Author

Matt Fuller is a co-founder at Starburst Data, the Analytics Anywhere Company. Prior to founding Starburst, Matt was a director of engineering at Teradata, where he worked to build the new Center for Hadoop division within the company. As a major part of this, Matt worked to bring Trino to the enterprise market. Matt has managed a team contributing to the open source Trino project since 2015 and led the internal Trino product roadmap. Starburst was later formed from this team at Teradata.

Before Teradata, Matt was an early engineer at Vertica, where he co-built the query optimizer. Matt is also a Very Large Databases (VLDB) published author and has US patents in the database management systems space.

Manfred Moser is a community advocate, writer, trainer and software engineer at Starburst. Manfred has a long history of developing and advocating open source software. He is an Apache Maven committer, wrote the Hudson book and others, and continues to be active in the open source community and his projects. He is a seasoned trainer and conference presenter for CI/CD, Cloud Native, Agile and other software development tools and processes, having trained well over 20,000 developers for companies including Walmart Labs, Sonatype, and Telus.

His database background includes designing databases and related applications in the RDBMS space and working as business intelligence consultant wrangling thousands of lines of SQL by hand. He is glad he can use Presto now, and is spreading the word about how great Presto is.

Martin Traverso is the cofounder of the Trino Software Foundation and CTO at Starburst Data. Prior to Starburst, Martin worked as a software engineer at Facebook where he saw the need for fast interactive SQL analytics. Martin and three other engineers worked to create what became Trino. Martin led the Trino development team and in the spring of 2013 Trino was rolled out into production, later made opensource in the fall of 2013. Since then, Trino has gained wide adoption both internal and external to Facebook.
Prior to Facebook, Martin was an architect at Proofpoint and Ning, where he led development and architecture design of numerous complex enterprise and social network applications.