Book Description
Perform fast interactive analytics against different data sources using the Presto high-performance, distributed SQL query engine. With this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's Hive, Cassandra, a relational database, or a proprietary data store. Analysts, software engineers, and production engineers will learn how to manage, use, and even develop with Presto.
Initially developed by Facebook, open source Presto is now used by Netflix, Airbnb, LinkedIn, Twitter, Uber, and many other companies. Matt Fuller, Manfred Moser, and Martin Traverso show you how a single Presto query can combine data from multiple sources to allow for analytics across your entire organization.
Get started: Explore Presto's use cases and learn about tools that will help you connect to Presto and query data;
Go deeper: Learn Presto's internal workings, including how to connect to and query data sources with support for SQL statements, operators, functions, and more;
Put Presto in production: Secure Presto, monitor workloads, tune queries, and connect more applications; learn how other organizations apply Presto.
This open access book is Complimented by StarBurst. You can download Presto: The Definitive Guide ebook for free in PDF format (9.8 MB).
Table of Contents
Part I
Getting Started with Presto
Chapter 1
Introducing Presto
Chapter 2
Installing and Configuring Presto
Chapter 3
Using Presto
Part II
Diving Deeper into Presto
Chapter 4
Presto Architecture
Chapter 5
Production-Ready Deployment
Chapter 6
Connectors
Chapter 7
Advanced Connector Examples
Chapter 8
Using SQL in Presto
Chapter 9
Advanced SQL
Part III
Presto in Real-World Uses
Chapter 10
Security
Chapter 11
Integrating Presto with Other Tools
Chapter 12
Presto in Production
Chapter 13
Real-World Examples
Chapter 14
Conclusion