Foreword.
Preface.
Part I. Getting Started with Presto
1. Introducing Presto..
The Problems with Big Data
Presto to the Rescue
Designed for Performance and Scale
SQL-on-Anything
Separation of Data Storage and Query Compute Resources
Presto Use Cases
One SQL Analytics Access Point
Access Point to Data Warehouse and Source Systems
Provide SQL-Based Access to Anything
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
Presto Resources
Website
Documentation
Community Chat
Source Code, License, and Version
Contributing
Book Repository
Iris Data Set
Flight Data Set
A Brief History of Presto
Conclusion
2. Installing and Configuring Presto.
Trying Presto with the Docker Container
Installing from Archive File
Java Virtual Machine
Python
Installation
Configuration
Adding a Data Source
Running Presto
Conclusion
3. Using Presto..
Presto Command-Line Interface
Getting Started
Pagination
History
Additional Diagnostics
Executing Queries
Output Formats
Ignoring Errors
Presto JDBC Driver
Downloading and Registering the Driver
Establishing a Connection to Presto
Presto and ODBC
Client Libraries
Presto Web UI
SQL with Presto
Concepts
First Examples
Conclusion
Part II. Diving Deeper into presto
Part III. Presto in Real-World Uses
Index