Trino Community Broadcast

Trino Community Broadcast

By Trino CommunityTechnology
Download on the App Store

Trino Community Broadcast episodes

  • 11: Dynamic Filtering and Dynamic Partition Pruning

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

    1 hr 17 min
  • 10: Naming the bunny!

    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/

    43 min
  • 9: Distributed hash-joins, and how to migrate to Trino

    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/

    1 hr 4 min
  • 8: Trino: A Ludicrously Fast Query Engine: Past, Present, and Future

    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 continue using Presto instead of rebranding?: 34:51

    - Past: How did the contending Presto drive us to rebrand as Trino?: 37:37

    - Present: Did you know this project would span decades and when did you know?: 39:40

    - Present: What tricks did you use to rename an entire project in the span of a week?: 46:55

    - Present: The top-level project nesting changes: 51:00

    - Present: Where did the bunny come from?: 52:59

    - Future: How do you move to Trino and how to handle breaking changes?: 55:52

    - Future: How to explain that you are using Trino and not Presto to your boss.: 58:26

    - Future: 2021 Trino Roadmap: 1:05:12

    - Outro: 1:08:07

    Show Notes: https://trino.io/episodes/8.html

    Show Page: https://trino.io/broadcast/

    1 hr 10 min
  • 7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?

    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.html

    Show Page: https://trino.io/broadcast/

    1 hr 12 min
  • 6: Query Planning, Remove duplicate predicates, and Memory settings

    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/

    1 hr 12 min
  • 5: Hive Partitions, sync_partition_metadata, and Query Exceeded Max Columns!

    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.io/episodes/5.html

    Show Page: https://trino.io/broadcast/

    1 hr 8 min
  • 4: Presto on ACID, row-level INSERT/DELETE, and why JDK11?

    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/

    1 hr 2 min
  • 2: Kubernetes, arrays on Elasticsearch, and security breaks the UI

    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 hr 5 min

About Trino Community Broadcast

From the publisher's feed

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