This tutorial shows you how to load data into Apache Druid from a Kafka stream, using Druid's Kafka indexing service.
The tutorial guides you through the steps to load sample nested clickstream data from the Koalas to the Max game into a Kafka topic, then ingest the data into Druid.
Before you follow the steps in this tutorial, download Druid as described in the quickstart using the automatic single-machine configuration and have it running on your local machine. You don't need to have loaded any data.
Download and start Kafka
Apache Kafka is a high-throughput message bus that works well with Druid. For this tutorial, use Kafka 2.7.0.
To download Kafka, run the following commands in your terminal:
curl -O https://archive.apache.org/dist/kafka/2.7.0/kafka_2.13-2.7.0.tgz
tar -xzf kafka_2.13-2.7.0.tgz
If you're already running Kafka on the machine you're using for this tutorial, delete or rename the
Druid and Kafka both rely on Apache ZooKeeper to coordinate and manage services. Because Druid is already running, Kafka attaches to the Druid ZooKeeper instance when it starts up.
In a production environment where you're running Druid and Kafka on different machines, start the Kafka ZooKeeper before you start the Kafka broker.
In the Kafka root directory, run this command to start a Kafka broker:
In a new terminal window, navigate to the Kafka root directory and run the following command to create a Kafka topic called
./bin/kafka-topics.sh --create --topic kttm --bootstrap-server localhost:9092
Kafka returns a message when it successfully adds the topic:
Created topic kttm.
Load data into Kafka
In this section, you download sample data to the tutorial's directory and send the data to your Kafka topic.
In your Kafka root directory, create a directory for the sample data:
Download the sample data to your new directory and extract it:
(cd sample-data && curl -O https://static.imply.io/example-data/kttm-nested-v2/kttm-nested-v2-2019-08-25.json.gz)
In your Kafka root directory, run the following commands to post sample events to the
gzcat ./sample-data/kttm-nested-v2-2019-08-25.json.gz | ./bin/kafka-console-producer.sh --broker-list localhost:9092 --topic kttm
Load data into Druid
Now that you have data in your Kafka topic, you can use Druid's Kafka indexing service to ingest the data into Druid.
To do this, you can use the Druid console data loader or you can submit a supervisor spec. Follow the steps below to try each method.
Load data with the console data loader
The Druid console data loader presents you with several screens to configure each section of the supervisor spec, then creates an ingestion task to ingest the Kafka data.
To use the console data loader:
Navigate to localhost:8888 and click Load data > Streaming.
Click Apache Kafka and then Connect data.
localhost:9092as the bootstrap server and
kttmas the topic, then click Apply and make sure you see data similar to the following:
Click Next: Parse data.
The data loader automatically tries to determine the correct parser for the data. For the sample data, it selects input format
json. You can play around with the different options to get a preview of how Druid parses your data.
jsoninput format selected, click Next: Parse time. You may need to click Apply first.
Druid's architecture requires that you specify a primary timestamp column. Druid stores the timestamp in the
__timecolumn in your Druid datasource. In a production environment, if you don't have a timestamp in your data, you can select Parse timestamp from:
Noneto use a placeholder value.
For the sample data, the data loader selects the
timestampcolumn in the raw data as the primary time column.
Click Next: ... three times to go past the Transform and Filter steps to Configure schema. You don't need to enter anything in these two steps because applying transforms and filters is out of scope for this tutorial.
In the Configure schema step, you can select data types for the columns and configure dimensions and metrics to ingest into Druid. The console does most of this for you, but you need to create JSON-type dimensions for the three nested columns in the data.
Click Add dimension and enter the following information. You can only add one dimension at a time.
After you create the dimensions, you can scroll to the right in the preview window to see the nested columns:
Click Next: Partition to configure how Druid partitions the data into segments.
dayas the Segment granularity. Since this is a small dataset, you don't need to make any further adjustments. Click Next: Tune to fine tune how Druid ingests data.
In Input tuning, set Use earliest offset to
True—this is very important because you want to consume the data from the start of the stream. There are no other changes to make here, so click Next: Publish.
Name the datasource
kttm-kafkaand click Next: Edit spec to review your spec.
The console presents the spec you've constructed. You can click the buttons above the spec to make changes in previous steps and see how the changes update the spec. You can also edit the spec directly and see it reflected in the previous steps.
Click Submit to create an ingestion task.
Druid displays the task view with the focus on the newly created supervisor.
The task view auto-refreshes, so wait until the supervisor launches a task. The status changes from Pending to Running as Druid starts to ingest data.
Navigate to the Datasources view from the header.
kttm-kafkadatasource appears here, you can query it. See Query your data for details.
If the datasource doesn't appear after a minute you might not have set the supervisor to read data from the start of the stream—the
Use earliest offset setting in the Tune step. Go to the Ingestion page and terminate the supervisor using the Actions(...) menu. Load the sample data again and apply the correct setting when you get to the Tune step.
Submit a supervisor spec
As an alternative to using the data loader, you can submit a supervisor spec to Druid. You can do this in the console or using the Druid API.
Use the console
To submit a supervisor spec using the Druid console:
Click Ingestion in the console, then click the ellipses next to the refresh button and select Submit JSON supervisor.
Paste this spec into the JSON window and click Submit.
This starts the supervisor—the supervisor spawns tasks that start listening for incoming data.
- Click Tasks on the console home page to monitor the status of the job. This spec writes the data in the
kttmtopic to a datasource named
Use the API
You can also use the Druid API to submit a supervisor spec.
Run the following command to download the sample spec:
curl -o kttm-kafka-supervisor.json https://raw.githubusercontent.com/apache/druid/master/docs/assets/files/kttm-kafka-supervisor.json
Run the following command to submit the spec in the
curl -X POST -H 'Content-Type: application/json' -d @kttm-kafka-supervisor.json http://localhost:8081/druid/indexer/v1/supervisor
After Druid successfully creates the supervisor, you get a response containing the supervisor ID:
Click Tasks on the console home page to monitor the status of the job. This spec writes the data in the
kttmtopic to a datasource named
Query your data
After Druid sends data to the Kafka stream, it is immediately available for querying. Click Query in the Druid console to run SQL queries against the datasource.
Since this tutorial ingests a small dataset, you can run the query
SELECT * FROM "kttm-kafka" to return all of the data in the dataset you created.
Check out the Querying data tutorial to run some example queries on the newly loaded data.
For more information, see the following topics: