[HIVE-27479] Incorrect filter selectivity of BETWEEN expressions when using histograms - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: Query Planning, Statistics
Labels:
- pull-request-available

Description

For all cases using the BETWEEN key word, the selectivity is outputted as the default value because the conditions currently in place make it impossible to enter the BETWEEN histogram selectivity code. In addition, NULLs are not properly accounted for in the BETWEEN selectivity calculation.

Attachments

Issue Links

links to

GitHub Pull Request #4466

Activity

People

Assignee:: Ryan Johnson

Reporter:: Ryan Johnson

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 01/Jul/23 10:06

Updated:: 03/Jul/23 05:22

Resolved:: 03/Jul/23 05:22