[HIVE-3712] Use varbinary instead of longvarbinary to store min and max column values in column stats schema

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.0
• Fix Version/s: 0.10.0
• Component/s: Metastore, Statistics
• Assignee: Shreepadma Venugopalan
• Reporter: Shreepadma Venugopalan
• Created: 15/Nov/12 19:31
• Updated: 10/Jan/13 19:53
• Resolved: 28/Nov/12 02:43

Description

JDBC type longvarbinary maps to BLOB SQL type in some databases. Storing min and max column values for numeric types takes up 8 bytes and hence doesn't require a BLOB. Storing these values in a BLOB will impact performance without providing much benefits.

Issue Links

• Is contained by: HIVE-3678 Add metastore upgrade scripts for column stats schema changes