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 <http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/file/n9863/%E5%B1%8F%E5%B9%95%E5%BF%AB%E7%85%A7_2017-03-30_%E4%B8%8B%E5%8D%883.png> 2.about how to reduce io <http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/file/n9863/%E5%B1%8F%E5%B9%95%E5%BF%AB%E7%85%A7_2017-03-30_%E4%B8%8B%E5%8D%883.png> -- View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Optimize-Order-By-Limit-Query-tp9764p9863.html Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
