Screen Shot 2021 04 02 at 4.05.58 PM

Presto vs Trino

PrestoDB =/= Trino. PrestoDB and Trino are two different github repos.

Ahana is a premier member of the Presto Foundation, which oversees PrestoDB.

PrestoDB runs at Facebook

Trino does not run at Facebook

presto db
logo meta

“At Facebook alone, over a thousand employees use Presto, running several million queries and processing petabytes of data per day. After creating Presto we open sourced it to see if other companies were having the same issues and wanted to collaborate. It turns out many other companies were interested and so under The Linux Foundation, we believe the project can engage others and grow the community for the benefit of all.”

Kathy Kam, Head of Open Source at Facebook.

A Brief History of Presto

linux foundation

2012:

Facebook develops Presto

Jan 2019:

The original creators of Presto leave Facebook and create a hard fork, confusingly named PrestoSQL, and put it in their own non-profit organization, the Presto Software Foundation

Sept 2019:

Facebook donates the original project to the Linux Foundation and establishes the Presto Foundation which includes founding members Facebook, Uber, Twitter, and Alibaba. The stated principles seek to unify the projects and negotiations ensue.

Nov 2019:

The creators become cofounders and CTOs of Starburst, a commercial vendor for their hard fork PrestoSQL.

Sept 2020:

Coinciding with the 1 year anniversary of the Presto Foundation, 650+ attend the first PrestoCon, with all sessions available on the Presto Foundation’s YouTube channel. Hear about all the innovations for PrestoDB in the past year in the keynote, what Facebook has planned, and what is the future vision as discussed by a panel of experts.

Dec 2020:

Negotiations with The Linux Foundation end, and the PrestoSQL hard fork is rebranded as Trino. The Presto Software Foundation is also rebranded at Trino Software Foundation. This makes it clear that these are two different, divergent projects.

Mar 2021:

Linux Foundation hosts the community event PrestoCon Day, highlighting all the innovations that are only in the PrestoDB project. All sessions are available on the Presto Foundation’s YouTube channel, including the future of Prest

Presto Rising

Presto is one of the fastest growing open source projects in the data analytics space.

star history 20221119
The Star history tool is fun. You can look back in time to see the star history of various open source projects. Try to chart out your favorite Github repos. Link

Only in Presto – Not in Trino

To understand more about Presto vs Trino, hear about the PrestoDB roadmap, watch this video from the Chair of the Technical Steering Committee and this one from Biswapesh Chattopadhyay, Tech Leader of Compute Infra at Facebook. Come join us in developing Presto, we welcome community participation. Below are some of the recent and current innovations.

Project Aria

PrestoDB can now push down entire expressions to the data source for some file formats like ORC. Blog Design

Project Presto Unlimited

Introduced exchange materialization to create temporary in-memory bucketed tables to use significantly less memory. PR Blog

Additional User Defined Functions

Support for dynamic SQL functions is now available in experimental mode. Docs

Presto-on-Spark

Presto on Spark Runs Presto code as a library within Spark executor. Facebook runs Presto for batch. Meetup talk Design Docs

Disaggregated Coordinator (a.k.a. Fireball)

Scale out the coordinator horizontally and revamp the RPC stack. In Beta in Q1 2021. PrestoCon Day Session (Mar 2021)

RaptorX Project

10x faster Presto with multiple level caching. PrestoCon Day Session (Mar 2021)

More About Presto vs Trino, and the PrestoDB Roadmap:

hqdefault
hqdefault
Come join us in developing Presto, we welcome community participation.

ahana logo is an ongoing contributor to PrestoDB.

Here are some of the recent features Ahana engineers have developed and open sourced:

  • Hive partial aggregate pushdowns
  • Parquet metadata cache
  • CSV support for Hive connector
  • Upgrade Hive support to 3.x
  • BigQuery connector
  • Apache Ranger plugin for Presto
  • Caching at different levels of abstraction

Presto Foundation: Community-driven Presto

presto foundation

The Presto Foundation is guided by three main principles defined here

1

One open, neutral and united Presto community

2

Open, transparent technical leadership and direction

3

No one individual or company is greater than the project and its community

Presto Foundation Members

Every member in the Presto Foundation works together towards these principles. The Presto Foundation is an industry consortium focused on growing the use of Presto and has grown to 10 members today. Everyone is welcome.

Read the blog on why neutral governance matters >

Linux Foundation and Open Source

linux

The Linux Foundation is dedicated to building sustainable ecosystems around open source projects to accelerate technology development and industry adoption. Founded in 2000, the Linux Foundation provides unparalleled support for open source communities through financial and intellectual resources, infrastructure, services, events, and training. Working together, the Linux Foundation and its projects form the most ambitious and successful investment in the creation of shared technology.

Open Source creates a lot of goodness for developers, technologists and organizations. But to foster collaboration, developers prefer projects that have governance & transparency. The Presto Foundation under the Linux Foundation brings this to PrestoDB.