Updated on 2024-05-29 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.

Example

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