More details at https://trino.io/episodes/59

Interview with István Mészáros about Mitzu. More details at https://trino.io/episodes/58

Interview with David Phillips and Matt Stepenson about OpenTelemetry integration in Trino and usage with Starburst Galaxy. More details at https://trino.io/episodes/57

Interview with Colleen Tartow and Roman Zeyde from VAST about the database and platform and how it works with Trino. More details at https://trino.io/episodes/56

Timestamps: - 0:00 Intro - 1:36 Releases 437-438 - 4:12 Introducing Peaka - 8:07 An overview of Peaka - 16:02 The engineering of Peaka - 20:04 Connectors - 26:51 Peaka demo - 41:34 Managing catalogs and security - 51:06 Peaka wrap-up - 53:14 PR of the episode: Filesystem caching with Alluxio - 56:16 Outro…

Martin, Manfred and Cole look back at the year 2023 for the Trino project and the Trino community.

We chat with Matthew Mullins and Roman Nesterov about Coginiti, a enterprise SQL workbench and collaboration tool with Trino support. More information at https://trino.io/episodes/53

Timestamps: - 0:00 Intro - 1:48 Releases 428-430 - 6:30 Introducing Denis Magda from @YugabyteDB - 7:56 JDBC, Trino's JDBC driver, and the Postgres connector - 14:08 Introducing YugabyteDB - 21:33 Demo time! Trino with PostgreSQL - 29:56 Demoing Trino with YugabyteDB - 44:57 Failover and resiliency - 56:05 Upcoming events and Trino Summit soon!…

When you're running a world-class, highly-performant query engine like Trino and investing time and resources into maintaining it, wouldn't it be great to treat your queries as a first-class, collaborative, versioned system, too?Enter PopSQL, a SQL client that makes it easier than ever to work together on Trino queries, collaborate with teammates, …

50 episodes is a big number! With the episodes coming once a month, this has been years in the making, so we're inviting back Trino co-founder Dain Sundstrom and Trino/Iceberg Developer Advocate Brian Olsen to catch up, share some stories, and talk about what it takes to maintain an open source project for so long.…

We heard from Phillip Cloud at Voltron Data during Trino Fest, but in this episode, we take a deeper dive into what Ibis is, how you can use it with Trino, and why you'd want to do that.

We’ve put out nearly 50 Trino Community Broadcast episodes, but we haven’t yet done the simplest, most obvious topic of them all - an exploration of what Trino is, how Trino works, and how you can run it. This week, we’re taking a step back and doing a broader overview of those things, because the world needs to know… what is Trino?…

Just a few weeks ago, Trino added two new maintainers to help govern its open source codebase: James Petty from AWS, and Manfred Moser from Starburst Data. It's not every day that new maintainers are added to an open source project, so let's take some time to get to know them, their history with Trino, and how they ended up here!…

- Intro Music: 0:00 - Intro: 0:31 - Trino releases 408-410: 2:02 - Introducing the Ignite connector to Trino: 5:30 - What is Ignite?: 7:30 - Contributing the Ignite connector: 10:10 - PR of the episode: 52:20

DolphinScheduler is a popular Apache data workflow orchestrator that enables running complex data pipelines. They recently added a Trino integration and will be demonstrating how to use DolphinScheduler to enable a series of transformations on the data lakehouse with Trino. - Intro Music: 0:00 - Intro: 0:31 - Trino release 407: 13:22 - What is work…

In episode 44 we have guests from Starburst and Metabase. with us for the show. They collaborated on creating support for Metabase with Trino and made it available as open source project. We will dive into how this all came together, learn about some cool features of the combination of Metabase and Trino and just generally geek out.Show notes: http…

Let's face it, out of all those petabytes of data you've been hoarding, only a small fraction of it is creating business value for you today. When you scan the same data multiple times and transfer it over the wire, you're wasting time, compute cycles, and ultimately money. This gets worse when you're pulling data across regions or clouds from disa…

We're going to discuss all of the awesome sessions that happened during Trino Summit this year. Manfred, Cole, and I will be joined by Martin, Dain, Brian Zhan, and Claudius for their, perspective and what they found most interesting about the summit. We also dive into stats around the summit and some exciting topics discussed off-camera. We'll als…

Trino's initial use case was around replacing the Apache Hive runtime. As data lakes grew into prominence, it became clear that having a faster query engine didn't solve all problems. The Hive model itself was a huge bottleneck and didn't provide features that companies needed akin to data warehouses and databases. Apache Hudi is a new table format…

Join us for this next episode of the broadcast, where we bring back Ryan Blue, the creator of Iceberg, to discuss some of the latest happenings in the Iceberg community. We also discuss and demo a bunch of new features that have come out in the Trino Iceberg connector. We also have a new guest, Tabular Developer Advocate Sam Redai, shedding light o…

In this episode we sit down with engineers, Steve Morgan and Edward Morgan, to discuss how they use Trino at Raft. Raft provides consulting services and is particularly skilled at DevSecOps. One particular challenge they face is dealing with fragmented government infrastructure. In this episode, we dive in to learn how Trino enables Raft to supply …

We'll be doing a more focused look at a specific feature that's being added to Trino: polymorphic table functions. We're excited to talk about what they do, where we are so far, where we're going, and how you can leverage them to make Trino better than ever! Show Notes: https://trino.io/episodes/38.html Show Page: https://trino.io/broadcast/ YouTub…

This episode covers will introduce the benefits of having the Trino community around the Trino project. What is the purpose of communities in tech projects? Would the product be successful without a community or anyone to maintain it? We introduce some new faces that will be stewards in our journey to growing the adoption of our favorite query engi…

As Trino preps to jump to Java 17, we discuss the latest features added Java 11 to Java 17, talk with Martin through a few of the potential uses of new features like the Vector API, language improvements, and G1GC speedups, and finally, we will dive into discussing some of the features that we'll be implementing in the upcoming months under a new p…

In our Trino Community Broadcast episode 35 we are catching up on recent releases 375, 376, 377, and 378. We then talk about how Trino is packaged as tarball, rpm, and docker container, what some of the differences are, and how you can customize either of them. Beyond we also look for your feedback and input on usage of the different packages. As a…

News from the Trino releases 372, 373, and 374, and an update on Project Tardigrade are the start. Then we dive into the details of the new Delta Lake connector contributed to Trino by Starburst. - Intro song: 00:00 - Intro: 00:37 - Releases: 2:05 - Project Tardigrade update: 9:21 - Concept of the episode: A new connector for Delta Lake object stor…

Goldman Sachs uses Trino to reduce last-mile ETL and provide a unified way of accessing data through federated joins. Making a variety of data sets from different sources available in one spot for our data science team was a tall order. Data must be quickly accessible to data consumers and systems like Trino must be reliable for users to trust this…

- Intro Song: 00:00​ - Intro: 00:33 - News: 8:02 - Concept of the week: K8s architecture: Containers, Pods, and kubelets: 14:27 - PR of the week: PR 11 Merge contributor version of k8s charts with the community version: 55:20 - Demo: Running the Trino charts with kubectl: 57:42 Show Notes: https://trino.io/episodes/24.html Show Page: https://trino.…

- Intro Song: 00:00​ - Intro: 00:34​ - News: 5:18​ - Concept of the week: Row pattern matching and MATCH_RECOGNIZE: 14:26 - PR of the week: PR 8348 Document row pattern recognition in window: 52:16 - Demo: Showing MATCH_RECOGNIZE functionality by example: 57:13 - Question of the week: How do you tag a list of rows with custom periodic rules?: 1:12:…

This episode will cover LinkedIn's journey to upgrade from PrestoSQL to Trino and some of the operational challenges LinkedIn's engineering team has faced at their scale. - Intro Song: 00:00​ - Intro: 00:36 - News: 7:39 - Concept of the week: Trino usage at LinkedIn: 15:55 - Concept of the week: Trino hardware and operational scale: 23:23 - Concept…

- Intro Song: 00:00​ - Intro: 00:35 - News: 7:42​ - Question of the week: Can dbt connect to different databases in the same project?: 18:18 - Concept of the week: What is dbt?: 21:28 - Concept of the week: dbt + Trino: 38:09 - Demo: Querying Trino from a dbt project: 47:21 - PR of the week: PR 8283 Externalised destination table cache expiry durat…

- Intro Song: 00:00​ - Intro: 00:35 - News: 10:16​ - Concept of the week: Trino for the Trinewbie: 19:12 - Concept of the week: Marius' Journey: 21:03 - Concept of the week: Contributing to Trino: 54:55 - PR of the week: PR 8135 Set default time zone for the current session: 1:03:36 - Demo: Contributing to Trino: 1:11:49 - Question of the week: How…

- Intro Song: 00:00​ - Intro: 00:37 - News: 7:56​ - Concept of the week: Ingesting into Iceberg with Pulsar and Flink at BlueCat: 17:30 - Concept of the week: BlueCat Overview: 20:31 - Concept of the week: Single Tenant to Multi-Tenant: 21:33 - Concept of the week: Pre-Iceberg: 26:13 - Concept of the week: Iceberg: 39:29 - PR of the week: PR 1905 A…

- Intro Song: 00:00​ - Intro: 00:34​ - News: 1:44​ - Concept of the week: Trino Views, Hive Views, and Materialized Views: 4:57 - PR of the week: PR 4832 Add Iceberg support for materialized views: 59:04 - Demo: Showing the different views in Trino: 1:01:25 - Question of the week: Are JDBC drivers backwards compatible with older Trino versions?: 1:…

- Intro Song: 00:00​ - Intro: 00:34​ - News: 2:52​ - Concept of the week: Resurface and the Resurface connector: 8:58 - PR of the week: PR 4022 Add Soundex function: 1:08:17 - Demo: Using the soundex function: 1:10:27 - Question of the week: Question of the week: How to export query results into a file (e.g. CTAS, but into a single file)?: 1:18:46 …

- Intro Song: 00:00​ - Intro: 00:34​ - News: 7:28​ - Concept of the week: Apache Druid and realtime analytics: 14:51 - PR of the week:PR 3522 Add Druid connector: 33:35 - Demo: Using the Druid Web UI to create an ingestion spec querying via Trino: 1:01:29 - Question of the week: Why doesn’t the Druid connector use the native json over http calls?: …

- Intro Song: 00:00​ - Intro: 00:34​ - News: 6:37​ - Concept of the week: Apache Iceberg and the Iceberg spec: 13:32 - PR of the week: PR 7233 Fix queries on tables without snapshot id: 1:07:44 - Demo: Creating tables with Iceberg and reading the data in Trino: 1:10:39 - Question of the week: What do I do to restart the test pipeline if it fails on…

- Intro Song: 00:00​ - Intro: 00:34​ - News: 7:57​ - Concept of the week: Apache Iceberg and the table format: 17:14 - PR of the week: PR 1067 Add Iceberg connector: 59:22 - Demo: Creating tables through Iceberg and reading them through Trino: 1:04:04 - Question of the week: Why do we still depend on the Hive metastore if metadata for Iceberg saves…

- Intro Song: 00:00​ - Intro: 00:34​ - News: 4:23​ - Concept of the week: Data cubes and Apache Pinot: 14:00 - Interview: Apache Pinot: 24:40 - PR of the week: PR 2028 Add Pinot connector: 53:51 - Question of the week: Why does my passthrough query not work in the Pinot connector?: 1:06:23 - Demo: Pinot batch insertion and query using Trino Pinot C…

- Intro Song: 00:00​​ - Intro: 00:34​​ - News : 2:57​​ - Concept of the week: Trino client, Python, and Apache Superset: 5:37​ - Interview: Apache Superset: 19:22​ - PR of the week: Superset PR 13105 feat: first step native support Trino: 46:37​ - PR Demo: PR Demo: Superset PR 13105 feat: first step native support Trino: 55:13​ - Get involved with …

- Intro Song: 00:00 - Intro: 00:34 - News : 3:22 - Concept of the week: Dynamic Filtering and Recap: 7:43 - PR of the week: PR 1072 Implement Dynamic Partition Pruning: 17:56 - PR Demo: PR 1072 Implement Dynamic Partition Pruning: 42:03 Show Notes: https://trino.io/episodes/11.html Show Page: https://trino.io/broadcast/…

Table of Contents: - Intro Song: 00:00 - Intro: 00:32 - Where did the bunny come from? : 8:58 - Bunny names in the running...: 16:58 - And our bunny's name is..: 20:15 - Release 352 sneak peek: 23:46 - Community stats update: 34:54 Show Notes: https://trino.io/episodes/10.html Show Page: https://trino.io/broadcast/…

Table of Contents: - Intro Song: 00:00 - Intro: 00:32 - Question of the week: How do I migrate to Trino from PrestoSQL? 11:55 - Concept of the week: Distributed hash-join 16:03 - Quick Discussion: Contributing Documents and Testimonials 58:05 Show Notes: https://trino.io/episodes/9.html Show Page: https://trino.io/broadcast/…

Table of Contents: - Intro Song: 00:00 - Intro: 00:32 - Martin Traverso Intro: 1:45 - Dain Sundstrom Intro: 4:30 - David Phillips Intro: 8:26 - Eric Hwang Intro: 12:24 - Past: Presto name, Facebook projects, and open source: 16:50 - Past: Where did the name Trino come from?: 23:16 - Past: Why Martin, Dain, and David left Facebook and created a Pres…

Table of Contents: - Intro Song: 00:00 - Intro: 00:20 - News: 3:27 - Concept of the week: Cost Based Optimizer 16:48 - PR of the week: PR 1415 Decorrelate subqueries with Limit or TopN 43:09 - PR Demo: EXPLAIN Decorrelate subqueries with Limit or TopN 53:36 - Question of the week: Will running Presto on my relational database make processing faster…

Table of Contents: - Intro Song: 00:00 - Intro: 00:20 - News: 12:32 - Concept of the week: Query Planning 20:31 - PR of the week: PR 730 Remove duplicate predicates 29:55 - PR Demo: Remove duplicate predicates demo 33:47 - Question of the week: How should I allocate memory properties? 54:49 Show Notes: https://trino.io/episodes/6.html Show Page: ht…

Table of Contents: - Intro Song: 00:00 - Intro: 00:20 - News: 05:26 - Concept of the week: Hive Partitioning 19:12 - PR of the week: PR 223 Add system.sync_partition_metadata procedure to sync Hive table partitions 29:20 - PR Demo: system.sync_partition_metadata procedure demo 34:57 - Question of the week: Why am I getting, 'Query exceeded maximum …

Table of Contents: - Intro: 0:20 - News: 3:56 - Concept of the week: Presto on ACID 19:35 - PR of the week: PR 5402 Hive ACID row-level INSERT and DELETE 27:24 - PR Demo: Hive ACID row-level INSERT and DELETE demo 42:26 - Question of the week: Why is JDK 11 required to run Presto and how can I revert to JDK8? 54:19 Show Notes: https://trino.io/epis…

Table of Contents: - Intro: 0:20 - News: 4:07 - Interview - Using multiple Presto distributions: 30:10 - PR of the week: PR 4462 Add Kafka headers as columns 51:35 Show Notes: https://trino.io/episodes/3.html Show Page: https://trino.io/broadcast/

Table of Contents: - Intro: 0:20 - News: 3:39 - Presto event - Presto for any company size: 14:49 - Concept of the week: Presto on Kubernetes 28:19 - PR of the week: PR 2441 Add array support using the _meta mapping in Elasticsearch 41:24 - Question of the week: Why does my ui say Web Interface disabled? 55:06 Show Notes: https://trino.io/episodes/…