[
https://issues.apache.org/jira/browse/HIVE-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13499924#comment-13499924
]
Shreepadma Venugopalan commented on HIVE-3712:
----------------------------------------------
It looks like VARBINARY is not supported across different DBs and DB versions
in a consistent manner. Storing 8 bytes in a LONGVARBINARY is an overkill
because the LONGVARBINARY is mapped to BLOB type in some DBs. It appears the
best solution at this point is to store LONG and DOUBLE min and max values in
two separate columns.
> Use varbinary instead of longvarbinary to store min and max column values in
> column stats schema
> ------------------------------------------------------------------------------------------------
>
> Key: HIVE-3712
> URL: https://issues.apache.org/jira/browse/HIVE-3712
> Project: Hive
> Issue Type: Bug
> Components: Metastore, Statistics
> Affects Versions: 0.9.0
> Reporter: Shreepadma Venugopalan
> Assignee: Shreepadma Venugopalan
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
