[HUDI-7569] Fix wrong result while using RLI for pruning files

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.15.0, 1.0.0
• Labels: hudi-1.0.0-beta2 pull-request-available
• Story Points: 4
• Epic Link: Indexing Functions
• Assignee: Vinaykumar Bhat
• Reporter: Vinaykumar Bhat
• Created: 02/Apr/24 15:42
• Updated: 09/Jun/24 23:12
• Resolved: 03/Apr/24 13:10

Description

Data skipping (pruning files) for RLI is supported only when the query predicate has `EqualTo` or `In` expressions/filters on the record-key column. However, the logic for detecting valid `In` expression/filter on record-key has bugs. It tries to prune files assuming that `In` expression/filter can reference only record-key column even when the `In` query is based on other columns.

 

For example, a query of the foem `select * from trips_table where driver in ('abc', 'xyz')` has the potential to return wrong results if the record-key for this table also has values 'abc' or 'xyz' for some rows of the table.

Issue Links

• is depended upon by: HUDI-7007 Integrate functional index using bloom filter on reader side
• links to: GitHub Pull Request #10955