6.4. Druid Connector

Overview

The Druid Connector allows access to Druid data from Presto.This document describes how to setup the Druid Connector to run SQL queries against Druid.

Note

It is highly recommended to use Druid 0.17.0 or later.

Configuration

To configure the Druid connector, create a catalog properties fileetc/catalog/druid.properties with the following contents,replacing the properties as appropriate:

  1. connector.name=druid
  2. druid.coordinator-url=hostname:port
  3. druid.broker-url=hostname:port
  4. druid.schema-name=schema

Configuration Properties

The following configuration properties are available:

Property NameDescription
druid.coordinator-urlDruid coordinator url.
druid.broker-urlDruid broker url.
druid.schema-nameDruid schema name.

druid.coordinator-url

Druid coordinator url, e.g. localhost:8081.

druid.broker-url

Druid broker url, e.g. localhost:8082.

druid.schema-name

Druid schema name.

This property is optional; the default is druid.

Data Types

The data type mappings are as follows:

DruidPresto
VARCHARVARCHAR
BIGINTBIGINT
DOUBLEDOUBLE
FLOATREAL
TIMESTAMPTIMESTAMP
(others)(unsupported)