Trino Community

Trino Community Broadcast

Technology EN ↓ 63 episodes

Trino Community Broadcast is a show where we cover events and happenings within the open-source Trino community and show off some cool stuff about Trino. Learn more at https://trino.io

Author

Trino Community

Episodes

13: Trino takes a sip of Pinot! 22.03.2021 1:25:31

- 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 Connector: 1:12:18 - Get involved with Pinot: 1:22:...

12: Trino gets super visual with Apache Superset! 08.03.2021 1:33:30

- 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 Superset: 1:25:06 - Question of the Week: How do...

11: Dynamic Filtering and Dynamic Partition Pruning 24.02.2021 1:16:29

- 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/

10: Naming the bunny! 18.02.2021 42:05

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/

9: Distributed hash-joins, and how to migrate to Trino 11.02.2021 1:03:14

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/

8: Trino: A Ludicrously Fast Query Engine: Past, Present, and Future 11.01.2021 1:09:47

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 Presto fork: 26:14 - Past: Why did you choose to conti...

7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster? 21.12.2020 1:11:55

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? 1:02:24 Show Notes: https://trino.io/episodes/7....

6: Query Planning, Remove duplicate predicates, and Memory settings 07.12.2020 1:11:23

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: https://trino.io/broadcast/

5: Hive Partitions, sync_partition_metadata, and Query Exceeded Max Columns! 23.11.2020 1:07:48

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 columns.' error? 1:00:56 Show Notes: https://trino...

4: Presto on ACID, row-level INSERT/DELETE, and why JDK11? 10.11.2020 1:01:17

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/episodes/4.html Show Page: https://trino.io/broadcast/

3: Running two Presto distributions and Kafka headers as Presto columns 23.10.2020 1:08:17

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/

2: Kubernetes, arrays on Elasticsearch, and security breaks the UI 08.10.2020 1:04:32

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/2.html Show Page: https://trino.io/broadcast/

1: What is Presto, WITH RECURSIVE, and Hive connector 25.09.2020 1:01:05

Table of Contents: - Intro: 2:58 - News: 6:48 - Concept of the week: What is Presto? - 24:37 - PR of the week: PR 5163 WITH RECURSIVE - 39:05 - Question of the week: Does the Hive connector depend on the Hive runtime? - 48:38 Show Notes: https://trino.io/episodes/1.html Show Page: https://trino.io/broadcast/