Updated on 2024-12-13 GMT+08:00

REFRESH MATERIALIZED VIEW

Syntax

REFRESH MATERIALIZED VIEW materialized_view_name

Description

This statement is used to update data in a materialized view.

You need to obtain the materialized view name in advance.

The following is an example.

Example

hetuengine:tpcds_orc_hive_2> refresh materialized view mv.tpcds.test;
REFRESH MATERIALIZED VIEW: 10 rows