Presto

Presto is built for high performance interactive querying with in-memory execution.

Key characteristics include:

• High scalability from 1 to 1000s of workers
• Flexibility to support a wide range of SQL use cases
• Highly pluggable architecture that makes it easy to extend Presto with custom integrations for security, event listeners, etc.
• Federation of data sources particularly data lakes via Presto connectors
• Seamless integration with existing SQL systems with ANSI SQL standard

A full deployment of Presto has a coordinator and multiple workers. Queries are sub‐ mitted to the coordinator by a client like the command line interface (CLI), a BI tool, or a notebook that supports SQL. The coordinator parses, analyzes and creates the optimal query execution plan using metadata and data distribution information. That plan is then distributed to the workers for processing. The advantage of this decoupled storage model is that Presto can provide a single view of all your data that has been aggregated into the data storage tier like Hadoop Distributed File System (HDFS).

Ahana, the Presto company, offers the only managed service for Presto on AWS with the vision to simplify open data lake analytics. Presto, the open-source project created by Facebook and used at Uber, Twitter, and thousands more, is the de facto standard for fast SQL processing on data lakes. As a leading member of the Presto community and Linux Foundation’s Presto Foundation, Ahana is also focused on fostering growth and evangelizing open-source Presto.