66: Chat with Trino and Wren AI

Introduction

Manfred is joined by Wren AI team members and contributors to talk about the new AI-powered, text to SQL tool and its great support for Trino.

Video

• Introduction (0.0s)
• Trino releases 458, 459, and 460 (53.0s)
• Contributor guideline updates (420.0s)
• Shout out to maintainers (494.0s)
• Guests introductions (570.0s)
• Canner, Canner Enterprise, and Trino background (790.0s)
• PostgreSQL protocol compatibility layer (1157.0s)
• Wren AI and the Trino integration overview (1388.0s)
• Architecture details and demo (1724.0s)
• Upcoming events and rounding out (3642.0s)

Audio

Host

• Manfred Moser, Director of Trino Community Leadership at Starburst, (@simpligility)

Guests

• Himanshu Mendapra, Software Engineer at Genuin
• William Chang, CTO and Co-Founder at Canner
• Yadia Colindres, Product Management Advisor at Canner

Releases and news

Trino 458

• Deactivate legacy file system support for all catalogs. You must activate the desired file system support with fs.native-azure.enabled, fs.native-gcs.enabled, fs.native-s3.enabled, or fs.hadoop.enabled in each catalog using the Delta Lake, Hive, Hudi, or Iceberg connectors.
• Add support for tracing with OpenTelemetry to the JDBC driver.
• Reduce data transfer from remote systems for queries with large IN lists in numerous connectors.

Trino 459

• Docker container now uses Java 23. Please test this and let us know of any problems since Java 23 is going to be a requirement soon.
• Add support for KiB and similar data size units for the Trino CLI output.
• Allow configuring maximum concurrent HTTP requests to Azure on every node
• Add support for WASB to Azure Storage file system support.
• Improve cache hit ratio for the file system cache.
• Remove the local file connector.

Trino 460

• Add support for using an Alluxio cluster as file system cache.
• Add support for WASBS to Azure Storage file system support.
• Remove the atop connector.
• Remove the Raptor connector.
• Numerous performance improvements for the Clickhouse connector.

As usual, numerous performance improvements, bug fixes, and other features have been added as well.

• Updated and improved documentation for contributors for Trino, Trino Gateway, and other Trino projects.
• Jan Was steps up as subproject maintainer for trino-js-client.
• Cristian Osiac, Jordan Zimmermann, and Pablo Arteaga are working on aws-proxy.

Introducing Himanshu

Working at Genuin as software engineer, learning about new technologies, and occasionally contributing to open source projects like Wren AI.

Introducing William and Yadia

William is co-founder at Canner and drives everything about Canner Enterprise and Wren AI as CTO. Yadia works with William at Canner and is product manager for Wren AI.

We talk about the history of Canner and their usage of Trino in Canner Enterprise.

Pivoting to talk about Wren AI, we learn about its architecture, use cases and features, and continue along with an extensive demo of Wren AI.

Resources

• Canner
• Wren AI
• Pull request for Trino integration
• Trino as Wren AI data source documentation
• Wren AI launch at producthunt

Rounding out

• A call out to help us clean up and close old issues.
• Trino Summit 2024 is coming on the 11th and 12th of December, and registration, call for speakers, and sponsorship opportunities are open.
• Join us for the next Trino Community Broadcast 67 about the Exasol database and Trino connector.

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.