[HUDI-7267] csi will cause data loss during sql query - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: index
Labels:
- pull-request-available

Description

from the picture, csi will use parquet chunk block meta calculate min/max value, and save it to mdt col stat. For complex cols, such as *info array<struct<name: string, age: int>>* , parquet meta will contain only `info.array.name`, `infor.array.age`, but hudi will only calculate `info` column, so this meta in mdt will be null.

And if sql expression contain `IsNotNull(info)`, the file will all be skip.

And consider common cols, which will be add in the future and old file will not contain this col, may cause some other question. So, make code logical clean, Check for null before evaluating the value：min/mav/nullValue.