# prestodb/presto architecture

> Architecture diagram of the GitHub repository prestodb/presto, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/prestodb/presto
- Repository: https://github.com/prestodb/presto

## Overview

Presto is a distributed SQL query engine: clients submit SQL to a server, which manages query execution and exposes query information; connectors integrate data systems. The graph includes the documented CLI and console capabilities, sampled query-management and execution components, and the BigQuery connector as a concrete integration. Relationships are limited to README statements and SOURCE INDEX references or excerpts; dashed edges mark workflow links whose implementation was not shown.

Main entry points: [`presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`](https://github.com/prestodb/presto/blob/master/presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java) (SQL query manager), [`presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java`](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java) (Query execution), [`presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java`](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java) (Pipeline context), [`presto-cli/src/main/java/com/facebook/presto/cli/Completion.java`](https://github.com/prestodb/presto/blob/master/presto-cli/src/main/java/com/facebook/presto/cli/Completion.java) (Presto CLI)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_query["Query lifecycle"]
  node_cli["Presto CLI<br/>[Completion.java]"]
  node_server["SQL query manager"]
  node_queryexecution["Query execution"]
  node_queryinfo["Query information"]
  node_querystats["Query statistics"]
  node_querystate["Query state<br/>[QueryState.java]"]
  node_state["State machine<br/>[StateMachine.java]"]
  node_analyzer["SQL analysis"]
  node_console["Presto Console<br/>[QueryDetail.jsx]"]
end

subgraph group_execution["Distributed execution"]
  node_stageid["Stage identifier<br/>[StageId.java]"]
  node_pipeline["Pipeline context"]
  node_native["Native worker"]
end

subgraph group_connectors["Data connectors"]
  node_bigquery["BigQuery connector"]
  node_connectorcatalogs["Connector ecosystem"]
end

subgraph group_shared["Shared runtime"]
  node_session["Query session<br/>[Session.java]"]
  node_queryid["Query identifier<br/>[QueryId.java]"]
  node_errors["Error model"]
  node_errorcodes["Standard errors"]
  node_errorcode["Error code<br/>[ErrorCode.java]"]
  node_errortype["Error type<br/>[ErrorType.java]"]
  node_page["Data page<br/>[Page.java]"]
  node_arrays["Array utilities<br/>[Arrays.java]"]
  node_preconditions["Function preconditions<br/>[Preconditions.java]"]
end

node_client(("SQL client"))
node_bigqueryservice[("Google BigQuery")]

node_client -.->|"runs queries"| node_cli
node_cli -.->|"submits SQL"| node_server
node_server -->|"manages"| node_queryexecution
node_queryexecution -->|"updates statistics"| node_querystats
node_queryexecution -->|"reports query info"| node_queryinfo
node_server -->|"tracks queries"| node_queryid
node_server -->|"uses session"| node_session
node_client -.->|"submits SQL"| node_analyzer
node_queryexecution -.->|"tracks state"| node_querystate
node_querystate -.->|"state transitions"| node_state
node_console -.->|"views query details"| node_server
node_server -.->|"coordinates execution"| node_pipeline
node_pipeline -.->|"processes data"| node_page
node_bigquery -->|"queries"| node_bigqueryservice
node_connectorcatalogs -.->|"integrates sources"| node_bigquery
node_server -.->|"dispatches work"| node_native
node_server -.->|"reports failures"| node_errors
node_errors -.->|"uses codes"| node_errorcodes
node_errorcodes -.->|"defines values"| node_errorcode
node_errorcode -.->|"classifies"| node_errortype
node_pipeline -->|"uses utilities"| node_arrays
node_queryexecution -.->|"uses identifiers"| node_stageid
node_analyzer -.->|"validates arguments"| node_preconditions

click node_cli "https://github.com/prestodb/presto/blob/master/presto-cli/src/main/java/com/facebook/presto/cli/Completion.java"
click node_server "https://github.com/prestodb/presto/blob/master/presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java"
click node_queryexecution "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java"
click node_queryinfo "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/server/BasicQueryInfo.java"
click node_querystats "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryManagerStats.java"
click node_querystate "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryState.java"
click node_state "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/StateMachine.java"
click node_analyzer "https://github.com/prestodb/presto/tree/master/presto-analyzer/src/main/java/com/facebook/presto/sql/analyzer"
click node_console "https://github.com/prestodb/presto/blob/master/presto-ui/src/components/QueryDetail.jsx"
click node_session "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/Session.java"
click node_queryid "https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/QueryId.java"
click node_errors "https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/PrestoException.java"
click node_errorcodes "https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/StandardErrorCode.java"
click node_errorcode "https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/ErrorCode.java"
click node_errortype "https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/ErrorType.java"
click node_page "https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/Page.java"
click node_arrays "https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/array/Arrays.java"
click node_preconditions "https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/function/table/Preconditions.java"
click node_stageid "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/StageId.java"
click node_pipeline "https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java"
click node_bigquery "https://github.com/prestodb/presto/blob/master/presto-bigquery/src/main/java/com/facebook/presto/plugin/bigquery/BigQueryClient.java"
click node_connectorcatalogs "https://github.com/prestodb/presto/tree/master/presto-base-jdbc/src/main/java/com/facebook/presto/plugin/jdbc"
click node_native "https://github.com/prestodb/presto/blob/master/presto-native-execution/presto_cpp/main/QueryContextManager.cpp"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_cli,node_server,node_queryexecution,node_queryinfo,node_querystats,node_querystate,node_state,node_analyzer,node_console,node_client toneBlue
class node_stageid,node_pipeline,node_native,node_bigqueryservice toneAmber
class node_bigquery,node_connectorcatalogs toneMint
class node_session,node_queryid,node_errors,node_errorcodes,node_errorcode,node_errortype,node_page,node_arrays,node_preconditions toneRose
```

## Components

### Query lifecycle

- [Presto CLI](https://github.com/prestodb/presto/blob/master/presto-cli/src/main/java/com/facebook/presto/cli/Completion.java): `presto-cli/src/main/java/com/facebook/presto/cli/Completion.java`
- [SQL query manager](https://github.com/prestodb/presto/blob/master/presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java): `presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`
- [Query execution](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java): `presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java`
- [Query information](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/server/BasicQueryInfo.java): `presto-main-base/src/main/java/com/facebook/presto/server/BasicQueryInfo.java`
- [Query statistics](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryManagerStats.java): `presto-main-base/src/main/java/com/facebook/presto/execution/QueryManagerStats.java`
- [Query state](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/QueryState.java): `presto-main-base/src/main/java/com/facebook/presto/execution/QueryState.java`
- [State machine](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/StateMachine.java): `presto-main-base/src/main/java/com/facebook/presto/execution/StateMachine.java`
- [SQL analysis](https://github.com/prestodb/presto/tree/master/presto-analyzer/src/main/java/com/facebook/presto/sql/analyzer): `presto-analyzer/src/main/java/com/facebook/presto/sql/analyzer`
- [Presto Console](https://github.com/prestodb/presto/blob/master/presto-ui/src/components/QueryDetail.jsx): `presto-ui/src/components/QueryDetail.jsx`

### Distributed execution

- [Stage identifier](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/execution/StageId.java): `presto-main-base/src/main/java/com/facebook/presto/execution/StageId.java`
- [Pipeline context](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java): `presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java`
- [Native worker](https://github.com/prestodb/presto/blob/master/presto-native-execution/presto_cpp/main/QueryContextManager.cpp): `presto-native-execution/presto_cpp/main/QueryContextManager.cpp`

### Data connectors

- [BigQuery connector](https://github.com/prestodb/presto/blob/master/presto-bigquery/src/main/java/com/facebook/presto/plugin/bigquery/BigQueryClient.java): `presto-bigquery/src/main/java/com/facebook/presto/plugin/bigquery/BigQueryClient.java`
- [Connector ecosystem](https://github.com/prestodb/presto/tree/master/presto-base-jdbc/src/main/java/com/facebook/presto/plugin/jdbc): `presto-base-jdbc/src/main/java/com/facebook/presto/plugin/jdbc`

### Shared runtime

- [Query session](https://github.com/prestodb/presto/blob/master/presto-main-base/src/main/java/com/facebook/presto/Session.java): `presto-main-base/src/main/java/com/facebook/presto/Session.java`
- [Query identifier](https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/QueryId.java): `presto-spi/src/main/java/com/facebook/presto/spi/QueryId.java`
- [Error model](https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/PrestoException.java): `presto-spi/src/main/java/com/facebook/presto/spi/PrestoException.java`
- [Standard errors](https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/StandardErrorCode.java): `presto-spi/src/main/java/com/facebook/presto/spi/StandardErrorCode.java`
- [Error code](https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/ErrorCode.java): `presto-common/src/main/java/com/facebook/presto/common/ErrorCode.java`
- [Error type](https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/ErrorType.java): `presto-common/src/main/java/com/facebook/presto/common/ErrorType.java`
- [Data page](https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/Page.java): `presto-common/src/main/java/com/facebook/presto/common/Page.java`
- [Array utilities](https://github.com/prestodb/presto/blob/master/presto-common/src/main/java/com/facebook/presto/common/array/Arrays.java): `presto-common/src/main/java/com/facebook/presto/common/array/Arrays.java`
- [Function preconditions](https://github.com/prestodb/presto/blob/master/presto-spi/src/main/java/com/facebook/presto/spi/function/table/Preconditions.java): `presto-spi/src/main/java/com/facebook/presto/spi/function/table/Preconditions.java`

### Other components

- **SQL client**
- **Google BigQuery**

## Connections

- SQL client → Presto CLI: runs queries (evidence: `README.md`)
- Presto CLI → SQL query manager: submits SQL (evidence: `README.md`)
- SQL query manager → Query execution: manages (evidence: `presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`)
- Query execution → Query statistics: updates statistics (evidence: `presto-main-base/src/main/java/com/facebook/presto/execution/QueryManagerStats.java`)
- Query execution → Query information: reports query info (evidence: `presto-main-base/src/main/java/com/facebook/presto/execution/QueryManagerStats.java`)
- SQL query manager → Query identifier: tracks queries (evidence: `presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`)
- SQL query manager → Query session: uses session (evidence: `presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`)
- SQL client → SQL analysis: submits SQL
- Query execution → Query state: tracks state
- Query state → State machine: state transitions
- Presto Console → SQL query manager: views query details (evidence: `README.md`)
- SQL query manager → Pipeline context: coordinates execution
- Pipeline context → Data page: processes data
- BigQuery connector → Google BigQuery: queries (evidence: `presto-bigquery/src/main/java/com/facebook/presto/plugin/bigquery/BigQueryClient.java`)
- Connector ecosystem → BigQuery connector: integrates sources
- SQL query manager → Native worker: dispatches work
- SQL query manager → Error model: reports failures (evidence: `presto-main/src/main/java/com/facebook/presto/execution/SqlQueryManager.java`)
- Error model → Standard errors: uses codes
- Standard errors → Error code: defines values (evidence: `presto-spi/src/main/java/com/facebook/presto/spi/StandardErrorCode.java`)
- Error code → Error type: classifies
- Pipeline context → Array utilities: uses utilities (evidence: `presto-main-base/src/main/java/com/facebook/presto/operator/PipelineContext.java`)
- Query execution → Stage identifier: uses identifiers (evidence: `presto-main-base/src/main/java/com/facebook/presto/execution/QueryExecution.java`)
- SQL analysis → Function preconditions: validates arguments
