Trino query plan analysis Parallel processing fundamentals

Trino, which powers Starburst products, and other SQL engines such as Apache Hive & Apache Spark process data in parallel as much as possible. In this session you will learn to:

• Understand how & why datasets are divided into splits
• Explain the decomposition of a query into tasks, stages, and exchanges
• Visualize multi-stage queries that tackle sorting, aggregation, and multiple types of joins
• See the conceptual visualization of a parallelized query aligns with Trino’s generated visual plan at runtime