Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Linux Foundation

Presto - Today and Beyond - The Open Source SQL Engine for Querying all Data Lakes

Linux Foundation via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the open-source SQL engine Presto in this 46-minute Linux Foundation talk. Dive into Presto's architecture, common questions, CLI, connectors, and connector models. Learn about Hive connector types, speed improvements, and various use cases including data science, federated queries, and data lakes. Compare Presto with other query engines like HANA, and discover technical improvements in reporting, dashboarding, and interactive analytics. Understand how to scale Presto for high QPS and large workloads, and learn about its cache architecture. Gain insights into Presto Plus, reliability improvements, task scheduling, client-side retries, and native accelerators. Discover Presto's extensibility and find out how to get involved in this powerful SQL engine for querying all data lakes.

Syllabus

Introduction
What is Presto
Architecture
Common Questions
Presto Architecture
Presto CLI
Presto connectors
Presto connector model
Hive connector types
Speed
Query
Aggregate
Use Cases
Stacks
Data Science
Federated
Transformations
Data Lakes
Other Query Engines
HANA
Technical Improvements
Reporting Dashboarding
Interactive Analytics
High QPS
Large workloads
Consolidate on Presto
Scaling Presto
Workload
Online Analytics
Cache Architecture
Presto Plus
Improving Reliability
Improving Task Scheduling
ClientSide Retries
Native Accelerator
AriaScan
Extensibility
Get involved

Taught by

Linux Foundation

Reviews

Start your review of Presto - Today and Beyond - The Open Source SQL Engine for Querying all Data Lakes

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.