[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: 5 days ago 09:32
• 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

Issue Links

• causes: CALCITE-6435 SqlToRel conversion of IN expressions may lead to incorrect simplifications