[Mondrian] how to enable topcount in kylin

[Jian Zhong]

I see, setMaxRows is not well supported in Kylin jdbc driver.

thank you everyone.

On Mon, Nov 28, 2016 at 10:46 PM, Luc Boudreau <lucboudreau at gmail.com>
wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/20161129/bad2b313/attachment-0001.html