[HIVE-6798] Update column stats based on filter expression in stats annotation - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Watch issue

Watchers

Convert to Issue

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Release Note:

Hide
During stats annotation column stats are updated based on ratio of change in number of rows. This heuristics can be improved by analyzing the filter expression and updating the column stats accordingly. For example: When filter expression is an equality to literal then NDV can be set to 1 directly. If the expression is an equality to column projection then min NDVs of the columns participating in expression can be taken.

Show
During stats annotation column stats are updated based on ratio of change in number of rows. This heuristics can be improved by analyzing the filter expression and updating the column stats accordingly. For example: When filter expression is an equality to literal then NDV can be set to 1 directly. If the expression is an equality to column projection then min NDVs of the columns participating in expression can be taken.