Skip to content

Latest commit

 

History

History
47 lines (37 loc) · 1.69 KB

druid.rst

File metadata and controls

47 lines (37 loc) · 1.69 KB

Druid

Superset has a native connector to Druid, and a majority of Druid's features are accessible through Superset.

Note

Druid now supports SQL and can be accessed through Superset's SQLAlchemy connector. The long term vision is to deprecate the Druid native REST connector and query Druid exclusively through the SQL interface.

Aggregations

Common aggregations, or Druid metrics can be defined and used in Superset. The first and simpler use case is to use the checkbox matrix expose in your datasource's edit view (Sources -> Druid Datasources -> [your datasource] -> Edit -> [tab] List Druid Column). Clicking the GroupBy and Filterable checkboxes will make the column appear in the related dropdowns while in explore view. Checking Count Distinct, Min, Max or Sum will result in creating new metrics that will appear in the List Druid Metric tab upon saving the datasource. By editing these metrics, you'll notice that they their json element correspond to Druid aggregation definition. You can create your own aggregations manually from the List Druid Metric tab following Druid documentation.

images/druid_agg.png

Post-Aggregations

Druid supports post aggregation and this works in Superset. All you have to do is creating a metric, much like you would create an aggregation manually, but specify postagg as a Metric Type. You then have to provide a valid json post-aggregation definition (as specified in the Druid docs) in the Json field.

Unsupported Features

Note

Unclear at this point, this section of the documentation could use some input.