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.
Presto - Today and Beyond - The Open Source SQL Engine for Querying all Data Lakes
Overview
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
