[Mondrian] Forcing "expr direction NULLS LAST" in order by without rebuild?

Luc Boudreau lucboudreau at gmail.com
Mon Apr 7 10:36:19 EDT 2014

No, there isn't. At the moment the easiest way is to build mondrian like
you want it. Alternatively, you can develop your own dialect and make it
extend JdbcDialectImpl and override what you need.


On Mon, Apr 7, 2014 at 7:28 AM, Jesús Barrasa <jbarrasa at outlook.com> wrote:

> Hi,
> I would like to force the use of ANSI syntax ("expr direction NULLS LAST")
> in the ORDER BY of the SQL generated by Mondrian because my database does
> not support the default ORDER BY syntax (with a CASE expression in it).
> I see that there is actually an alternative implementation
> "generateOrderByNullsAnsi" for the generation of the ORDER BY in the
> JdbcDialectImpl class that produces the desired output.
> Is there an alternative to writing an implementation of the Dialect
> interface and rebuilding the source?
> Cheers,
> J. Barrasa
> _______________________________________________
> 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/20140407/49f5e626/attachment.html 

More information about the Mondrian mailing list