hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3678) Add metastore upgrade scripts for column stats schema changes
Date Mon, 19 Nov 2012 18:52:00 GMT

    [ 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

Mime
View raw message