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

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

     [ https://issues.apache.org/jira/browse/CALCITE-1343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde updated CALCITE-1343:
---------------------------------
    Labels: druid  (was: )

> 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
>              Labels: druid
>             Fix For: 1.9.0
>
>
> 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)