Julian Hyde created CALCITE-1823:
------------------------------------
Summary: Push join down to Druid, using Druid's query-time lookups
Key: CALCITE-1823
URL: https://issues.apache.org/jira/browse/CALCITE-1823
Project: Calcite
Issue Type: Bug
Components: druid
Reporter: Julian Hyde
Assignee: Julian Hyde
Push Join down to Druid, using Druid's [query-time
lookup|http://druid.io/docs/latest/querying/lookups.html] feature. As of Druid
0.10 this feature is marked experimental.
bq. Very small lookups (count of keys on the order of a few dozen to a few
hundred) can be passed at query time as a "map" lookup
We could use map lookups for joins to a Values operator.
bq. Globally cached lookups from local files, remote URIs, or JDBC through
lookups-cached-global.
If Calcite sees a Join between Druid and a table in a JDBC data source, and it
knows that that table is [registered as a lookup in Druid's
schema|http://druid.io/docs/latest/development/extensions-core/lookups-cached-global.html],
and it knows the name of that lookup, then it could translate to a JDBC lookup
in Druid.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
