[CALCITE-1343] Broken Druid query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Labels: druid
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 03/Aug/16 18:48
• Updated: 27/Feb/24 22:23
• Resolved: 04/Aug/16 23:24

Description

There are several errors while executing the following query generated by Mondrian against the Druid adapter:

select "wikiticker"."countryName" as "c0",
 sum("wikiticker"."count") as "m1",
 sum("wikiticker"."deleted") as "m2",
 sum("wikiticker"."delta") as "m3"
from "wiki" as "wikiticker"
where ("wikiticker"."countryName" in ('Colombia', 'France', 'Germany', 'India', 'Italy', 'Russia', 'United Kingdom', 'United States')
 or "wikiticker"."countryName" is null)
group by "wikiticker"."countryName"

Issues:

• SqlToRelConverter incorrectly casts each of the string literals to VARCHAR(1) to match LHS of IN (e.g. 'Columbia' gets truncated to 'C')
• SUM does not work on BIGINT columns, only INTEGER
• ArrayIndexOutOfBoundsException in AggregateNode when building key values