You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "pengdou1990 (Jira)" <ji...@apache.org> on 2022/09/30 02:42:00 UTC
[jira] [Updated] (IMPALA-11625) Support create/drop materialized view syntax on IMPALA

     [ https://issues.apache.org/jira/browse/IMPALA-11625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

pengdou1990 updated IMPALA-11625:
---------------------------------
    Description: 
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.

 

CREATE MATERIALIZED VIEW syntax like this
{code:java}
CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]table_name
  [PARTITIONED BY (col_name[, ...])]
  [SORT BY ([column [, column ...]])]
  [COMMENT 'table_comment']
  [ROW FORMAT row_format]
  [WITH SERDEPROPERTIES ('key1'='value1', 'key2'='value2', ...)]
  [STORED AS ctas_file_format]
  [LOCATION 'hdfs_path']
    [CACHED IN 'pool_name' [WITH REPLICATION = integer] | UNCACHED]
  [TBLPROPERTIES ('key1'='value1', 'key2'='value2', ...)]
AS
  select_statement 


cmvas_file_format:
    PARQUET
  | TEXTFILE{code}
DROP MATERIALIZED VIEW syntax like this
{code:java}
DROP MATERIALIZED VIEW [IF EXISTS] [db_name.]table_name{code}

  was:
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.


> 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
>            Priority: Major
>
> 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.
>  
> CREATE MATERIALIZED VIEW syntax like this
> {code:java}
> CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]table_name
>   [PARTITIONED BY (col_name[, ...])]
>   [SORT BY ([column [, column ...]])]
>   [COMMENT 'table_comment']
>   [ROW FORMAT row_format]
>   [WITH SERDEPROPERTIES ('key1'='value1', 'key2'='value2', ...)]
>   [STORED AS ctas_file_format]
>   [LOCATION 'hdfs_path']
>     [CACHED IN 'pool_name' [WITH REPLICATION = integer] | UNCACHED]
>   [TBLPROPERTIES ('key1'='value1', 'key2'='value2', ...)]
> AS
>   select_statement 
> cmvas_file_format:
>     PARQUET
>   | TEXTFILE{code}
> DROP MATERIALIZED VIEW syntax like this
> {code:java}
> DROP MATERIALIZED VIEW [IF EXISTS] [db_name.]table_name{code}



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org