[Mondrian] Topcount query with monetDB

Luc Boudreau lucboudreau at gmail.com
Wed Oct 16 11:14:22 EDT 2013


Seems like this is the problem. But mondrian has no way to know there
aren't any null values, so it must assume there are.

If you can propose a new syntax to order the nulls properly on monetdb
we'll look into it.

Luc


On Wed, Oct 16, 2013 at 10:55 AM, Hilario Fernandes <
hilario.fernandes at cortex-intelligence.com> wrote:

> It seems like  "NULLS LAST" is not supported by monetdb... But i can
> confirm it yelds results if i run:
>
> (...)
> order by
>     sum("CUBE"."MEASURE_0") DESC ,
>     "CUBE"."ATTR_0" ASC
>
>
> There are no nulls on the dataset i'm testing, so it shouldn't make a
> difference.
>
>
>
>
> On Wed, Oct 16, 2013 at 3:45 PM, Luc Boudreau <lucboudreau at gmail.com>wrote:
>
>> Try this and let us know if this query returns some results. we can use
>> that syntax instead:
>>
>> (...)
>> order by
>>     sum("CUBE"."MEASURE_0") DESC NULLS LAST,
>>     "CUBE"."ATTR_0" ASC NULLS LAST
>>
>>
>>
>> _______________________________________________
>> 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/20131016/cc4bb3b6/attachment.html 


More information about the Mondrian mailing list