Skip to main content

Apache Presto

  • What it is
    • A distributed SQL query engine for interactive analytics — designed to answer ad hoc queries in seconds, over data where it already lives.
    • Queries across connectors (Amazon S3, HDFS, relational databases, Cassandra) and joins between them in one statement. It stores no data of its own.
    • The project forked; the actively developed branch is usually called Trino.
  • Where it runs on AWS
    • Amazon EMR as an installable application.
    • Amazon Athena is the serverless version of this idea — Athena is built on Presto/Trino.
  • Not to be confused with
    • Apache Hive — batch-oriented SQL, higher latency, better for long transformations. Presto is the interactive one.

Linked from