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
