[Mondrian] how to enable topcount in kylin

Luc Boudreau lucboudreau at gmail.com
Mon Nov 28 09:46:00 EST 2016


Mondrian does not limit results with SQL per-se. It will set the limit via
JDBC, using java.sql.Statement.setMaxRows().

On Mon, Nov 28, 2016 at 8:18 AM, Pedro Alves <pmgalves at gmail.com> wrote:

> What's the error? Should respect your dialect and generate proper sql
>
> On Nov 28, 2016 3:48 AM, "Jian Zhong" <zhongjian at apache.org> wrote:
>
>> Hi every one,
>>
>> I'm a developer trying to integrate kylin and mondrian.
>>
>> I have a problem when using kylin+mondrian,
>>
>> I try to enable 'TOP 10' function in saiku, and also set
>> *mondrian.native.topcount.enable* to '*true*'
>>
>> but it does not work, I have read the document, and it says '
>> If enabled some TopCount will be computed in SQL­.'
>>
>> Then, can anyone guide me how to enable topcount?
>>
>> thank you.
>>
>>
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>
>>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20161128/4952db87/attachment-0001.html 


More information about the Mondrian mailing list