VERIFY

语法

VERIFY MATERIALIZED VIEW MVNAME (mvname1,mvname2...) ORIGINALSQL query

描述

给定一条SQL查询语句，验证它是否可以被指定的物化视图重写。

示例

验证指定SQL是否能被物化视图mv.tpcds.test和mv.tpcds.t1重写。

verify materialized view mvname(mv.tpcds.test,mv.tpcds.t1) originalsql select c1 from t1 where id < 7;
MV_NAME    | VERIFY RESULT |        REMARKS         
---------------|---------------|------------------------
 mv.tpcds.test | true          | MV verified            
 mv.tpcds.t1   | false         | This MV is not present 
(2 rows)