Welcome

Brian Olsen

Developer Advocate

Starburst

Keynote

Justin Borgman

Co-Founder, Chairman and CEO

Starburst

Break

State of Trino

Martin Traverso

Co-Creator of Trino and Chief Technology Officer

Starburst

Dain Sundstrom

Co-Creator of Trino and Chief Technology Officer

Starburst

David Philips

Co-Creator of Trino and Chief Technology Officer

Starburst

Break

Fast results using Iceberg and Trino

Companies like Netflix are using Iceberg tables for storage and Trino for queries to provide fast access to results in tables that are up to several petabytes. This talk will explain the optimizations that both Iceberg and Trino use to make fast queries possible. This talk will cover:

• How Iceberg locates files quickly using its unique metadata layout
• Techniques built into Trino that cut down waiting time
• How to avoid slow queries
• Future efforts to make Iceberg and Trino better

Ryan Blue

CEO

Tabular

Break

Sponsor Lightning Talk

Break

Affinity scheduling and node-local caching effects on query latency

Boosting query latency beyond what vanilla Iceberg is capable of. We introduce a node-local cache, affinity scheduling and catalog-side caching. With the support of the cache, we are able to boost query performance significantly. This new architecture can beat some performance oriented connectors with the added benefit of continuing to work with disaggregated storage, and having nigligible integration costs.

Parth Brahmbhatt

Senior Software Engineer

Netflix

Islam Ismailov

Senior Software Engineer

Netflix

Break

Sponsor Lightning Talk

Break

How DoorDash processes petabytes of data by utilizing Trino

In order to process billions of events per day DoorDash needed a robust distributed SQL query engine that can work with various data sources. In this talk we will discuss why Doordash chose Trino as our Unified query engine, and how we deployed Trino on Kubernetes to enable federated queries between Data Lake, Snowflake, and Pinot etc.

Akshat Nair

Engineering Manager

DoorDash

Satya Boora

Staff Software Engineer

DoorDash

End Day 1

Brian Olsen

Developer Advocate

Starburst

Data Access as A Service - From Trino to Federation

As one of the most popular query engines, Trino has been playing a critical role in EA. Everyday, Trino clusters in EA handle PB of data, including raw data ingestion, analytics ETLs, and ad-hoc queries. Many rely on Trino to explore data for numerous business purposes including game analytics, advertising campaigns, AI applications and experimentation, etc... Studios and other groups need to leverage multiple query platforms which query proprietary data and have special tools they need to support. This requires syncing data/metadata across platforms automatically which poses a challenge from the security perspective. It is critical to ensure the data is protected in a consistent manner across all platforms. Early attempts maintain ACLs were maintained in Trino rule files and customized pipeline to update the files. As EA adds more system to its platform, the existing rule files and pipelines were not applicable in the new querying system. This spurred on the creation of the DaaS to serve data accesses as a service. This makes ACLs much more transmisable to be used by the other platforms in EAs ecosystem.

Teng Wang

Software Engineer

EA

Tushar Agarwal

Software Engineer III

EA

Yu Jin

Senior Software Engineer

EA

Kaiyu Liu

Senior Software Engineer

EA

Break

FLiP Into Trino

Remember the days when you could wait until your batch data load was done and then you could run some simple queries or build stale dashboards? Those days are over, today you need instant analytics as the data is streaming in real-time. You need universal analytics where that data is. I will show you how to do this utilizing the latest cloud native open source tools. In this talk we will utilize Trino, Apache Pulsar, Pulsar SQL and Apache Flink to analyze instantly data from IoT, sensors, transportation systems, Logs, REST endpoints, XML, Images, PDFs, Documents, Text, semistructured data, unstructured data, structured data and a hundred data sources you could never dream of streaming before. I will teach how to use Pulsar SQL to run analytics on live data.

Tim Spann

Developer Advocate

StreamNative

David Kjerrumgaard

Developer Advocate

StreamNative

Break

Real-time Analytics with Trino and Apache Pinot

In this presentation, Elon and Xiang will share an overview of Trino Pinot Connector, which bridges the flexibility of Trino's full SQL support to the power of Apache Pinot's realtime analytics, giving you the best of both worlds.

Elon Azoulay

Software Engineer

Facebook

Xiang Fu

Co-Founder

StarTree

Break

Sponsor Lightning Talk

Break

Trino at LinkedIn

LinkedIn started its Trino journey back in 2015 and has been an active contributor in the community. We have been witnessing massive growth YoY and our workload has been exponentially growing with more than 5k unique users, processing 100s of PB, millions of queries and quadrillions of rows every week. Trino at LinkedIn is used for a diverse variety of use cases like detecting fraud and abuse, data scientists measure impact of COVID on economic and jobs landscape, ​​engineers run ad hoc analysis to debug production issues, business analysts build robust data driven offering to help salespeople make smarter decisions, site-reliability engineers analyze internal system performances and more. In this talk, we will go through Trino's growth at LinkedIn, how it fits into our data ecosystem, some of our operating challenges and dive into a few of our use cases. We'll also talk about our learnings, contributions, and philosophy on open source and what has worked well for us.

Akshay Rai

Staff Software Engineer

LinkedIn

Jithesh Thekkarikottil Rajan

Staff Software Engineer

LinkedIn

Break

Galaxy Talk

Break

Trino Centric Query Platform @ Robinhood

In this talk, we will present how we leverage Trino to power our query platform at Robinhood. We will cover the scale and architecture of our query infrastructure, and the learnings we had running it at scale. We will also share our ongoing work on improving query performance with Alluxio, enabling real time aggregation with Pinot and as well as other future plans.

Grace Lu

Senior Software Engineer

Robinhood

Yichuan Huang

Senior Software Engineer

Robinhood

Jiawei Zhang

Senior Software Engineer

Robinhood

End Day 2

Brian Olsen

Developer Advocate

Starburst