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 file etc/catalog/druid.properties with the following contents, replacing the properties as appropriate:

connector.name=druid
druid.coordinator-url=hostname:port
druid.broker-url=hostname:port
druid.schema-name=schema
druid.compute-pushdown-enabled=true

Configuration Properties#

The following configuration properties are available:

Property Name

Description

druid.coordinator-url

Druid coordinator url.

druid.broker-url

Druid broker url.

druid.schema-name

Druid schema name.

druid.compute-pushdown-enabled

Whether to pushdown all query processing to Druid.

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.

druid.compute-pushdown-enabled#

Whether to pushdown all query processing to Druid.

the default is false.

Data Types#

The data type mappings are as follows:

Druid

Presto

VARCHAR

VARCHAR

BIGINT

BIGINT

DOUBLE

DOUBLE

FLOAT

REAL

TIMESTAMP

TIMESTAMP

(others)

(unsupported)