[ https://issues.apache.org/jira/browse/HIVE-10459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15379734#comment-15379734 ]
Jesus Camacho Rodriguez commented on HIVE-10459: ------------------------------------------------ [~alangates], I will move the initial work to HIVE-14249; we can follow-up there with anything related to the patch. As there are a few people watching this issue, I will use this as the umbrella JIRA for all the work that we will do around materialized views implementation. > Add materialized views to Hive > ------------------------------ > > Key: HIVE-10459 > URL: https://issues.apache.org/jira/browse/HIVE-10459 > Project: Hive > Issue Type: Improvement > Components: Views > Reporter: Alan Gates > Assignee: Julian Hyde > Attachments: HIVE-10459.2.patch, HIVE-10459.patch > > > Materialized views are useful as ways to store either alternate versions of > data (e.g. same data, different sort order) or derivatives of data sets (e.g. > commonly used aggregates). It is useful to store these as materialized views > rather than as tables because it can give the optimizer the ability to > understand how data sets are related. -- This message was sent by Atlassian JIRA (v6.3.4#6332)