Presto Essentials: Data Science

Get up to speed with Presto, the open-source SQL query engine developed by Facebook. Learn the key concepts and how to use them to take advantage of your modern big data system.

Introduction

• Welcome
• What you should know
• Exercise files

1. Introducing Presto

• Presto origins
• Why use Presto?
• What does Presto do?
• How Presto works

2. Running Presto

• Deployment options
• Sandbox setup
• Command-line interface
• Connect from Tableau
• Connect from R
• Presto web UI

3. Connectors

• Connect to Hive
• Connect to MySQL
• Connect to the local system
• Benchmark with TPCH
• Additional connectors

4. SQL Syntax

• Retrieve data
• Combine data sources
• Group results

5. Basic SQL functions

• Conditional expressions
• Date and time functions
• Data aggregation
• Conversion between data types

6. Advanced SQL Functions

• Window functions
• Bollinger bands
• Access data with arrays
• Access data with maps
• Parse URL strings
• Work with JSON data

7. Migrating from Hive

• Migrate from Hive

Conclusion

• Next steps