Presto (PrestoDB) 0.298, the open source distributed SQL query engine created at Meta and now hosted by the Linux Foundation's Presto Foundation, on Ubuntu 24.04 LTS by cloudimg. Run fast interactive analytic SQL across data of any size through pluggable connectors and monitor queries in the browsable Web console. Runs as a systemd service on OpenJDK 17, restricted to loopback behind nginx on port 443 with TLS and HTTP Basic auth; a unique console credential is generated on first boot so the console and query API are never open. Ships with the TPC-H, jmx and memory catalogs preloaded and the node data on a dedicated disk. Apache-2.0 licensed. PrestoDB is a distinct project from the Trino fork and cloudimg is not affiliated with the Presto Foundation.
## Presto on Ubuntu 24.04 by cloudimg
Presto (PrestoDB) is a high performance, open source distributed SQL query engine for running fast, interactive analytic queries against data of any size. It was created at Meta (Facebook) and is now hosted by the Linux Foundation's Presto Foundation. Presto queries data where it lives through pluggable connectors, so a single ANSI SQL statement can join across data lakes, relational databases and object storage, and it ships a browsable Web console for monitoring queries and the cluster. This is PrestoDB, which is a distinct project from the Trino fork.
This cloudimg image installs Presto 0.298.1 from the official distribution and runs it as the dedicated presto system service under OpenJDK 17, as a single node coordinator and worker ready to query out of the box. The built in tpch, jmx and memory catalogs are preloaded so you can run real SQL immediately with no external data source, and the node data directory lives on a dedicated Azure data disk.
### Secure by default
Presto ships with no authentication of its own, which would leave its console and query API open to anyone on the network. This image never exposes it directly: the coordinator is restricted to loopback by an nftables guard plus the network security group, and nginx on port 443 is the only reachable surface, terminating TLS with a per VM self signed certificate and enforcing HTTP Basic authentication. A unique console credential is generated on the first boot of every VM, so no VM ever ships with a known or blank credential. Anonymous requests to the Web console and the query API return HTTP 401; only the per instance credential is accepted.
### Licensing
Presto is licensed under the Apache License 2.0, free and open source with no per CPU or per deployment fee. Presto is a trademark of the Presto Foundation and The Linux Foundation; cloudimg is not affiliated with or endorsed by the Presto Foundation or The Linux Foundation. cloudimg provides packaging, credential and TLS automation, security patching, and 24/7 support with a guaranteed 24 hour response SLA.