Presto Community Broadcast

Presto Community

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

All Episodes

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:24Show Notes: https://prestosql.io/episodes/7.htmlShow Page: https://prestosql.io/broadcast/

Dec 2020

1 hr 11 min

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:49Show Notes: https://prestosql.io/episodes/6.htmlShow Page: https://prestosql.io/broadcast/

Dec 2020

1 hr 11 min

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:56Show Notes: https://prestosql.io/episodes/5.htmlShow Page: https://prestosql.io/broadcast/

Nov 2020

1 hr 7 min

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:19Show Notes: https://prestosql.io/episodes/4.htmlShow Page: https://prestosql.io/broadcast/

Nov 2020

1 hr 1 min

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:35Show Notes: https://prestosql.io/episodes/3.htmlShow Page: https://prestosql.io/broadcast/

Oct 2020

1 hr 8 min

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:06Show Notes: https://prestosql.io/episodes/2.htmlShow Page: https://prestosql.io/broadcast/

Oct 2020

1 hr 4 min

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:38Show Notes: https://prestosql.io/episodes/1.htmlShow Page: https://prestosql.io/broadcast/

Sep 2020

1 hr 1 min