[CALCITE-1358] Push filters on time dimension to Druid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.9.0
• Component/s: druid-adapter
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 23/Aug/16 19:17
• Updated: 27/Feb/24 22:23
• Resolved: 15/Sep/16 04:54

Description

Porting work done in HIVE-14217.

Logic should split the filter conditions into two parts: those predicates referred to the time dimension, and predicates referred to other columns.

Then, the predicates on the time dimension should be translated into Druid intervals, possibly consolidating those ranges e.g. to detect overlapping. The other predicates will go into the Druid filter field.

Issue Links

• blocks: CALCITE-1356 Release Calcite 1.9.0
• is related to: HIVE-14466 Extend Calcite capabilities to transform plan into Druid query
• is related to: CALCITE-1334 Convert predicates on EXTRACT function calls into date ranges