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

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

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://prestosql.io/episodes/6.html

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

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

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

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://prestosql.io/episodes/4.html

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

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://prestosql.io/episodes/3.html

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

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://prestosql.io/episodes/2.html

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

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://prestosql.io/episodes/1.html

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