Presto

Open source SQL query engine for data analytics and the Open Data Lakehouse. Official account of the Presto open source project.

[Presto @prestodb]

Just dropped: Presto 0.292 🚀

✅ Arrow Flight + ORC readers
✅ UPDATE support
✅ Iceberg sort orders
✅ Canonicalized JSON output
✅ Security + UI improvements

Get it: https://t.co/jKUiDskbuS
Release Notes: https://t.co/Q1HPWtfLxT

[Presto @prestodb]

Community Spotlight: @ZainSudan modernized their platform from Cloudera to a real-time data lakehouse powered by #Presto.

“Without Presto, direct connectivity between our visualization tools and the data lakehouse would have been impossible.”

Blog: https://t.co/po7VLYOAW1

[Presto @prestodb]

The #Presto Native Worker has been making huge strides!

Our focus continues to be:
✅ Migrating production workloads from Java to Native
✅ Expanding SQL coverage & lakehouse support
✅ Optimizing performance for large-scale workloads

See our latest blog https://t.co/XeaZyFyTKa

[Presto @prestodb]

Can't wait for the keynote panel on the Power of Open Data Platforms at #PrestoCon 🤩 Panelists will share experiences on using #opensource for data platforms & why they chose #Presto.

Reg: https://t.co/TO2W4hh4rE

@MetaOpenSource @MetaforDevs @denodo

[Presto @prestodb]

Join us at #PrestoCon in 2 weeks to see the latest work on #Presto C++ at @Meta covering:
⭐️ Migrating 50% of the batch workload to Presto C++
⭐️ Path to migrating 100% batch workloads to Presto C++

See agenda https://t.co/B9vkEkzknD

@MetaforDevs @MetaOpenSource @fb_engineering

[Presto @prestodb]

📣 #PrestoCon 2024 agenda published https://t.co/GtCZIjRlGO

We're excited to share our first round of agenda for PrestoCon, Dec 3-4 at @Meta offices in the Bay Area. Speakers from @UberEng, @boltapp, @alibaba_cloud, @IBMData, @denodo & more!

@UberOpenSource @MetaOpenSource

[Presto @prestodb]

A spooky reminder 👻 that the #PrestoCon CFP closes tmrw! If you're using #Presto, we encourage you to submit a talk https://t.co/CJ1u1v8Yct

PrestoCon will be Dec 3-4 @Meta offices, Bay Area. We can't wait to get everyone together! https://t.co/TO2W4hh4rE

Happy Halloween! 🧙 🎃

[Presto @prestodb]

#PrestoCon 2024 registration is now open! 🥳 Join us Dec 3-4 at Meta Bay Area offices with 2 days of workshops, keynotes & sessions from the #Presto community.

This year, PrestoCon is free for the community! Seats will go fast so grab a pass now 👉 https://t.co/RXnN0BeWqu

[Presto @prestodb]

📣 We're excited to announce that #PrestoCon 2024 will be Dec. 3-4 at @Meta offices, Bay Area! This year, we're making the conference free to attend & reg will open soon 🎉

CFP open: https://t.co/rvYCJE0ORb

If you're working on or using #Presto please submit a talk!

[Presto @prestodb]

Common Table Expression (CTE) materialization framework in #Presto helps minimize query-level redundant computations. See results from @UberEng:

📊 38% reduction in CPU usage
📊 40% less data read
📊 7% improved query latency

https://t.co/chxi5UJ3SA

[Presto @prestodb]

Query optimization is critical in distributed data processing systems. A framework used in #Presto is historical-based optimization which leverages historical execution statistics to create a more efficient query strategy.

Learn more in blog from @UberEng https://t.co/Fuupo7LtCA

[Presto @prestodb]

"@UberEng uses #Presto to query nearly every data source, in motion & at rest. Presto's versatility empowers us to make intelligent, data-driven business decisions." See @UberOpenSource blog on Garbage Collection tuning for improved Presto reliability 👏
https://t.co/NGD9erlNLN

[Presto @prestodb]

Check out #Presto TSC Chair @tdcmeehan1's latest blog on Presto C++ engine development & the path forward ➡ making it the default.

Why Presto C++?
⭐ Better memory management & performance
⭐ Hardware utilization
⭐ Disaggregation & future-proofing

https://t.co/DIpj6iMU66

[Presto @prestodb]

🗣 We recently added support in #Presto C++ for the Prometheus Reporter using the prometheus-cpp library, allowing for capture of Presto C++ runtime metrics & exposing them to a Prometheus time series database.

Learn more in our: https://t.co/MtPG2UfMLK

[Presto @prestodb]

Our new web-based #Presto Console was added to the UI in v0.286 🎉Thx to our awesome community members @bhumadev @IBMDeveloper who built & contributed the presto-js-client.

We'd ❤️ feedback! Tell us what you think and if you find it useful.

Blog: https://t.co/iitA97VOV8

[Presto @prestodb]

At #PrestoCon Day, @apnahq shared their data platform architecture and some pretty impressive #Presto stats:

👉 60K+ queries/day
👉 30TB+ scanned/day
👉 90+ users/day
👉 85+ nodes in cluster
👉 500+ tables

Recap blog: https://t.co/7gI6yN9gAy

[Presto @prestodb]

📣 We're hosting a hands-on virtual lab: Building an Open Data Lakehouse with #Presto + @ApacheIceberg

Date: Thurs, Aug 15 @ 10amPT
Reg: https://t.co/4MCywlYpim

This is a beginner-level workshop for software dev's who are building data platforms. Thx to @IBMData for leading it

[odbms.org @odbmsorg]

#News!
On the Presto Open Source Project. Q&A with Tim Meehan
"By far the greatest and most wide-ranging change we embarked on was splitting apart Presto’s execution engine and rewriting it in C++.  "
https://t.co/y0mhLbvopn
#opensource @linuxfoundation

[Presto @prestodb]

We heard from @eandegypt at #PrestoCon Day on how they optimize data analytics with #Presto. They shared their evolution from legacy data warehouse to data lake & Presto, including learnings from their evaluation of Presto and #Trino 👏

Recap blog: https://t.co/74nZaIbpcV

[Presto @prestodb]

📣 Presto 0.288 now available https://t.co/jKUiDskbuS
Highlights:
⭐ Improve handling of floating point numbers in Presto to consistently treat NaNs as larger than any other number and equal to itself
⭐ Add support for Iceberg REST catalog

Release notes: https://t.co/PYpvQFBcL0