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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
