hive icon indicating copy to clipboard operation
hive copied to clipboard

HIVE-28581: Support Partition Prunning stats optimization for Iceberg tables

Open deniskuzZ opened this issue 1 year ago • 3 comments

What changes were proposed in this pull request?

Add support for Iceberg partition prune stats optimization

Why are the changes needed?

Performance

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

mvn test -Dtest=TestIcebergCliDriver -Dqfile=iceberg_stats_with_ppr.q -Drat.skip=true

deniskuzZ avatar Oct 09 '24 15:10 deniskuzZ

@deniskuzZ Could you please add the jira Id. I haven't found the file iceberg_partition_stats_with_ppr.q in the patch

kasakrisz avatar Oct 18 '24 08:10 kasakrisz

Add support for Iceberg partition prune stats optimization

@deniskuzZ Could you please add the jira Id. I haven't found the file iceberg_partition_stats_with_ppr.q in the patch

updated

deniskuzZ avatar Oct 18 '24 09:10 deniskuzZ

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Feel free to reach out on the [email protected] list if the patch is in need of reviews.

github-actions[bot] avatar Dec 30 '24 00:12 github-actions[bot]

in general, I cannot see any test coverage of this new feature, how does the added iceberg_stats_with_ppr.q.out show that it kicks in?

abstractdog avatar Jan 24 '25 14:01 abstractdog

in general, I cannot see any test coverage of this new feature, how does the added iceberg_stats_with_ppr.q.out show that it kicks in?

  1. table has 5 rows, predicate returns 3 (before would be 5), see stats: https://github.com/apache/hive/pull/5498/files#diff-d6f6d58b1308192b6b3c9fcd75e2f5047e3817ad24900e2ecaca684569956d6eR56-R57
  2. count(*) explain shows no tasks, simple fetch from stats (before Map task was launched) https://github.com/apache/hive/pull/5498/files#diff-d6f6d58b1308192b6b3c9fcd75e2f5047e3817ad24900e2ecaca684569956d6eR78-R97

deniskuzZ avatar Jan 24 '25 15:01 deniskuzZ

There are several Sonar issues in the modified classes. Other than that LGTM +1.

difin avatar Jan 28 '25 16:01 difin