Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.0
    • Component/s: None
    • Labels:

      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

        Activity

        Show
        julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/f8c2c807 .
        Hide
        jcamachorodriguez Jesus Camacho Rodriguez added a comment -

        Resolved in release 1.9.0 (2016-09-22)

        Show
        jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.9.0 (2016-09-22)

          People

          • Assignee:
            julianhyde Julian Hyde
            Reporter:
            julianhyde Julian Hyde
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development