Dear Calcite Developers I am referring to Calcite-Druid and could see an open issue to support pushdown order by.
[cid:image002.jpg@01D259EE.AB05FAB0] My custom database(based on elastic search) will return 100 records by default at a time, unless a limit is specified. Here, for a use case with order by and limit in place, limit definitely would have to be pushed to source. Of course, order by needs to be applied before limit, we need to pass it to source too. Could you please suggest a way out. Your suggestions in this regard would be highly appreciated. Thanks and Regards Shuchi Gupta Software Engineer (CA) CA Technologies | Plot 115/1, 115/16-115/21 | Hyderabad, 500032 Office: +71262 | shuchi.gup...@ca.com <mailto:shuchi.gup...@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google+]<https://plus.google.com/+CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>