Trino Community Broadcast

Trino Community Broadcast

By Trino CommunityTechnology
Download on the App Store

Trino Community Broadcast episodes

  • 31: Trinites II: Trino on AWS Kubernetes Service
    Concept of the week: ReplicaSets, Deployments, and Services
    Demo of the month: Deploy Trino k8s to Amazon EKS
    PR of the week: PR 8921: Support TRUNCATE TABLE statement
    Question of the week: How do I run system.sync_partition_metadata with different catalogs?
    Show Notes: https://trino.io/episodes/31.html
    Show Page: https://trino.io/broadcast/
    1 hr 46 min
  • 30: Trino and dbt, a hot data mesh
    Concept of the week: Trino and dbt, a hot data mesh
    PR of the week: Partitioned table tests and fixed PR 9757
    Question of the week: What’s the difference between location and external_location?
    Show Notes: https://trino.io/episodes/30.html
    Show Page: https://trino.io/broadcast/
    1 hr 35 min
  • 29: What is Trino?
    Concept of the week: What is Trino?
    PR of the week: PR 8821 Add HTTP/S query event logger
    Question of the week: Does the Hive connector depend on the Hive runtime?
    Show Notes: https://trino.io/episodes/29.html
    Show Page: https://trino.io/broadcast/
    1 hr 12 min
  • 28: Autoscaling streaming ingestion to Trino with Pravega
    Concept of the week: Event Stream abstractions and Pravega
    Demo of the week: Event Stream abstractions and Pravega
    PR of the week: Pravega presto-connector PR 49
    Question of the week: What is the point of Trino Forum and what is the relationship to Trino Slack?
    Show Notes: https://trino.io/episodes/28.html
    Show Page: https://trino.io/broadcast/
    1 hr 34 min
  • 27: Trino gits to wade in the data LakeFS
    Concept of the week: LakeFS and Git on Object Storage
    Demo of the week: Running Trino on LakeFS
    PR of the week: PR 8762 Add query error info to cluster overview page in web UI
    Question of the week: Why are deletes so limited in Trino?
    Show Notes: https://trino.io/episodes/27.html
    Show Page: https://trino.io/broadcast/
    1 hr 22 min
  • 26: Trino Discovers Data Catalogs with Amundsen
    Concept of the week: Data discovery and Amundsen
    Concept of the week: Amundsen Architecture
    Concept of the week: Amundsen as a subcomponent to data mesh
    PR of the week: Index Trino Views
    Question of the week: Can I add a UDF without restarting Trino?
    Show Notes: https://trino.io/episodes/26.html
    Show Page: https://trino.io/broadcast/
    1 hr 21 min
  • 25: Trino Going Through Changes
    Concept of the week: Change Data Capture
    Concept of the week: Debezium
    Concept of the week: Debezium + Trino at Zomato
    PR of the week: PR 4140 Implement aggregation pushdown in Pinot
    Question of the week: Is there an array function that flattens a row into three rows?
    Show Notes: https://trino.io/episodes/25.html
    Show Page: https://trino.io/broadcast/
    1 hr 18 min
  • 24: Trinetes I: Trino on Kubernetes

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

    1 hr 13 min
  • 23: Trino looking for patterns

    - 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:51

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

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

    1 hr 22 min
  • 22: TrinkedIn: LinkedIn gets a Trino promotion

    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 of the week: Challenges operating at scale: 44:09

    - Concept of the week: Open source at LinkedIn: 48:36

    - Concept of the week: PrestoSQL to Trino upgrade challenges: 58:11

    - Concept of the week: PrestoSQL to Trino upgrade steps: 1:13:32

    - PR of the week: Digging into join queries: 1:33:18

    - Demo: How to research the performance of a join: 1:38:53

    - Question of the week: How can I query the Hive views from Trino?: 1:48:10

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

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

    0 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