[CALCITE-1276] In Druid adapter, deduce columns by running a "segmentMetadata" query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.8.0
• Component/s: druid-adapter
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 07/Jun/16 03:42
• Updated: 12/Jun/16 07:44
• Resolved: 09/Jun/16 01:05

Description

In Druid adapter, deduce columns by running a "segmentMetadata" query. Currently a Druid model must contain "dimensions" and "metrics" fields. If either of these are absent, Calcite should run a segment metadata query and take the resulting "columns" and "aggregators" fields and make them into columns.

The effect will be that the Druid adapter will be easier to configure. You will be able to connect without a model, per CALCITE-1259:

jdbc:calcite:schema=wiki; schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory; schema.url=http://localhost:8082; schema.coordinatorUrl=http://localhost:8081

By the way, those URLs are the same as the defaults, and if you don't care about the schema name the following will suffice:

jdbc:calcite:schemaFactory=org.apache.calcite.adapter.druid.DruidSchemaFactory

It will also adapt to schema changes. If there are multiple segments, and the schema evolves over time, I suppose that the segments might have different columns and aggregators. Calcite should use "merge": true, "lenientAggregatorMerge": false to combine them.