Название: Trino: The Definitive Guide: SQL at Any Scale, on Any Storage, in Any Environment, 2nd Edition (Final)
Автор: Matt Fuller, Manfred Moser, Martin Traverso
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 322
Язык: английский
Формат: True/Retail PDF EPUB
Размер: 10.27 MB

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.

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.

This second edition modernizes the content to keep up with the rapid innovation of Trino. We cover new aspects such as the Helm chart to deploy a Trino cluster to Kubernetes, the new Iceberg and Delta Lake connectors for modern lakehouse architectures, fault-tolerant execution for query processing, expanded SQL language features, and the latest Trino release, now running on Java 17.

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 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.