ad1happy2go commented on issue #9397: URL: https://github.com/apache/hudi/issues/9397#issuecomment-1690188880
@nandubatchu I was not able to reproduce this issue with sample dataset. Can you share your table configs. Below the the code I was trying to use. I confirmed its using col stats for one of the column. Please provide some more insights about your data to help us to triage it better. ``` create table issue_col_stats_issue_9397_1 ( id string, name string, col1 int, col2 int, col3 int, updated_at string ) using hudi tblproperties ( type = 'cow', primaryKey = 'id', preCombineField = 'updated_at', hoodie.metadata.index.column.stats.enable = 'true', hoodie.metadata.index.column.stats.column.list = 'col1' ) location 'file:///tmp/issue_col_stats_issue_9397_1'; INSERT INTO issue_col_stats_issue_9397_1 VALUES ('1', 'c',1,1,1,'2023-01-01 00:00:00'), ('2', 'c',2,2,2,'2023-01-01 00:00:00'), ('3', 'c',3,3,3,'2023-01-01 00:00:00'); -- Verify if col stats present at /tmp/issue_col_stats_issue_9397_1/.hoodie/metadata/ select * from issue_col_stats_issue_9397_1 where col1 = 1 and col2 = 1 and col3 = 1; -- Correct Results select * from issue_col_stats_issue_9397_1 where col1 > 1 and col2 > 1 and col3 > 1; -- Correct Results ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@hudi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org