Trino Community Broadcast

- 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 duration for BigQuery Connector: 1:21:13

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

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

- 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 do I search nested objects in Elasticsearch from Trino?: 1:24:24

We didn't have time to run through the demo. I created another video outside of the show if you want need help with the contribution process: https://www.youtube.com/watch?v=gAqYkR2oGgM

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

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

- 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 Add format_number function: 1:01:55

- Demo: Showing the format_number functionality: 1:04:38

- Question of the week: How do I search nested objects in Elasticsearch from Trino?: 1:08:54

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

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

- 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:21:02

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

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

- 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

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

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

- 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?: 1:10:20

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

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

- 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 me?: 1:23:35

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

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

- 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 to the filesystem?: 1:18:39

Show Notes: https://trino.io/episodes/14.html​

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

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

Show Notes: https://trino.io/episodes/13.html​

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

- 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 I use the Trino REST api?: 1:29:02

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

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