Presto Community Newsletter March 2024
March 2024
We’re so excited to announce PrestoCon Day on June 25th, our free virtual community event 🎉 Latest release Presto 0.286 is now available, and if you’re in the Bay Area join us at VeloxCon next week to learn more about Presto 2.0 😀 As always, join us in the Presto community slack channel to connect with the community 👍
Upcoming Presto and community events 📅
April 3rd-4th: VeloxCon in San Jose, CA
VeloxCon is a free community-hosted event to discuss the Velox open-source project. Sessions from Meta, IBM, Pinterest, Google, Microsoft and many more. If you’re interested in learning more about Presto-on-Velox (code-named Prestissimo), engineers will be sharing more at VeloxCon. Register today!
June 25th: PrestoCon Day (virtual)
PrestoCon Day is our one-day virtual event for the Presto community. The CFP is now open — if you’re a Presto engineer or user and want to share what you’re doing with Presto, we’d ❤️ to hear from you. Registration is free, can’t wait to get our worldwide community together!
Presto 0.286 release ⭐
Key highlights from the latest release Presto 0.286 include:
- Support for adaptive partial aggregation which disables partial aggregation in cases where it could be inefficient
- Add additional linear regression functions like REGR_AVGX, REGR_AVGY, REGR_COUNT, REGR_R2, REGR_SXX, REGR_SXY, and REGR_SYY
- Add UPDATE sql support in Presto
- Lots of updates to Iceberg including:
- Prestissimo support for Iceberg catalog
- Fast equality delete as join support
- Support for time travel
- Support for reading v2 row level deletes in Iceberg connector
Thank you to the dozens of community members who helped make this release happen 💙 See full release notes
New Blog 📝
Elevating Presto Query Optimization: Leveraging State-of-the-Art Techniques for Improved Performance
Several of our Presto optimizer experts got together to write a detailed blog on Presto query optimization. The blog also includes initial designs on multi-query merge optimization, comprehensive join enumeration, cost-based logical transformations, and consistent cardinality estimation. Enjoy!
Join a Presto working group 💼
Want to contribute to a specific area of Presto? Join one of our working groups and start collaborating with other Presto users and maintainers:
The Presto Foundation public calendar is the best place to see all of the working group and community meetings!
Presto Foundation, 548 Market St., PMB 57274, San Francisco, CA 94104