Apache Drill is an open-source, schema-free SQL query engine for files, JSON, Parquet, and NoSQL/relational stores — query data where it lives, no ETL required. This image runs Drill on Ubuntu 24.04 LTS, hardened and fully patched, with the web query console on port 80 behind authentication, a unique per-VM password generated on first boot, and working storage on a dedicated disk. Maintained by cloudimg.
## Apache Drill on Ubuntu 24.04 LTS
Apache Drill is a distributed SQL engine that queries semi-structured and structured data in place — local files, JSON, Parquet, cloud object stores, and relational databases — using standard ANSI SQL with no predefined schema. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base.
### What's included
### Getting started
Retrieve the generated password with `sudo cat /root/drill-credentials.txt`, then sign in at the VM's public IP and run a query, e.g. `SELECT * FROM cp.`employee.json` LIMIT 5`. Configure storage plugins to query your own files and databases. The deployment guide on cloudimg.co.uk covers storage plugins and day-2 operations.