Presto Community Broadcast

By: Presto Community
  • Summary

  • 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
    ℗ & © 2020 Presto Community Broadcast
    Show More Show Less
activate_Holiday_promo_in_buybox_DT_T2
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

What listeners say about Presto Community Broadcast

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.