About the Book

Trino: The Definitive Guide is the first and foremost book about the Trino distributed query engine. The book is aimed at beginners and existing users of Trino alike. Ideally, you have some understanding of databases and SQL, but if not, you can divert from reading and look things up while working your way through this book. No matter your level of expertise, we are sure that you’ll learn something new from this book.

The revised edition of the book takes the rename from Presto to Trino—of the codebase, the project, the binaries, and the community around it—into account. It also includes numerous smaller improvements and an update to the latest Trino release.

The first part of the book introduces you to Trino and then helps you get up and running quickly so you can start learning how to use it. This includes installation and first use of the command-line interface as well as many client- and web-based applications, such as SQL database management or dashboard and reporting tools, using the JDBC driver.

The second part of the book advances your knowledge and includes details about the Trino architecture, cluster deployment, many connectors to data sources, and a lot of information about the main power of Trino—querying any data source with SQL.

The third part of the book rounds out the content with further aspects you need to know when running and using a production Trino deployment. This includes Web UI usage, security configuration, and some discussion of real-world uses of Trino in other organizations.

Code Examples, Permissions, and Attribution

Supplemental material for the book is documented in greater detail in “Book Repository”.

If you have a technical question, or a problem using the code examples, please contact us on the community chat—see “Community Chat”—or file issues on the book repository.

This book is here to help you get your job done. In general, if example code is offered with this book, you may use it in your programs and documentation. You do not need to contact us for permission unless you’re reproducing a significant portion of the code. For example, writing a program that uses several chunks of code from this book does not require permission. Selling or distributing examples from O’Reilly books does require permission. Answering a question by citing this book and quoting example code does not require permission. Incorporating a significant amount of example code from this book into your product’s documentation does require permission.

We appreciate, but generally do not require, attribution. An attribution usually includes the title, author, publisher, and ISBN. For example: "Trino: The Definitive Guide by Matt Fuller, Manfred Moser, and Martin Traverso (O’Reilly). Copyright 2021 Matt Fuller, Martin Traverso, and Simpligility Technologies Inc., 978-1-098-10771-0.

If you feel your use of code examples falls outside fair use or the permission given above, feel free to contact us [email protected].

O’Reilly Online Learning

Our unique network of experts and innovators share their knowledge and expertise through books, articles, and our online learning platform. O’Reilly’s online learning platform gives you on-demand access to live training courses, in-depth learning paths, interactive coding environments, and a vast collection of text and video from O’Reilly and 200+ other publishers. For more information, visit http://oreilly.com.

How to Contact Us

Please address comments and questions concerning this book to the publisher:

• O’Reilly Media, Inc.
• 1005 Gravenstein Highway North
• Sebastopol, CA 95472
• 800-998-9938 (in the United States or Canada)
• 707-829-0515 (international or local)
• 707-829-0104 (fax)

We have a web page for this book, where we list errata, examples, and any additional information. You can access this page at https://oreil.ly/TrinoTDG.

Email [email protected] to comment or ask technical questions about this book.

to learn more about our books, courses, and news, visit http://www.oreilly.com.

Find us on Facebook: http://facebook.com/oreilly

Follow us on Twitter: http://twitter.com/oreillymedia

Watch us on YouTube: http://www.youtube.com/oreillymedia

Acknowledgments

We would like to thank everyone in the larger Trino community for using Trino, spreading the word, helping other users, contributing to the project, and even committing to the code or documentation. We are excited to be part of the community and look forward to many shared successes in the future.

A critical part of the Trino community is Starburst. We want to thank everyone at Starburst for their help and really appreciate the work, resources, stability, and support Starburst provides to the project, its customers using Trino, and the authors, who are part of the Starburst team.

Specifically related to the book, we would like to thank everyone who helped us with idea, input, and reviews, including the following, probably incomplete list of people:

Annie Elliott, Anu Sudarsan, Barton Wright, Brian Olsen, Dain Sundstrom, David Phillips, Grzegorz Kokosiński, Jeffrey Breen, Jess Iandiorio, Justin Borgman, Kamil Bajda-Pawlikowski, Karol Sobczak, Kevin Kline, Megan Sifferlen, Neeraj Soparawala, Piotr Findeisen, Raghav Sethi, Rose Williams, Thomas Nield, Tom Nats, Will Morrison, and Wojciech Biela.

In addition, the authors want to express their personal gratitude:

Matt would like to thank his wife, Meghan, and his three children, Emily, Hannah, and Liam, for their patience and encouragement while Matt worked on the book. The kids’ excitement about their dad becoming an “author” helped Matt through many long weekends and late nights.

Manfred would like to thank his wife, Yen, and his three sons, Lukas, Nikolas, and Tobias, not only for putting up with the tech-mumbo-jumbo but also for genuinely sharing an interest and passion for technology, writing, learning, and teaching.

Martin would like to thank his wife, Melina, and his four children, Marcos, Victoria, Joaquin, and Martina, for their support and enthusiasm over the past seven years of working on Trino.