[Feature] Support rowid pushdown for _ROW_ID filters

[zhangweilst]

Search before asking

• I searched in the issues and found nothing similar.

Motivation

After row tracking support, users can select the row tracking table this:
SELECT * FROM t where _ROW_ID = 100;

Currently it will not take advantage of the table index rowid pushdown facilities, and just process the predicate by FilterOperator (In spark).

If the predicate can be transformed to a RoaringBitmap32 and passed down to the file format reader, it will hugely improve the scan performance

Solution

No response

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[steFaiz]

There are already some pr about that:
#6697
#6605