[ 
https://issues.apache.org/jira/browse/HIVE-3678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13500500#comment-13500500
 ] 

Carl Steinbach commented on HIVE-3678:
--------------------------------------

The upgrade scripts look good to me. As for HIVE-3712 which is included in this 
patch, I have started to wonder if it would be better for the metastore DB to 
store the column stats values (e.g. min/max value, num trues/falses, 
min/max/avg length, etc) as a JSON text blob. This approach would make the code 
more portable by eliminating dependencies on specific DBs and will also make it 
easier to add new fields in the future. The big downside of this approach is 
that we won't be able to push down column stats filters on these fields, but 
I'm not convinced that this is a practical use case in the first place.
                
> Add metastore upgrade scripts for column stats schema changes
> -------------------------------------------------------------
>
>                 Key: HIVE-3678
>                 URL: https://issues.apache.org/jira/browse/HIVE-3678
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>            Reporter: Shreepadma Venugopalan
>            Assignee: Shreepadma Venugopalan
>             Fix For: 0.10.0
>
>         Attachments: HIVE-3678.1.patch.txt
>
>
> Add upgrade script for column statistics schema changes for 
> Postgres/MySQL/Oracle/Derby

--
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

Reply via email to