Do you ❤️ Trino? Give us a 🌟 on GitHub

Trino Community Broadcast

54: Trino 2023 wrapped

Jan 18, 2024

Video

Audio

 

Hosts

Guests

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.