@Liang, Yes, actually I'm currently working on the limit query
optimization.
I get the limited dictionary value and convert to the filter condition in
CarbonOptimizer step.
It would definitely improve the query performance in some scenario.
On Thu, Mar 30, 2017 at 2:07 PM, Liang Chen
Hi
+1 for simafengyun's optimization, it looks good to me.
I propose to do "limit" pushdown first, similar with filter pushdown. what
is your opionion? @simafengyun
For "order by" pushdown, let us work out an ideal solution to consider all
aggregation push down cases. Ravindara's comment is
Hi Ravindran,yes, use carbon do the sorting if the order by column is not first
column.But its sorting is very high since the dimension data in blocklet is
stored after sorting.So in carbon can use merge sort + topN to get N data
from each block.In addition, the biggest difference is that it