[Mondrian] Topcount query with monetDB

[Hilario Fernandes]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20131016/f1b663ee/attachment.html