[HIVE-14466] Extend Calcite capabilities to transform plan into Druid query

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: Druid integration
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 08/Aug/16 11:47
• Updated: 27/Feb/24 22:24
• Resolved: 08/Sep/16 09:06

Description

Leverage the existing code in Calcite (CALCITE-1121) to push operators into DruidQuery. Currently Project, Filter, and Aggregate operators can be pushed, and Druid Select and GroupBy queries are recognized. However, other query types such as Timeseries and TopN, which are known to be Druid greater assets, are not recognized as such.

Hence, we should extend the Calcite based code to push operators into DruidQuery (Scan) that can lead to the recognition of these query types. Further, we need to extend the logic to transform a DruidQuery containing a complex plan into a JSON query formatted for Druid.

Issue Links

• is part of: HIVE-14217 Druid integration
• relates to: CALCITE-1334 Convert predicates on EXTRACT function calls into date ranges
• relates to: CALCITE-1357 Recognize Druid Timeseries and TopN queries in DruidQuery
• relates to: CALCITE-1358 Push filters on time dimension to Druid