[
https://issues.apache.org/jira/browse/CALCITE-1343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1343.
----------------------------------
Resolution: Fixed
Fix Version/s: 1.9.0
Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/f8c2c807.
> 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)
