Hi chuanyin: I used SQL1 and SQL2 as test cases and ran on local[4] mode, when the rowNum of CarbonVectorProxy (actually it's the capacity of ColumnarBatch) is 4 * 1024 (default): SQL1: 8s, 9s (run two times), SQL2: 12s, 11s but when it's 16 * 1024: SQL1: 6s, 6s, SQL2: 9s, 8s
So the changing of this property benefits my two test cases. -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/