Julian Hyde created CALCITE-1343:
------------------------------------
Summary: Broken Druid query
Key: CALCITE-1343
URL: https://issues.apache.org/jira/browse/CALCITE-1343
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
There are several errors while executing the following query generated by
Mondrian against the Druid adapter:
{code}
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"
{code}
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
