1: Presto Community Broadcast 2020-9-24

Presto nation, We want to hear from you! If you have a question or pull request that you would like us to feature on the show please join the Presto slack https://prestosql.io/slack and go to the #presto-community-broadcast channel and let us know there. Otherwise you can message Manfred Moser or Brian Olsen directly. Also feel free to reach out to us on our twitter channels Brian (https://twitter.com/bitsondatadev) and Manfred (https://twitter.com/simpligility).

Today’s concept covers a big overview of what Presto is for those that are new to Presto. For mor information about Presto, check out the following resources:

Website: https://prestosql.io/

Documentation https://prestosql.io/docs/current/

Download the Free Presto O’Rielly Book: https://www.starburstdata.com/oreilly-presto-guide-download/

Learn how to contribute: https://prestosql.io/development/

Join our community on the slack channel: https://prestosql.io/slack

In todays PR we covered pull request 5163 (https://github.com/prestosql/presto/pull/5163) which is actually just a documentation update around the existing experimental features of the WITH RECURSIVE feature. The extended development of this feature is still being tracked and documented in issue 1122 (https://github.com/prestosql/presto/issues/1122). As with many problems in recursion, the solution space typically exponentially increases and so it is something that can easily be misused and cause problems. We run the query and discuss it as well as some of the things that can go wrong. Check out the pull request to see more documentation that was added around it.

In today’s question, we covered a lot of the confusion around hte hive-connector (https://prestosql.io/docs/current/connector/hive.html). Feel free to try out the katacoda example I created and will be nesting within my blog. This is running on a non-paid katacoda account so resources are scarce at times and it may take a while to load.

https://www.katacoda.com/bitsondatadev/scenarios/presto-s3-hive-connector Nevertheless, the information written around it will help you quickly have a Presto environment to play with.

Resources from the show:

Release Notes discussed:

https://prestosql.io/docs/current/release/release-341.html

Don’t forget to sign up for the Presto Newsletter.

https://www.starburstdata.com/presto-newsletter/

Upcoming events

https://www.meetup.com/BigDataATL/events/273435961/

https://edw2020chicago.dataversity.net/

https://techtalksummits.com/event/virtual-commercial-it-portland-or-2/

https://techtalksummits.com/event/virtual-commercial-it-minneapolis-mn-2/

https://techtalksummits.com/event/virtual-commercial-it-jacksonville-fl/

https://www.evanta.com/cdo/san-francisco/2020-san-francisco-cdo-virtual-executive-summit

https://techtalksummits.com/event/virtual-commercial-it-detroit-mi/

https://www.evanta.com/cdo/atlanta/2020-atlanta-cdo-virtual-executive-summit

https://techtalksummits.com/event/virtual-commercial-it-providence-ri/

https://techtalksummits.com/event/virtual-commercial-it-denver-co/

https://www.evanta.com/cdo/boston/2020-boston-cdo-virtual-executive-summit

Latest training from David, Dain, and Martin:

https://prestosql.io/blog/2020/07/15/training-advanced-sql.html

https://prestosql.io/blog/2020/07/30/training-query-tuning.html

https://prestosql.io/blog/2020/08/13/training-security.html

https://prestosql.io/blog/2020/08/27/training-performance.html

Presto Summit Series - Real world usage

https://prestosql.io/blog/2020/05/15/state-of-presto.html

https://prestosql.io/blog/2020/06/16/presto-summit-zuora.html

https://prestosql.io/blog/2020/07/06/presto-summit-arm-td.html

https://prestosql.io/blog/2020/07/22/presto-summit-pinterest.html

Recent Podcasts:

https://www.contributor.fyi/presto

https://www.dataengineeringpodcast.com/presto-distributed-sql-episode-149/

If you want to learn more about Presto yourself, you should check out the O’Reilly Presto Definitive guide. You can download the free PDF (https://www.starburstdata.com/oreilly-presto-guide-download/) or buy the book online.

Music for the show is from the Megaman 6 Game Play album by Krzysztof Słowikowski (https://krzysztofslowikowski.bandcamp.com/album/mega-man-6-gp). This show is sponsored by Starburst Data. Check them out at https://www.starburstdata.com/.

Watch live every other Thursday at https://www.twitch.tv/prestosql