[CALCITE-1577] Druid adapter: Incorrect result - limit on timestamp disappears

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.12.0
• Component/s: druid-adapter
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 16/Jan/17 14:33
• Updated: 27/Feb/24 22:23
• Resolved: 20/Jan/17 00:07

Description

This can be observed with the following query:

SELECT DISTINCT `__time`
FROM store_sales_sold_time_subset
ORDER BY `__time` ASC
LIMIT 10;

Query is translated to Druid timeseries, but limit operator disappears.

Issue Links

• is broken by: CALCITE-1357 Recognize Druid Timeseries and TopN queries in DruidQuery
• relates to: HIVE-15632 Hive/Druid integration: Incorrect result - Limit on timestamp disappears