[ https://issues.apache.org/jira/browse/SPARK-29038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16938134#comment-16938134 ]
Amogh Margoor commented on SPARK-29038: --------------------------------------- Hi [~cltlfcjin] We have written code around Catalyst recognizing Hive Materialized views and substituting it here: [https://github.com/apache/spark/pull/25773/files. |https://github.com/apache/spark/pull/25773/files]We would love to collaborate if you are planning to create a Spark native Materialized Views as we believe lot of code that we wrote can be used especially the optimizer part of it. Do let us know your thoughts. cc [~karup1990] > SPIP: Support Spark Materialized View > ------------------------------------- > > Key: SPARK-29038 > URL: https://issues.apache.org/jira/browse/SPARK-29038 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.0.0 > Reporter: Lantao Jin > Priority: Major > > Materialized view is an important approach in DBMS to cache data to > accelerate queries. By creating a materialized view through SQL, the data > that can be cached is very flexible, and needs to be configured arbitrarily > according to specific usage scenarios. The Materialization Manager > automatically updates the cache data according to changes in detail source > tables, simplifying user work. When user submit query, Spark optimizer > rewrites the execution plan based on the available materialized view to > determine the optimal execution plan. > Details in [design > doc|https://docs.google.com/document/d/1q5pjSWoTNVc9zsAfbNzJ-guHyVwPsEroIEP8Cca179A/edit?usp=sharing] -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org