You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Craig Condit (JIRA)" <ji...@apache.org> on 2019/04/18 20:39:00 UTC

[jira] [Updated] (HIVE-21631) Enhance metastore API to allow bulk-loading materialized views

     [ https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Craig Condit updated HIVE-21631:
--------------------------------
    Issue Type: Sub-task  (was: Improvement)
        Parent: HIVE-14484

> Enhance metastore API to allow bulk-loading materialized views
> --------------------------------------------------------------
>
>                 Key: HIVE-21631
>                 URL: https://issues.apache.org/jira/browse/HIVE-21631
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Materialized views, Metastore
>    Affects Versions: 3.2.0, 3.1.1
>            Reporter: Craig Condit
>            Priority: Major
>
> Currently, every query in HS2 results in a metastore call per database to retrieve all materialized views. This causes severe performance degradation on multi-tenant clusters with thousands of databases (very similar to how the old get_function() metastore call didn't scale).
> We should add a metastore call which can retrieve all materialized view definitions at once (for all DBs) so that we don't have to make thousands of metastore calls per query.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)