# Trino Blog

Trino is a high performance, distributed SQL query engine for big data.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Trino 483 introduces the PIVOT clause for SQL queries

DevFeed: [Trino 483 introduces the PIVOT clause for SQL queries](<https://devfeed.tech/articles/a-pivotal-summer-8774.md>)

Original publisher: [Read original article](<https://trino.io/blog/2026/07/18/a-pivotal-summer.html>)

Author: Martin Traverso

Published: 2026-07-18T00:00:00Z

Content type: release

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [channel](<https://devfeed.tech/tags/channel.md>), [feature](<https://devfeed.tech/tags/feature.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Trino 483 is presented as a release with larger SQL additions, led by the new PIVOT clause. The article explains that PIVOT turns categorical values into columns and supports one or more aggregations.

### Source excerpt

Last month we called Trino 482 the summer of grammar release, because it closed so many small gaps in Trino's dialect of SQL at once. Those additions were mostly about breadth: a long list of standard predicates and forms, each a modest convenience on its own. Trino 483 keeps the season going, but the character is different. This release lands a handful of larger, more powerful additions instead of a dozen small gaps. They change the shape of the queries you write rather than just tidying them up. One of them, PIVOT, is big enough to carry the release on its own. As before, every example is live. Hit Run and watch Trino 483 evaluate it.

## Trino's summer of grammar

DevFeed: [Trino's summer of grammar](<https://devfeed.tech/articles/trino-s-summer-of-grammar-8773.md>)

Original publisher: [Read original article](<https://trino.io/blog/2026/06/26/summer-of-grammar.html>)

Author: Martin Traverso, Mateusz Gajewski

Published: 2026-06-26T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [features](<https://devfeed.tech/tags/features.md>), [post](<https://devfeed.tech/tags/post.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

Trino 482 adds numerous SQL grammar features, including unordered range bounds, explicit three-valued-logic predicates, and predicates for examining subquery results. The article presents live examples that can be run in Trino.

### Source excerpt

What a query engine runs, before anything else, is a language. And like any language, SQL is defined by its grammar: the predicates, operators, and forms you're allowed to write down. Trino has always spoken SQL fluently, but the ISO 9075 standard is a big book, and there have always been a few corners of it we hadn't gotten around to implementing yet. Trino 482 closes a remarkable number of those gaps in a single release. So many, in fact, that we started calling it the summer of grammar. This post walks through the new language features, and because reading SQL is never quite as convincing as running it, every example below is live. Hit Run and watch Trino 482 evaluate it for real.

## Introducing the NUMBER data type

DevFeed: [Introducing the NUMBER data type](<https://devfeed.tech/articles/introducing-the-number-data-type-8772.md>)

Original publisher: [Read original article](<https://trino.io/blog/2026/03/25/number-data-type.html>)

Author: Piotr Findeisen, Starburst Data

Published: 2026-03-25T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [data-architecture](<https://devfeed.tech/topics/data-architecture.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>)

Tags: [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [integration](<https://devfeed.tech/tags/integration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [types](<https://devfeed.tech/tags/types.md>)

### AI overview

Trino 480 introduces the NUMBER data type, enabling high-precision, variable-scale decimal values beyond the existing 38-digit DECIMAL limit. The feature improves access to numeric data across Oracle, PostgreSQL, MySQL, MariaDB, and SingleStore systems while avoiding skipped columns or lossy rounding.

### Source excerpt

One of Trino's core strengths is breaking down data silos--enabling data engineers to query diverse data sources through a single SQL interface. However, when those sources use high-precision numeric types beyond Trino's 38-digit DECIMAL limit, that promise breaks down. Users faced an impossible choice: skip the columns entirely and lose access to critical data, or accept lossy rounding that compromises data integrity. This challenge required a new approach: a dedicated data type for high-precision, variable-scale decimals.

## Trino's Upgrade to Java 24

DevFeed: [Trino's Upgrade to Java 24](<https://devfeed.tech/articles/twenty-four-8770.md>)

Original publisher: [Read original article](<https://trino.io/blog/2025/03/03/java-24.html>)

Author: Manfred Moser, Mateusz Gajewski

Published: 2025-03-03T00:00:00Z

Content type: opinion

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Java](<https://devfeed.tech/topics/java.md>), [upgrade](<https://devfeed.tech/topics/upgrade.md>), [Security](<https://devfeed.tech/topics/security.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>), [phoenix](<https://devfeed.tech/topics/phoenix.md>)

Tags: [java](<https://devfeed.tech/tags/java.md>), [java-17](<https://devfeed.tech/tags/java-17.md>), [kafka](<https://devfeed.tech/tags/kafka.md>), [phoenix](<https://devfeed.tech/tags/phoenix.md>), [release-notes](<https://devfeed.tech/tags/release-notes.md>), [security](<https://devfeed.tech/tags/security.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>)

### AI overview

The article discusses Trino's upgrade from Java 23 to Java 24, highlighting selected Java 24 features and the expected impact of permanently disabling the Security Manager on Trino connectors and dependencies.

### Source excerpt

Six month ago we adopted Java 23 as requirement, following our standard procedure to upgrade with each Java version as soon as it becomes available. This allows us to take advantage of all the great improvement each release brings. The upgrade to 23 was pretty easy since the changes from 22 to 23 were not that big. The story turns out to be a bit different now with our upgrade to Java 24.

## Out with the old file system

DevFeed: [Out with the old file system](<https://devfeed.tech/articles/out-with-the-old-file-system-8769.md>)

Original publisher: [Read original article](<https://trino.io/blog/2025/02/10/old-file-system.html>)

Author: Manfred Moser, David Phillips, Mateusz Gajewski

Published: 2025-02-10T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Filesystems](<https://devfeed.tech/topics/filesystems.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [Hadoop](<https://devfeed.tech/topics/hadoop.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [Google Cloud Platform (GCP)](<https://devfeed.tech/topics/google-cloud.md>)

Tags: [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [apache-parquet](<https://devfeed.tech/tags/apache-parquet.md>), [azure](<https://devfeed.tech/tags/azure.md>), [compression](<https://devfeed.tech/tags/compression.md>), [data-lake](<https://devfeed.tech/tags/data-lake.md>), [deprecated](<https://devfeed.tech/tags/deprecated.md>), [google-cloud](<https://devfeed.tech/tags/google-cloud.md>), [hadoop](<https://devfeed.tech/tags/hadoop.md>), [maintenance](<https://devfeed.tech/tags/maintenance.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

Trino 470 deprecated its legacy Hadoop-based file system support, which will be removed in a future release. The article explains Trino's move toward custom file system implementations for cloud storage and describes the migration path for users, including catalog-level file system configuration and warnings for deprecated properties.

### Source excerpt

What a long journey it has been! From the start Trino supported querying Hive data and used libraries from the Hive and Hadoop ecosystem. With the release of Trino 470 we mark another milestone to more features and better performance for data lake and lakehouse querying with Trino. We deprecated the legacy file system support, and will permanently remove them in an upcoming release.

## Trino in 2024 and beyond

DevFeed: [Trino in 2024 and beyond](<https://devfeed.tech/articles/trino-in-2024-and-beyond-8768.md>)

Original publisher: [Read original article](<https://trino.io/blog/2025/01/07/2024-and-beyond.html>)

Author: Manfred Moser

Published: 2025-01-07T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>)

Tags: [bug](<https://devfeed.tech/tags/bug.md>), [community](<https://devfeed.tech/tags/community.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [duckdb](<https://devfeed.tech/tags/duckdb.md>), [keynote](<https://devfeed.tech/tags/keynote.md>), [maintainers](<https://devfeed.tech/tags/maintainers.md>), [observability](<https://devfeed.tech/tags/observability.md>), [opentelemetry](<https://devfeed.tech/tags/opentelemetry.md>), [performance](<https://devfeed.tech/tags/performance.md>), [releases](<https://devfeed.tech/tags/releases.md>), [secrets](<https://devfeed.tech/tags/secrets.md>), [sql](<https://devfeed.tech/tags/sql.md>), [supply-chain](<https://devfeed.tech/tags/supply-chain.md>)

### AI overview

A retrospective of Trino's 2024 releases, improvements, community growth, and plans for 2025.

### Source excerpt

Wow, what an amazing year 2024 was for Trino! Martin Traverso presented about the achievements and progress of the project at the recent Trino Summit 2024. Let me dive deeper into the content of his keynote and elaborate some more about our amazing plans for the future.

## Trino Summit 2024 resources

DevFeed: [Trino Summit 2024 resources](<https://devfeed.tech/articles/trino-summit-2024-resources-8767.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/12/18/trino-summit-2024-quick-recap.html>)

Author: Manfred Moser, Monica Miller, Anna Schibli

Published: 2024-12-18T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [data analytics](<https://devfeed.tech/topics/data-analytics.md>), [interoperability](<https://devfeed.tech/topics/interoperability.md>), [text2sql](<https://devfeed.tech/topics/text2sql.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Resilience](<https://devfeed.tech/topics/resilience.md>), [Security](<https://devfeed.tech/topics/security.md>), [Persistence](<https://devfeed.tech/topics/persistence.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [community](<https://devfeed.tech/tags/community.md>), [data](<https://devfeed.tech/tags/data.md>), [interoperability](<https://devfeed.tech/tags/interoperability.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [resilience](<https://devfeed.tech/tags/resilience.md>), [resources](<https://devfeed.tech/tags/resources.md>), [security](<https://devfeed.tech/tags/security.md>), [slack](<https://devfeed.tech/tags/slack.md>), [software-engineer](<https://devfeed.tech/tags/software-engineer.md>), [summit](<https://devfeed.tech/tags/summit.md>)

### AI overview

A recap of Trino Summit 2024 sessions covering large-scale data warehouses, data lakes and lakehouses, self-service analytics, text-to-SQL, interoperability, cost efficiency, observability, policy enforcement, and Trino on Kubernetes.

### Source excerpt

What a view we had at the summit! Over 700 live attendees enjoyed the sessions and learned more about Trino-related use cases and projects. Now it is time for the additional 1000 registrants, our 13000+ Trino users on Slack, and everyone else in the Trino community and beyond to enjoy the presentations and recordings at their leisure.

## The long journey to Apache Ranger

DevFeed: [The long journey to Apache Ranger](<https://devfeed.tech/articles/the-long-journey-to-apache-ranger-8766.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/12/02/ranger.html>)

Author: Manfred Moser

Published: 2024-12-02T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [apache](<https://devfeed.tech/tags/apache.md>), [data](<https://devfeed.tech/tags/data.md>), [hadoop](<https://devfeed.tech/tags/hadoop.md>), [integration](<https://devfeed.tech/tags/integration.md>), [pull-request](<https://devfeed.tech/tags/pull-request.md>), [release](<https://devfeed.tech/tags/release.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

Trino 466 adds an Apache Ranger plugin for data access control. The article recounts the history of the integration, including prior pull requests, container-image support for testing, and renewed work in 2024.

### Source excerpt

Apache Ranger has arrived! With the new Trino 466 you all get another jam-packed release of Trino awesomeness. One of the goodies is a new plugin for access control for your data with Apache Ranger, and it has gone through a long story to get here. Apache Ranger has a long history and wide adoption as an access control system for data lakes using Hadoop and Hive. Since Trino brings fast analytics to this space, and also supports modern data lakehouses and other data sources, Apache Ranger is a natural fit for access control on a Trino-powered data platform.

## The glorious lineup for Trino Summit 2024

DevFeed: [The glorious lineup for Trino Summit 2024](<https://devfeed.tech/articles/the-glorious-lineup-for-trino-summit-2024-8765.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/11/22/trino-summit-2024-lineup.html>)

Author: Manfred Moser, Monica Miller, Anna Schibli

Published: 2024-11-22T00:00:00Z

Content type: news

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Artificial Intelligence](<https://devfeed.tech/topics/ai.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [data analytics](<https://devfeed.tech/topics/data-analytics.md>), [text2sql](<https://devfeed.tech/topics/text2sql.md>), [observability](<https://devfeed.tech/topics/observability.md>), [Security](<https://devfeed.tech/topics/security.md>), [Resilience](<https://devfeed.tech/topics/resilience.md>)

Tags: [2025](<https://devfeed.tech/tags/2025.md>), [ai](<https://devfeed.tech/tags/ai.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [event](<https://devfeed.tech/tags/event.md>), [free](<https://devfeed.tech/tags/free.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [observability](<https://devfeed.tech/tags/observability.md>), [resilience](<https://devfeed.tech/tags/resilience.md>), [security](<https://devfeed.tech/tags/security.md>), [sql](<https://devfeed.tech/tags/sql.md>), [summit](<https://devfeed.tech/tags/summit.md>)

### AI overview

The article announces the full lineup for the free, virtual, two-day Trino Summit 2024. It highlights a keynote on Trino project and community developments, a panel on AI and Trino, and sessions covering Kubernetes, observability, data lakes with Iceberg, policy enforcement, and text-to-SQL analytics.

### Source excerpt

We just wrapped up our mini training series SQL basecamps before Trino Summit, and now Trino Summit 2024 is less than three busy weeks away. It's a good thing that we have also been working hard on all the preparations for the summit. Everything is coming together, and we are excited to share the full lineup for the free, virtual, two day event today.

## View the SQL basecamps before Trino Summit

DevFeed: [View the SQL basecamps before Trino Summit](<https://devfeed.tech/articles/view-the-sql-basecamps-before-trino-summit-8764.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/11/21/sql-basecamps-view.html>)

Author: Manfred Moser

Published: 2024-11-21T00:00:00Z

Content type: release

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [concepts](<https://devfeed.tech/tags/concepts.md>), [data](<https://devfeed.tech/tags/data.md>), [sql](<https://devfeed.tech/tags/sql.md>), [summit](<https://devfeed.tech/tags/summit.md>), [training](<https://devfeed.tech/tags/training.md>)

### AI overview

Two SQL basecamp training sessions recorded before Trino Summit are now available. The sessions cover core concepts of a Trino-powered lakehouse, data ingestion and maintenance, lakehouse usage, structural data types, and views.

### Source excerpt

Trino Summit is inching closer fast, and we are busy with all the preparation. Nevertheless, we thought we bring you some more SQL and Trino-related training. The two live classes from our SQL basecamps before Trino Summit are now available for you all to enjoy, just in case you missed it.

## Trino and Javascript?! YES!

DevFeed: [Trino and Javascript?! YES!](<https://devfeed.tech/articles/trino-and-javascript-yes-8763.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/11/18/javascript.html>)

Author: Manfred Moser

Published: 2024-11-18T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [JavaScript](<https://devfeed.tech/topics/javascript.md>), [Java](<https://devfeed.tech/topics/java.md>), [User Interfaces](<https://devfeed.tech/topics/user-interfaces.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>), [web applications](<https://devfeed.tech/topics/web-applications.md>)

Tags: [applications](<https://devfeed.tech/tags/applications.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [documentation](<https://devfeed.tech/tags/documentation.md>), [grafana](<https://devfeed.tech/tags/grafana.md>), [java](<https://devfeed.tech/tags/java.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [maintainers](<https://devfeed.tech/tags/maintainers.md>), [ui](<https://devfeed.tech/tags/ui.md>), [web](<https://devfeed.tech/tags/web.md>), [web-applications](<https://devfeed.tech/tags/web-applications.md>)

### AI overview

The article explains how JavaScript is used across the Trino ecosystem, including the official trino-js-client, client applications, web-based user interfaces, and a Grafana plugin. It also describes planned improvements for authentication, documentation, the spooling client protocol, and compatibility testing.

### Source excerpt

Trino is written in Java. Trino contributors and maintainers are often veterans in the Java ecosystem and community, and Trino is very modern when it comes to Java. For example, Trino now requires the latest Java version and actively uses new features. When it comes to JavaScript however, the story is a bit more complicated. Of course, JavaScript is commonly used in the Trino ecosystem and codebase. Let's look at some of the specifics.

## A glimpse at the summit

DevFeed: [A glimpse at the summit](<https://devfeed.tech/articles/a-glimpse-at-the-summit-8762.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/10/17/trino-summit-2024-tease.html>)

Author: Manfred Moser, Monica Miller, Anna Schibli

Published: 2024-10-17T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data analytics](<https://devfeed.tech/topics/data-analytics.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [Data Space](<https://devfeed.tech/topics/data-space.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [event](<https://devfeed.tech/tags/event.md>), [free](<https://devfeed.tech/tags/free.md>), [interoperability](<https://devfeed.tech/tags/interoperability.md>), [netflix](<https://devfeed.tech/tags/netflix.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [scalability](<https://devfeed.tech/tags/scalability.md>), [sql](<https://devfeed.tech/tags/sql.md>), [training](<https://devfeed.tech/tags/training.md>), [virtual-event](<https://devfeed.tech/tags/virtual-event.md>)

### AI overview

A preview of the two-day, free, virtual Trino Summit 2024 highlights proposed sessions on large-scale Trino deployments, Apache Iceberg, lakehouse architectures, data platform interoperability, analytics cost efficiency, performance, and scalability.

### Source excerpt

Our efforts around Trino Summit 2024 are ramping up and the event is creeping closer and closer. We are really looking forward to the two-day, free, virtual event in December about all things Trino. While we are working hard to put together the SQL basecamps before Trino Summit training sessions and other community events, a number of your awesome peers from the Trino community submitted session proposals, and we are excited to share that glimpse on the agenda for Trino Summit 2024.

## A Kubernetes operator for Trino?

DevFeed: [A Kubernetes operator for Trino?](<https://devfeed.tech/articles/a-kubernetes-operator-for-trino-8761.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/10/10/operator.html>)

Author: Manfred Moser, Martin Traverso

Published: 2024-10-10T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Containers](<https://devfeed.tech/topics/containers.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [hosting](<https://devfeed.tech/topics/hosting.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [community](<https://devfeed.tech/tags/community.md>), [containers](<https://devfeed.tech/tags/containers.md>), [helm](<https://devfeed.tech/tags/helm.md>), [hosting](<https://devfeed.tech/tags/hosting.md>), [images](<https://devfeed.tech/tags/images.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [servers](<https://devfeed.tech/tags/servers.md>), [slack](<https://devfeed.tech/tags/slack.md>)

### AI overview

The article discusses the proposal for a Kubernetes operator for Trino. It reviews existing internal and open-source operator efforts, suggests combining them into a modular operator aligned with Trino and potentially compatible with Trino Gateway, and invites contributors to discuss implementation and maintenance questions.

### Source excerpt

Trino is deployed everywhere - on-premise, in private data centers, in the cloud with hosting providers, on bare metal servers, on virtual machines, and with containers. With all these options for deployments, a Kubernetes-based platform with a container emerged as the most widely used approach. The Trino project caters for this usage with our container images for every release and our Helm chart. However we keep hearing from people who want to use a Kubernetes operator...

## SQL basecamps before Trino Summit

DevFeed: [SQL basecamps before Trino Summit](<https://devfeed.tech/articles/sql-basecamps-before-trino-summit-8760.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/10/07/sql-basecamps.html>)

Author: Manfred Moser

Published: 2024-10-07T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [Filesystems](<https://devfeed.tech/topics/filesystems.md>), [configuration](<https://devfeed.tech/topics/configuration.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [data-management](<https://devfeed.tech/tags/data-management.md>), [object-storage](<https://devfeed.tech/tags/object-storage.md>), [operational](<https://devfeed.tech/tags/operational.md>), [series](<https://devfeed.tech/tags/series.md>), [sql](<https://devfeed.tech/tags/sql.md>), [summit](<https://devfeed.tech/tags/summit.md>), [tips-and-tricks](<https://devfeed.tech/tags/tips-and-tricks.md>), [training](<https://devfeed.tech/tags/training.md>)

### AI overview

The article introduces two SQL training sessions designed to prepare Trino users for Trino Summit 2024. The sessions cover moving data into and with Trino, lakehouse migration, schemas and tables, data management, object-storage configuration, file-system support, querying, window functions, and complex structural data.

### Source excerpt

Later in December your knowledge of our Trino SQL query engine will certainly peak again at Trino Summit 2024. To reach those heights and absorb all there is to learn at Trino Summit, you need to get ready. That is why I teamed up with our Trino creators and BDFLs - Martin Traverso, Dain Sundstrom, and David Phillips. We aim to be your coaches and trainers to get you ready and get to the summit without the need for oxygen masks and sherpas. Join us for the "SQL basecamps before Trino Summit", where we expand on our past SQL training series with two new episodes. Register now

## 23 is a go, keeping pace with Java

DevFeed: [23 is a go, keeping pace with Java](<https://devfeed.tech/articles/23-is-a-go-keeping-pace-with-java-8759.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/09/17/java-23.html>)

Author: Manfred Moser, Mateusz Gajewski

Published: 2024-09-17T00:00:00Z

Content type: news

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [ci](<https://devfeed.tech/topics/ci.md>)

Tags: [community](<https://devfeed.tech/tags/community.md>), [java](<https://devfeed.tech/tags/java.md>), [release](<https://devfeed.tech/tags/release.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

Trino plans to require Java 23 for builds and runtime after validating binaries, updating its container image, releasing for community testing, and resolving feedback.

### Source excerpt

Only about ten Trino releases or six months ago, we released Trino 447 with the requirement to use Java 22. In recent releases we started to take more and more advantage of features that are only available with that upgrade. We made some big steps in terms of performance and talked talked about some of those performance enhancements around aircompressor in the recent Trino Community Broadcast 65. The Java community runs its release processes on a very predictable schedule - March and September mean new Java releases. This time it's Java 23, and Trino will not be left behind. We are upgrading to use and require Java 23 soon!.

## Announcing Trino Summit 2024

DevFeed: [Announcing Trino Summit 2024](<https://devfeed.tech/articles/announcing-trino-summit-2024-8758.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/07/11/trino-summit-2024-call-for-speakers.html>)

Author: Cole Bowden, Manfred Moser, and Monica Miller

Published: 2024-07-11T00:00:00Z

Content type: news

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [big-data](<https://devfeed.tech/topics/big-data.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>), [.NET 11](<https://devfeed.tech/topics/net-11.md>)

Tags: [architectures](<https://devfeed.tech/tags/architectures.md>), [big-data](<https://devfeed.tech/tags/big-data.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [community](<https://devfeed.tech/tags/community.md>), [data-engineering](<https://devfeed.tech/tags/data-engineering.md>), [data-science](<https://devfeed.tech/tags/data-science.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [event](<https://devfeed.tech/tags/event.md>), [security](<https://devfeed.tech/tags/security.md>), [sign-up](<https://devfeed.tech/tags/sign-up.md>), [speakers](<https://devfeed.tech/tags/speakers.md>), [sql](<https://devfeed.tech/tags/sql.md>), [streaming](<https://devfeed.tech/tags/streaming.md>), [summit](<https://devfeed.tech/tags/summit.md>), [videos](<https://devfeed.tech/tags/videos.md>), [virtual-event](<https://devfeed.tech/tags/virtual-event.md>)

### AI overview

Trino Summit 2024 is announced as a two-day virtual event on December 11 and 12, featuring talks for engineers, analysts, data scientists, and others interested in Trino. The article also opens a call for beginner to advanced speaker submissions on topics including data architectures, SQL analytics, data engineering, streaming, governance, security, deployment, and custom connectors.

### Source excerpt

Fresh off the heels of Trino Fest 2024, where Commander Bun Bun was busy meeting the Trino community in-person, we're already looking forward to another, bigger event to round out the year in Trino. For those who've been here a while, you know that can only mean one thing: Trino Summit 2024. Much like last year, it will be a two-day, fully virtual event, hosting a wide range of talks covering all things Trino on the 11th and 12th of December. Read on for more info, or if you're already convinced... Register to attend!

## Trino Fest 2024 recap

DevFeed: [Trino Fest 2024 recap](<https://devfeed.tech/articles/trino-fest-2024-recap-8757.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/06/24/trino-fest-recap.html>)

Author: Manfred Moser, Cole Bowden, Monica Miller

Published: 2024-06-24T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>)

Tags: [community](<https://devfeed.tech/tags/community.md>), [event](<https://devfeed.tech/tags/event.md>), [events](<https://devfeed.tech/tags/events.md>), [learn](<https://devfeed.tech/tags/learn.md>), [recap](<https://devfeed.tech/tags/recap.md>), [remote](<https://devfeed.tech/tags/remote.md>), [speakers](<https://devfeed.tech/tags/speakers.md>)

### AI overview

A recap of Trino Fest 2024, covering the in-person and virtual attendance, community feedback, industry adoption of Trino, sponsors, and recordings, slides, and Q&A materials from the sessions.

### Source excerpt

Trino Fest 2024 is successfully in the books! While over 100 enthusiastic members of the community gathered in Boston, over 650 virtual attendees joined us worldwide to learn from our expert speakers as they discussed topics such as table formats, enhancements and optimizations, and use cases with Trino both large and small. And now it is your chance to revisit the presentations or catch up on everything you missed.

## One busy week to go before Trino Fest 2024

DevFeed: [One busy week to go before Trino Fest 2024](<https://devfeed.tech/articles/one-busy-week-to-go-before-trino-fest-2024-8756.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/06/06/trino-fest-last-call.html>)

Author: Manfred Moser

Published: 2024-06-06T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [interoperability](<https://devfeed.tech/topics/interoperability.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [apple](<https://devfeed.tech/tags/apple.md>), [catalog](<https://devfeed.tech/tags/catalog.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [event](<https://devfeed.tech/tags/event.md>), [events](<https://devfeed.tech/tags/events.md>), [free](<https://devfeed.tech/tags/free.md>), [interoperability](<https://devfeed.tech/tags/interoperability.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [platform](<https://devfeed.tech/tags/platform.md>), [technical](<https://devfeed.tech/tags/technical.md>)

### AI overview

The article promotes Trino Fest 2024 and highlights developments in the data platform ecosystem, including Snowflake's open source Polaris catalog, Databricks' acquisition of Tabular, and Trino's interoperability with Delta Lake, Hudi, Iceberg, and the Iceberg REST catalog.

### Source excerpt

This week has surely started off with a big bang and another boom in the data platform world. Snowflake introduced the open source Polaris catalog as implementation of the Iceberg REST catalog specification. And Databricks, the main driver of the Delta Lake table format, announced their acquisition of Tabular, a main driver in the Apache Iceberg community. Interestingly enough, Trino is in the middle of all this with great support for Delta Lake, Hudi, Iceberg, and also the Iceberg REST catalog. And if all that interoperability with Trino is not enough reason to join us next week at Trino Fest 2024, I have some more ideas for you to consider.

## Big names round out the Trino Fest 2024 lineup

DevFeed: [Big names round out the Trino Fest 2024 lineup](<https://devfeed.tech/articles/big-names-round-out-the-trino-fest-2024-lineup-8755.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/05/08/trino-fest-lineup-finalized.html>)

Author: Cole Bowden

Published: 2024-05-08T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [Azure](<https://devfeed.tech/topics/azure.md>), [Caching](<https://devfeed.tech/topics/caching.md>), [Deployment](<https://devfeed.tech/topics/deployment.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Slack](<https://devfeed.tech/topics/slack.md>)

Tags: [announcement](<https://devfeed.tech/tags/announcement.md>), [azure](<https://devfeed.tech/tags/azure.md>), [caching](<https://devfeed.tech/tags/caching.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [event](<https://devfeed.tech/tags/event.md>), [events](<https://devfeed.tech/tags/events.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [slack](<https://devfeed.tech/tags/slack.md>), [us](<https://devfeed.tech/tags/us.md>)

### AI overview

The article announces the finalized lineup for Trino Fest 2024, a hybrid event in Boston and online on June 13. Talks will cover Trino use cases, migrations, administration, lakehouse integrations, and deployments. Microsoft speakers will discuss Trino clients, integrations, result caching, monitoring visualization, and Azure deployment, while Apple speakers will present work on Trino query intelligence.

### Source excerpt

We gave a sneak peek of the Trino Fest lineup a month ago, and we're excited to now bring you the full lineup for the event. We've got some major names being added, including Amazon, Microsoft, and another talk from Apple. With Fourkites and a joint talk with LanceDB and CharacterAI also added to the schedule, we're excited to present the full lineup for Trino Fest 2024. Trino Fest is barely a month away on the 13th of June, and whether you want to attend live in Boston or tune in virtually, this is a reminder that you should register to attend!

## A sneak peek of Trino Fest 2024

DevFeed: [A sneak peek of Trino Fest 2024](<https://devfeed.tech/articles/a-sneak-peek-of-trino-fest-2024-8754.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/04/15/trino-fest-2024-approaches.html>)

Author: Cole Bowden

Published: 2024-04-15T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [community](<https://devfeed.tech/tags/community.md>), [networking](<https://devfeed.tech/tags/networking.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [streaming](<https://devfeed.tech/tags/streaming.md>)

### AI overview

The article previews Trino Fest 2024, an in-person and livestreamed event in Boston featuring talks on lakehouse table formats. It highlights sessions about Apache Iceberg, including Iceberg views and migration from Snowflake to open table formats, alongside presentations on Delta Lake and Hudi connectors.

### Source excerpt

Trino Fest is drawing ever closer. Commander Bun Bun has been hard at work behind the scenes arranging the schedule and making sure that Trino's trip to Boston is going to be a great one. In case you missed it, we announced Trino Fest a couple months ago, and if you have missed it, make sure to go register to attend! All our speakers will be in person in downtown Boston on the 13th of June, with plenty of opportunities for networking and a happy hour event at the end of the day. But if you can't make the trip to enjoy the lovely New England summer, we'll also be live-streaming the event, and you can register to join us virtually. Register to attend! Still on the fence, though? Read on for a preview of our speaker lineup and brief summaries of their talks. Keep in mind this also isn't the full lineup, and we'll follow up soon with the last few talks that round out the schedule.

## Blazing ahead with 22

DevFeed: [Blazing ahead with 22](<https://devfeed.tech/articles/blazing-ahead-with-22-8752.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/03/13/java-22.html>)

Author: Manfred Moser, Martin Traverso, Dain Sundstrom, David Phillips

Published: 2024-03-13T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Code](<https://devfeed.tech/topics/code.md>), [API](<https://devfeed.tech/topics/api.md>), [Concurrency](<https://devfeed.tech/topics/concurrency.md>), [Hardware](<https://devfeed.tech/topics/hardware.md>), [releases](<https://devfeed.tech/topics/releases.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [contributors](<https://devfeed.tech/tags/contributors.md>), [ecosystem](<https://devfeed.tech/tags/ecosystem.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [innovation](<https://devfeed.tech/tags/innovation.md>), [java](<https://devfeed.tech/tags/java.md>), [jvm](<https://devfeed.tech/tags/jvm.md>), [performance](<https://devfeed.tech/tags/performance.md>), [readability](<https://devfeed.tech/tags/readability.md>), [vector](<https://devfeed.tech/tags/vector.md>)

### AI overview

Trino plans to adopt and require Java 22 for building and running the project. The move is intended to improve performance and runtime behavior, modernize the codebase with newer language features and APIs, support Project Hummingbird work, and attract contributors. The article also outlines planned experimentation with several Java 22 JEPs, including Vector API, Structured Concurrency, Scoped Values, and the Foreign Function & Memory API.

### Source excerpt

It was not that long ago that we first announced support for Java 21, and subsequently made it a build and runtime requirement with Trino 436. Since then, the codebase received some significant improvements in readability, and we have also seen better performance. However, innovation in Trino and Java is not holding still, on the contrary - it's accelerating. On the Java community side, Java 22 is just about to be released, and we think it is time to drive innovation in Trino even further. Trino is going to use and require Java 22 soon!

## A cache refresh for Trino

DevFeed: [A cache refresh for Trino](<https://devfeed.tech/articles/a-cache-refresh-for-trino-8751.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/03/08/cache-refresh.html>)

Author: Manfred Moser

Published: 2024-03-08T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Cache](<https://devfeed.tech/topics/cache.md>), [Caching](<https://devfeed.tech/topics/caching.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Pull Request](<https://devfeed.tech/topics/pull-request.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [caching](<https://devfeed.tech/tags/caching.md>), [collaboration](<https://devfeed.tech/tags/collaboration.md>), [github](<https://devfeed.tech/tags/github.md>), [object-storage](<https://devfeed.tech/tags/object-storage.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [pull-request](<https://devfeed.tech/tags/pull-request.md>), [release](<https://devfeed.tech/tags/release.md>), [reviews](<https://devfeed.tech/tags/reviews.md>), [slack](<https://devfeed.tech/tags/slack.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

The article describes a refresh of Trino's file-system caching in the Trino 439 release. The new Alluxio-powered caching benefits catalogs using the Delta Lake, Hive, Iceberg, and planned Hudi connectors, replacing the outdated RubiX-based approach through extensive community collaboration.

### Source excerpt

Thinking about our recent work on caching in Trino reminds me of the famous saying, "There are only two hard things in computer science: cache invalidation and naming things." Well, in the Trino community we know all about caching and naming. With the recent Trino 439 release, caching from object storage file systems got a refresh. Catalogs using the Delta Lake, Hive, Iceberg, and soon Hudi connectors now get to access performance benefits from the new Alluxio-powered file system caching.

## Open Policy Agent for Trino arrived

DevFeed: [Open Policy Agent for Trino arrived](<https://devfeed.tech/articles/open-policy-agent-for-trino-arrived-8748.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/02/06/opa-arrived.html>)

Author: Manfred Moser

Published: 2024-02-06T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Open Policy Agent](<https://devfeed.tech/topics/open-policy-agent.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>), [Cloud Native Ecosystem](<https://devfeed.tech/topics/cloud-native-ecosystem.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Pull Request](<https://devfeed.tech/topics/pull-request.md>), [Code review](<https://devfeed.tech/topics/code-review.md>), [migration](<https://devfeed.tech/topics/migration.md>)

Tags: [access-control](<https://devfeed.tech/tags/access-control.md>), [cloud-native](<https://devfeed.tech/tags/cloud-native.md>), [migration](<https://devfeed.tech/tags/migration.md>), [opa](<https://devfeed.tech/tags/opa.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [policy](<https://devfeed.tech/tags/policy.md>), [pull-request](<https://devfeed.tech/tags/pull-request.md>), [review](<https://devfeed.tech/tags/review.md>)

### AI overview

Trino 438 introduces an access control integration with Open Policy Agent (OPA). The article recounts the collaboration that brought the integration to Trino, its presentation at Trino Summit 2023, migration from Apache Ranger, and demonstrations of OPA across data platforms.

### Source excerpt

Trino now ships with an access control integration using the popular and widely used Open Policy Agent (OPA) from the Cloud Native Computing Foundation. The release of Trino 438 marks an important milestone of the effort towards this integration.

## Trino 2023 wrapped

DevFeed: [Trino 2023 wrapped](<https://devfeed.tech/articles/trino-2023-wrapped-8747.md>)

Original publisher: [Read original article](<https://trino.io/blog/2024/01/19/trino-2023-wrapped.html>)

Author: Cole Bowden

Published: 2024-01-19T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Open Source](<https://devfeed.tech/topics/open-source.md>), [releases](<https://devfeed.tech/topics/releases.md>), [GitHub](<https://devfeed.tech/topics/github.md>), [pull-requests](<https://devfeed.tech/topics/pull-requests.md>), [Slack](<https://devfeed.tech/topics/slack.md>)

Tags: [events](<https://devfeed.tech/tags/events.md>), [github](<https://devfeed.tech/tags/github.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [pull-requests](<https://devfeed.tech/tags/pull-requests.md>), [releases](<https://devfeed.tech/tags/releases.md>), [slack](<https://devfeed.tech/tags/slack.md>), [summit](<https://devfeed.tech/tags/summit.md>), [technology](<https://devfeed.tech/tags/technology.md>)

### AI overview

A year-end recap of Trino's 2023 activity, covering community growth, development, events, releases, and new features and technologies. The article reports GitHub, YouTube, Slack, release, blog, and event figures, and highlights Trino Fest and Trino Summit.

### Source excerpt

If "Wrapped" is good enough for Spotify, it's good enough for Trino, right? As we look forward to a bright 2024, we can also take a moment to get sentimental, look back at everything we've accomplished, and reflect on the progress we've made. Commander Bun Bun has been hard at work, so if you haven't been paying close attention to Trino or want an idea of all that went down in 2023, we're happy to present you with an end of year recap. We'll be exploring what's gone on in the community, on development, the events we've hosted, and discuss the cool new features and technologies you can use when you're running Trino.

[Next page](<https://devfeed.tech/sources/trino-blog.md?cursor=WyIyMDI0LTAxLTE5VDAwOjAwOjAwKzAwOjAwIiwgImYzZjBhMjFhLTA2MmUtNGVlMy1iZDM3LWFkMzZjZWFhZDZhYiJd>)