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.
Overview
Syllabus
Introduction
- Welcome
- What you should know
- Exercise files
- Presto origins
- Why use Presto?
- What does Presto do?
- How Presto works
- Deployment options
- Sandbox setup
- Command-line interface
- Connect from Tableau
- Connect from R
- Presto web UI
- Connect to Hive
- Connect to MySQL
- Connect to the local system
- Benchmark with TPCH
- Additional connectors
- Retrieve data
- Combine data sources
- Group results
- Conditional expressions
- Date and time functions
- Data aggregation
- Conversion between data types
- Window functions
- Bollinger bands
- Access data with arrays
- Access data with maps
- Parse URL strings
- Work with JSON data
- Migrate from Hive
- Next steps
Taught by
Ben Sullins
