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

Posted to issues@impala.apache.org by "pengdou1990 (Jira)" <ji...@apache.org> on 2022/09/29 10:00:00 UTC

[jira] [Created] (IMPALA-11625) Support create/drop materialized view syntax on IMPALA

pengdou1990 created IMPALA-11625:
------------------------------------

             Summary: Support create/drop materialized view syntax on IMPALA
                 Key: IMPALA-11625
                 URL: https://issues.apache.org/jira/browse/IMPALA-11625
             Project: IMPALA
          Issue Type: Improvement
          Components: Backend, Catalog, Frontend
            Reporter: pengdou1990
            Assignee: pengdou1990


For infrequently modified datasets, building suitable materialized views and querying on materialized views directly can significantly reduce query response time.

Currently IMPALA only treats materialized view built by hive as a normal table and does not support CREATE MATERIALIZED VIEW AS SELECTED and DROP MATERIALIZED VIEW syntax on IMPALA.

CREATE TABLE AS SELECT can save the intermediate results of the query, but it is very inconvenient to use and maintain, for example, the calculation logic is not visible to the user.

So I want to implement support create/drop materialized view syntax on impala.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)