[jira] [Created] (CALCITE-1343) Broken Druid query

["Julian Hyde (JIRA)" <ji...@apache.org>]

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)