[HIVE-28196] Preserve column stats when applying UDF upper/lower. - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 4.0.0
Fix Version/s: 4.1.0, 4.0.1
Component/s: None
Labels:

Description

Current Hive re-estimates column stats (including avgColLen) when it encounters UDF.
In the case of upper and lower, Hive sets avgColLen to hive.stats.max.variable.length.
But these UDFs do not change column stats and the default value(100) is too high for string type key columns, on which upper/lower are usually applied.

This patch keeps input data's avgColLen after applying UDF upper/lower to make a better query plan.