EmmyMiao87 opened a new pull request #2431: Support to create materialized view URL: https://github.com/apache/incubator-doris/pull/2431 This commit support to create materiliazed view. The syntax of stmt is following: ALTER TABLE [Table name] ADD Materialized View [MV name] AS SELECT select_expr[, select_expr ...] FROM [Base table name] GROUP BY column_name[, column_name ...] ORDER BY column_name[, column_name ...] The AddMaterializedViewClause is used to check the semantic of stmt in the first step. Now, the where, having, limit clause is forbidden in ADD MATERIALIZED VIEW. Also the aggregation function is restricted in SUM/MIN/MAX. The second step is to validate stmt according to metadata of base table. For example, the aggregate type of mv column must be same as the aggregate type of base column in aggregate table. The last step is to prepare index of mv and add this new mvJob in Handler. The handler will asynchronous process this new mvJob. ISSUE-2101
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
