doris icon indicating copy to clipboard operation
doris copied to clipboard

[Feat](nereids) add max/min filter push down rewrite rule

Open feiniaofeiafei opened this issue 6 months ago • 32 comments

add rewrite rule: select id, max(a) from t group by id having max(a)>10; -> select id, max(a) from t where a>10 group by id; select id, min(a) from t group by id having min(a)<10; -> select id, min(a) from t where a<10 group by id;

feiniaofeiafei avatar Aug 12 '24 13:08 feiniaofeiafei