67: Extra speed with Exasol and Trino

Introduction

Manfred and Cole are joined by Thomas Bestfleisch from the Exasol team to talk about Exasol, the new Trino Exasol connector, and some related use cases.

Video

• Introduction (0.0s)
• Release 461-464 (87.0s)
• Trino 463 including HTTP/2 (144.0s)
• Trino 464 with Java 23 and connector news (415.0s)
• Other news (685.0s)
• Introducing Thomas (822.0s)
• Exasol and Trino (911.0s)
• Upcoming events (2730.0s)

Audio

Host

• Manfred Moser, Director of Trino Community Leadership at Starburst - @simpligility
• Cole Bowden, Developer Advocate at Firebolt

Guests

• Thomas Bestfleisch, Senior Product Manager at Exasol

Releases and news

Follow are some highlights of the recent Trino releases:

Trino 461

• Add support for the add_files and add_files_from_table procedures in the Iceberg connector.

Trino 462

• Add support for read operations when using the Unity catalog as Iceberg REST catalog in the Iceberg connector.
• Improve performance and memory usage when decoding data in the CLI.

Trino 463

• Enable HTTP/2 for internal communication by default.
• Add timezone() functions.
• Include table functions with SHOW FUNCTIONS output.
• Add support for writing change data feed when deletion vector is enabled to the Delta Lake connector.

Trino 464

• Require JDK 23 to run Trino.
• Add the Faker connector.
• Add the Vertica connector.
• Remove the Accumulo connector.

As always, numerous performance improvements, bug fixes, and other features were added as well.

• Trino maintainer call - great sync with some exciting news coming to the community soon.
• Trino contributor call - recording and minutes available now.
• Trino Kubernetes operator meeting - minutes coming soon.
• Trino Summit call for speakers closed - stay tuned for announcements and don’t forget to register.

Introducing Thomas and Exasol

Exasol is a lightning fast, in-memory database for analytics. And this is not just a marketing slogan. Exasol has been at the top of the TPC-H benchmarks for a long time now. Thomas tells more about the database and his role.

Exasol and Trino

Trino and Exasol bridge the gap between extreme performance with in-memory usage from Exasol, and massive scale from a lakehouse with Trino.

We learn more about Exasol as Thomas guides us through his presentation about Exasol and Trino, and take the opportunity to question him for more details.

The pull request for the Exasol connector has been a long time in the works and was finally merged for Trino 452. We talk about the motivation, the process, the results, and the future for the connector.

Resources

• Exasol
• Trino’s Exasol connector
• Exasol SaaS
• Exasol AI lab
• Exasol container

Rounding out

• SQL basecamps before Trino Summit
• Trino Summit 2024: Information about first sessions and more available. Call for speakers closed. Announcements coming soon.

If you want to learn more about Trino, check out the definitive guide from O’Reilly. You can get the free PDF from Starburst or buy the English, Polish, Chinese, or Japanese edition.