Episodes

  • 7: Cost Based Optimizer, Decorrelate subqueries, and does Presto make my RDBMS faster?
    Dec 21 2020

    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/

    Show More Show Less
    1 hr and 12 mins
  • 6: Query Planning, Remove duplicate predicates, and Memory settings
    Dec 7 2020

    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/

    Show More Show Less
    1 hr and 11 mins
  • 5: Hive Partitions, sync_partition_metadata, and Query Exceeded Max Columns!
    Nov 23 2020

    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/

    Show More Show Less
    1 hr and 8 mins
  • 4: Presto on ACID, row-level INSERT/DELETE, and why JDK11?
    Nov 10 2020

    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/

    Show More Show Less
    1 hr and 1 min
  • 3: Running two Presto distributions and Kafka headers as Presto columns
    Oct 23 2020

    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/

    Show More Show Less
    1 hr and 8 mins
  • 2: Kubernetes, arrays on Elasticsearch, and security breaks the UI
    Oct 8 2020

    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/

    Show More Show Less
    1 hr and 5 mins
  • 1: What is Presto, WITH RECURSIVE, and Hive connector
    Sep 24 2020

    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/

    Show More Show Less
    1 hr and 1 min