[Tech Request]: pushdown block filter for each filter condition of the composite key

[XuPeng-SH]

Is there an existing issue for the same tech request?

• I have checked the existing issues.

Does this tech request not affect user experience?

• This tech request doesn't affect user experience.

What would you like to be added ?

pushdown block filter for each filter condition of the composite key to avoid long prefix in the composite key.

Why is this needed ?

#17367

Additional information

No response

[XuPeng-SH]

if the composite key is columnA and columnB and the filter condition like columnA=? and columnB=?, it is better to push down the block filter composite_key = ? and columnA=? and columnB=?

[fengttt]

Worked around by rewriting between to <= and >=