50: Celebrating 50 episodes of Trino Community Broadcast

Video

• Intro: Episode 50! (0s)
• Trino releases: 421-422 (114s)
• Introducing our guests: Brian Olsen and Dain Sundstrom (240s)
• Storytime with Brian: The incoming Snowflake connector (678s)
• Questions for Dain: Setting an open source project up for success (889s)
• An engine that does both: Brian and Cole insist that Trino can do ETL (1284s)
• Our favorite features in Trino: The Ignite connector, generic type support, and the SPI (1407s)
• Trino Fest wrap-up, and a peek at the Trino roadmap: Decoupling from Hive and Hadoop, and introducing dynamic catalogs (s)

Audio

Hosts

• Cole Bowden, Developer Advocate at Starburst
• Manfred Moser, Director of Technical Content at Starburst (@simpligility)

Guests

• Brian Olsen, Head of Developer Relations at Tabular (@bitsondatadev)
• Dain Sundstrom, Trino co-creator and CTO at Starburst (@daindumb)

Releases 421-422

Unofficial highlights from Cole:

Trino 421

• Add support for CHECK constraints in UPDATE statements.
• Support for INSERT on Google Sheets.
• Faster queries on MongoDB tables with row columns.

Trino 422

• Faster INSERT and CREATE TABLE AS ... SELECT queries.
• Support for nested fields in ADD COLUMN.
• Faster Avro reader for Hive.
• register_table procedure to register Hadoop tables in Iceberg.

Concept of the episode: 50!

No, that’s not a factorial, we’re just excited to have made it to 50 Trino Community Broadcast episodes. We’ve brought back some familiar faces to talk about what we’ve done, how we’ve got here, what it takes to keep an open source project ticking for over a decade, and celebrate the steps we’ve taken along the way. It’s unscripted, and the discussion carries to wherever it feels like.

Tune in to hear about the history of the Trino Community Broadcast, the upcoming Snowflake connector, and a few of the core philosophies that have kept Trino running. Manfred also shows off updates to the Trino website, highlighting all the tools, data sources, and add-ons that you can use with Trino.

Trino events

Trino Fest was a little over a month ago, and we’re publishing the last recap of all the talks to the Trino blog today! Check out our YouTube channel and the Trino website to catch up on everything you missed.

If you have an event that is related to Trino, let us know so we can add it to the Trino events calendar.

Rounding out

If you want to learn more about Trino, get the definitive guide from O’Reilly. You can download the free PDF or buy the book online.

Music for the show is from the Megaman 6 Game Play album by Krzysztof Slowikowski.