thomasrebele opened a new pull request, #6293: URL: https://github.com/apache/hive/pull/6293
See [HIVE-29424](https://issues.apache.org/jira/browse/HIVE-29424). ### What changes were proposed in this pull request? This PR adapts FilterSelectivityEstimator so that histogram statistics are used for range predicates with a cast. I added many test cases to some cover corner cases. To get the ground truth, I executed queries with the predicates, see [the resulting q.out file](https://github.com/thomasrebele/hive/blob/tr/HIVE-29424-test-data/ql/src/test/results/clientpositive/llap/stats_histogram_HIVE-29424.q.out). ### Why are the changes needed? This PR allows the CBO planner to use histogram statistics for range predicates that contain a CAST around the input column. ### Does this PR introduce _any_ user-facing change? No ### How was this patch tested? Unit tests were added. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
