Krisztian Kasa created HIVE-24274: ------------------------------------- Summary: Implement Query Text based MaterializedView rewrite Key: HIVE-24274 URL: https://issues.apache.org/jira/browse/HIVE-24274 Project: Hive Issue Type: Improvement Reporter: Krisztian Kasa Assignee: Krisztian Kasa
Besides the way queries are currently rewritten to use materialized views in Hive this project provides an alternative: Compare the query text with the materialized views query text stored. If we found a match the original query's logical plan can be replaced by a scan on the materialized view. - Only materialized views which are enabled to rewrite can participate - Use existing *HiveMaterializedViewsRegistry* through *Hive* object by adding a lookup method by query text. - There might be more than one materialized views which have the same query text. In this case chose the first valid one. - Validation can be done by calling *Hive.validateMaterializedViewsFromRegistry()* - The scope of this first patch is rewriting queries which entire text can be matched only. - Use the expanded query text (fully qualified column and table names) for comparing -- This message was sent by Atlassian Jira (v8.3.4#803005)