[ https://issues.apache.org/jira/browse/HIVE-21631?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-21631: ------------------------------------------- Attachment: HIVE-21631.patch > 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: Bug > Components: Materialized views, Metastore > Affects Versions: 3.2.0, 3.1.1 > Reporter: Craig Condit > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-21631.patch, HIVE-21631.patch, HIVE-21631.patch, > HIVE-21631.patch > > > 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)