[jira] [Created] (HIVE-29235) Iceberg returns incorrect count value

[Jaeho Yoo (Jira)]

Jaeho Yoo created HIVE-29235:
--------------------------------

             Summary: Iceberg returns incorrect count value
                 Key: HIVE-29235
                 URL: https://issues.apache.org/jira/browse/HIVE-29235
             Project: Hive
          Issue Type: Bug
            Reporter: Jaeho Yoo


For iceberg table, Hive tries to read partitionStatistics.

But if the table doesn't have them, Hive calculates using default statistics, 
which is incorrect.

We are using Hive 4.1.0.

SELECT count(*), log_date FROM db1.tbl1 GROUP BY 2;
+----------+-------------+
| _c0 | log_date |
+----------+-------------+
| 343662 | 2025-09-29 |
| 2513459 | 2025-09-30 |  
 
 
SELECT count(*) FROM db1.tb1 WHERE log_date = '2025-09-29'; // 2857121
SELECT count(*) FROM db1.tb1 WHERE log_date = '2025-09-30'; // 2857121
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)