Cargando…
Trino : the definitive guide : SQL at any scale, on any storage, in any environment /
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 lakeho...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly Media, Inc.,
[2022]
|
| Edición: | 2nd edition. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a22000007i 4500 | ||
|---|---|---|---|
| 001 | OR_on1347023022 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 221008s2022 cau o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e rda |c EBLCP |d ORMDA |d OCLCF |d UKAHL |d YDX |d OCLCO | ||
| 019 | |a 1352026895 | ||
| 020 | |a 9781098137199 |q electronic book | ||
| 020 | |a 1098137191 |q electronic book | ||
| 020 | |a 9781098137205 |q electronic book | ||
| 020 | |a 1098137205 |q electronic book | ||
| 020 | |z 9781098137236 |q paperback | ||
| 029 | 1 | |a AU@ |b 000072819824 | |
| 035 | |a (OCoLC)1347023022 |z (OCoLC)1352026895 | ||
| 037 | |a 9781098137229 |b O'Reilly Media | ||
| 050 | 4 | |a QA76.76.O62 |b F85 2022 | |
| 082 | 0 | 4 | |a 005.3 |2 23/eng/20221011 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Fuller, Matt |c (Writer on computer program languages) | |
| 245 | 1 | 0 | |a Trino : |b the definitive guide : SQL at any scale, on any storage, in any environment / |c Matt Fuller, Manfred Moser & Martin Traverso. |
| 250 | |a 2nd edition. | ||
| 264 | 1 | |a Sebastopol, California : |b O'Reilly Media, Inc., |c [2022] | |
| 300 | |a 1 online resource (322 p.) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a Cover -- Copyright -- Table of Contents -- Foreword -- Preface -- Conventions Used in This Book -- Code Examples, Permissions, and Attribution -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments -- Part I. Getting Started with Trino -- Chapter 1. Introducing Trino -- The Problems with Big Data -- Trino to the Rescue -- Designed for Performance and Scale -- SQL-on-Anything -- Separation of Data Storage and Query Compute Resources -- Trino Use Cases -- One SQL Analytics Access Point -- Access Point to Data Warehouse and Source Systems -- Provide SQL-Based Access to Anything | |
| 505 | 8 | |a Federated Queries -- Semantic Layer for a Virtual Data Warehouse -- Data Lake Query Engine -- SQL Conversions and ETL -- Better Insights Due to Faster Response Times -- Big Data, Machine Learning, and Artificial Intelligence -- Other Use Cases -- Trino Resources -- Website -- Documentation -- Community Chat -- Source Code, License, and Version -- Contributing -- Book Repository -- Iris Data Set -- Flight Data Set -- A Brief History of Trino -- Conclusion -- Chapter 2. Installing and Configuring Trino -- Trying Trino with the Docker Container -- Installing from the Archive File | |
| 505 | 8 | |a Java Virtual Machine -- Python -- Installation -- Configuration -- Adding a Data Source -- Running Trino -- Conclusion -- Chapter 3. Using Trino -- Trino Command-Line Interface -- Getting Started -- Pagination -- History and Completion -- Additional Diagnostics -- Executing Queries -- Output Formats -- Ignoring Errors -- Trino JDBC Driver -- Downloading and Registering the Driver -- Establishing a Connection to Trino -- Trino and ODBC -- Client Libraries -- Trino Web UI -- SQL with Trino -- Concepts -- First Examples -- Conclusion -- Part II. Diving Deeper into Trino | |
| 505 | 8 | |a Chapter 4. Trino Architecture -- Coordinator and Workers in a Cluster -- Coordinator -- Discovery Service -- Workers -- Connector-Based Architecture -- Catalogs, Schemas, and Tables -- Query Execution Model -- Query Planning -- Parsing and Analysis -- Initial Query Planning -- Optimization Rules -- Predicate Pushdown -- Cross Join Elimination -- TopN -- Partial Aggregations -- Implementation Rules -- Lateral Join Decorrelation -- Semi-Join (IN) Decorrelation -- Cost-Based Optimizer -- The Cost Concept -- Cost of the Join -- Table Statistics -- Filter Statistics | |
| 505 | 8 | |a Table Statistics for Partitioned Tables -- Join Enumeration -- Broadcast Versus Distributed Joins -- Working with Table Statistics -- Trino ANALYZE -- Gathering Statistics When Writing to Disk -- Hive ANALYZE -- Displaying Table Statistics -- Conclusion -- Chapter 5. Production-Ready Deployment -- Configuration Details -- Server Configuration -- Logging -- Node Configuration -- JVM Configuration -- Launcher -- Cluster Installation -- RPM Installation -- Installation Directory Structure -- Configuration -- Uninstall Trino -- Installation in the Cloud -- Helm Chart for Kubernetes Deployment | |
| 500 | |a Cluster Sizing Considerations | ||
| 520 | |a 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. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a Open source software. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Logiciels libres. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Open source software |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Moser, Manfred |c (Software engineer) | |
| 700 | 1 | |a Traverso, Martin. | |
| 776 | 0 | 8 | |i Print version: |a Fuller, Matt |t Trino: the Definitive Guide |d North Melbourne : O'Reilly Media, Incorporated,c2022 |z 9781098137236 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781098137229/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH40830056 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL30167988 | ||
| 994 | |a 92 |b IZTAP | ||