Running Pinot locally
This quick start guide will help you bootstrap a Pinot standalone instance on your local machine.
In this guide you'll learn how to download and install Apache Pinot as a standalone instance.
This is a quick start guide that will show you how to quickly start an example recipe in a standalone instance and is meant for learning. To run Pinot in cluster mode, please take a look at Manual cluster setup.

Download Apache Pinot

First, let's download the Pinot distribution for this tutorial. You can either build the distribution from source or download a packaged release.
Prerequisites
Install JDK11 or higher (JDK16 is not yet supported) For JDK 8 support use Pinot 0.7.1 or compile from source

Build from source or download the distribution

Build from source
Download the release
Follow these steps to checkout code from Github and build Pinot locally
Prerequisites
Install Apache Maven 3.6 or higher
1
# checkout pinot
2
git clone https://github.com/apache/pinot.git
3
cd pinot
4
5
# build pinot
6
mvn install package -DskipTests -Pbin-dist
7
8
# navigate to directory containing the setup scripts
9
cd pinot-distribution/target/apache-pinot-$PINOT_VERSION-bin/apache-pinot-$PINOT_VERSION-bin
Copied!
Add maven option -Djdk.version=8 when building with JDK 8
Note that Pinot scripts is located under pinot-distribution/target not target directory under root.
Download the latest binary release from Apache Pinot, or use this command
1
PINOT_VERSION=0.8.0 #set to the Pinot version you decide to use
2
3
wget https://downloads.apache.org/pinot/apache-pinot-$PINOT_VERSION/apache-pinot-$PINOT_VERSION-bin.tar.gz
Copied!
Once you have the tar file,
1
# untar it
2
tar -zxvf apache-pinot-$PINOT_VERSION-bin.tar.gz
3
4
# navigate to directory containing the launcher scripts
5
cd apache-pinot-$PINOT_VERSION-bin
Copied!

Setting up a Pinot cluster

We'll be using the quick-start scripts provided along with pinot distribution, which do the following:
    1.
    Set up the Pinot cluster QuickStartCluster
    2.
    Create a sample table and load sample data
The following quick start scripts are available. Please note though, these scripts launch the Pinot cluster with minimal resources. If you intend to play with sizable data (more than few MB), you may want to follow the Manual cluster setup and provide required resources.

Batch

Batch quick start creates the pinot cluster, creates an offline table baseballStats and pushes sample offline data to the table.
1
bin/quick-start-batch.sh
Copied!
That's it! We've spun up a Pinot cluster. You can continue playing with other types of quick start, or simply head on to Pinot Data Explorer to check out the data in the baseballStats table.

Streaming

Streaming quick start sets up a Kafka cluster and pushes sample data to a Kafka topic. Then, it creates the Pinot cluster and creates a realtime table meetupRSVP which ingests data from the Kafka topic.
1
# stop previous quick start cluster, if any
2
bin/quick-start-streaming.sh
Copied!
We now have a Pinot cluster with a realtime table! You can head over to Pinot Data Explorer to check out the data in the meetupRSVP table.

Hybrid

Hybrid quick start sets up a Kafka cluster and pushes sample data to a Kafka topic. Then, it creates the Pinot cluster and creates a hybrid table airlineStats . The realtime table ingests data from the Kafka topic. Lastly, sample data is pushed into the offline table.
1
# stop previous quick start cluster, if any
2
bin/quick-start-hybrid.sh
Copied!
Let's head over to Pinot Data Explorer to check out the data we pushed to the airlineStats table.
Last modified 1mo ago