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 broker url. |
|
Druid schema name. |
|
Whether to pushdown all query processing to Druid. |
|
Enable case-sensitive identifier support for schema,
table, and column names for the connector. When disabled,
names are matched case-insensitively using lowercase
normalization. Default is |
|
Enable TLS when connecting to Druid. |
|
Path to the trust certificate file. |
|
Password for the trust certificate file. |
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.
druid.tls.enabled¶
Enable TLS when connecting to Druid.
The default is false.
druid.tls.truststore-path¶
Path to the trust certificate file.
druid.tls.truststore-password¶
Password for the trust certificate file.
Data Types¶
The data type mappings are as follows:
Druid |
Presto |
|---|---|
|
|
|
|
|
|
|
|
|
|
(others) |
(unsupported) |