Apache Pinot on Ubuntu 24.04 LTS

Apache Pinot on Ubuntu 24.04 LTS

Apache Pinot is a real-time distributed OLAP datastore designed to serve analytical queries with millisecond latency on both streaming and batch data, powering user-facing analytics at scale. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base.

What's included

• A single-node Pinot deployment (Controller, Broker, Server + bundled ZooKeeper) on OpenJDK 17, managed by systemd
• The Pinot Controller console on port 80, protected by HTTP Basic authentication
• A unique admin password generated on first boot (no shared default credential)
• The bundled `baseballStats` quickstart table loaded so the query console returns real data
• Cluster state and segments on a dedicated managed data disk
• Automatic security updates enabled

Getting started

Browse to the VM's public IP and sign in with the credentials from `sudo cat /root/pinot-credentials.txt`. Use the query console to run SQL against the sample table, or create your own tables and ingest from Kafka or batch sources. The deployment guide on cloudimg.co.uk covers schema/table creation and ingestion.