54: Trino 2023 wrapped

Audio

Video

Video sections

• Intro: Episode 54: Trino 2023 wrapped (0s)
• Trino releases 434-436: including json_table, OpenSearch connector, Java 21 and more (81s)
• Trino 2023 wrapped: Statistics (623s)
• Events: Trino Fest and Trino Summit (789s)
• More events: Seoul, Tokyo, Bengaluru, ... (1049s)
• The Definitive Guide: More translations (1123s)
• Trino Gateway: New and active project (1200s)
• SQL routines: Write your own (1362s)
• Dynamic catalogs: Create and drop (1539s)
• Project Hummingbird update: More performance (1857s)
• Lakehouse improvements: Delta Lake, Iceberg, Hive, and Hudi (2138s)
• Clients: Python, Javascript, Rust and more (2223s)
• New maintainers: Manfred, James, and Mateusz (2448s)
• Looking at 2024: From Martin, Manfred, and Cole (2598s)

Hosts

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

Guests

• Martin Traverso, Trino co-creator and CTO at Starburst

Releases 434-436

Trino 434

• Support for a FILTER clause to the LISTAGG function
• Support reading json columns and DELETE statements in BigQuery connector

Trino 435

• Support for JSON_TABLE function
• Improve reliability when reading from GCS
• Improve query planning performance on Delta Lake tables
• Improve reliability and memory usage for inserts

Trino 436

• Support for Elasticsearch 8
• New OpenSearch connector
• Faster selective joins on partition columns

Additional comments:

• Disallow invalid configuration options with Delta Lake and Iceberg connector in 434
• Separate metadata caching in numerous connectors
• Various improvements for schema evolution in Hive connector
• Require JDK 21.0.1 to run Trino with 436
• Remove support of Elasticsearch 6 in 436
• Fix minor issues for SQL routine and JSON_TABLE function users

Recap of Trino in 2023

We chat about all the developments in the Trino project and the Trino community from 2023, including the following topics:

• Various statistics about the project
• Features and releases
• Trino Fest, Trino Summit, and other events
• New Trino maintainers
• Polish and Chinese editions of definitive guide published

Find more details and other topics in our blog post Trino 2023 wrapped.

Rounding out

• Upcoming events in NYC and Vienna, details available in the events calendar
• Trino Contributor Congregation coming soon
• Trino Gateway developer sync every two week, ping Manfred for invite

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

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