Re: Re: Optimize Order By + Limit Query

Posted by simafengyun on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Optimize-Order-By-Limit-Query-tp9764p9863.html

add images for my last post


1. about how to work for dictionary columns and guarantee to get a sort result
Answer:  As I know the dictionary allocation is in sorted order  in block level, even in segment level, not in global level.
But that's enough, please see the below example about how to get the correct sort result



2.about how to reduce IO