Great thanks. On 5 September 2016 at 11:48, Li Yang <[email protected]> wrote:
> KYLIN-1732 <https://issues.apache.org/jira/browse/KYLIN-1732> is what you > want and it is to be release in v1.5.4 soon. Please try again on the coming > v1.5.4. > > Thanks > Yang > > On Fri, Sep 2, 2016 at 12:59 PM, Pieter Schutte < > [email protected]> wrote: > > > Apologies for the cross post. > > > > I'll update StackOverflow question when I get clarification here on the > > dev mailing list. > > > > > > On 2016-09-01 17:25:39 PM, Julian Hyde <[email protected]> wrote: > > I see you’ve posted the same question on Stack Overflow. Please don’t > > cross-post… it wastes people’s time, and/or leaves a trail of unanswered > > questions all over the place. > > > > > On Sep 1, 2016, at 2:54 AM, Pieter Schutte > wrote: > > > > > > > > > Hi, > > > > > > I am trying to use the ROLLUP and CUBE operators to summarise data > using > > the sample cube. If I execute the query the following error message is > > returned: > > > > > > Internal error: Error while applying rule OLAPAggregateRule, args > > [rel#1246:LogicalAggregate.NONE.[](input=rel#1245:Subset# > 1.NONE.[],group={0, > > 1},groups=[{0, 1}, {0}, {}],indicator=true,SUMOFPRICE=SUM($2))]. > > > > > > I am using the documentation from http://calcite.apache.org/ > > docs/reference.html to build the query. > > > > > > Test queries: > > > > > > * Simple query with not using a cube > > > select a, b, sum(c) > > > from (values (1, 2, 3, 4)) as t(a, b, c, d) > > > group by rollup(a, b) > > > > > > This query returns the expected results > > > > > > * Query using KYLIN_SALES table using ROLLUP operator > > > select seller_id, leaf_categ_id, sum(price) as SumOfPrice > > > from kylin_sales > > > group by rollup(seller_id, leaf_categ_id) > > > > > > This query returns the metioned error > > > > > > The Kylin logs show the following when the error occurs: > > > > > > > > > > > > Not sure what is going wrong or how to to resolve the issue. > > > > > > Thanks > > > Pieter > > > > > > > >
