zoom_in Click to enlarge

Presto

▲ ▼

language

description Presto Overview

Presto is an open-source, distributed SQL query engine designed for fast analytical queries against data of any size. It is unique in its ability to query data where it lives, including HDFS, S3, Cassandra, and relational databases, without the need for data movement. This makes it an excellent tool for federated queries across multiple data sources.

While it has been split into two major projects (PrestoDB and Trino), the original Presto remains a powerful tool for organizations that need to perform ad-hoc SQL analysis on massive, distributed datasets without the overhead of traditional ETL processes.

help Presto FAQ

Is Presto a database or a SQL query engine?

Presto is a distributed SQL query engine, not a database that stores and owns the data. A coordinator plans the query and worker nodes execute it across connected data sources.

Can Presto query S3, HDFS, and relational databases without copying data?

Yes, Presto uses connectors to query data where it already lives, including Amazon S3, HDFS, Cassandra, and relational databases. This lets analysts join or aggregate sources without first building one large warehouse copy.

What is the difference between Presto and Trino?

The community project formerly known as PrestoSQL was renamed Trino in 2020. PrestoDB remains a separate project, while both trace their origins to the Presto engine created at Facebook in 2012.

How does Presto differ from Hadoop MapReduce?

Presto is built for interactive SQL analysis with joins, aggregations, and window functions, while Hadoop MapReduce is mainly a batch-processing model. Presto was created at Facebook to reduce query latency over large Hadoop warehouses.

swap_horiz

Looking for Presto alternatives? Compare top competitors ranked & scored

arrow_forward