Login  Register

Re: [DISCUSSION] optimization of OrderBy sorted columns + Limit Query

Posted by ravipesala on Sep 27, 2017; 5:37am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/DISCUSSION-optimization-of-OrderBy-sorted-columns-Limit-Query-tp23057p23173.html

Hi,

As I understand as per your business scenario you require to sort on
dimension and apply a limit on it for pagination on your web application. It
is a very specific scenario for your case to handle. It is not even topN
queries as it is not applying on measures. If we push down this type of
specific scenarios to carbon we will have maintainability issues in
long-term.
It is recommended that these type of optimizations can be done in the
planning phase or integration layer and not to the level of carbon layer.


Regards,
Ravindra



--
Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/