kingbase物化视图创建以及物化视图刷新方式

一、物化视图的创建

KingbaseES语法：

CREATE MATERIALIZED VIEW view_name
    [ (column_name [, ...] ) ]

[ TABLESPACE tablespace_name ]
    AS query
    [ WITH [ NO ] DATA ]

二、物化视图刷新

相比oracle的多种刷新方式，目前KingbaseES支持全部刷新：refresh materialized view，支持并发刷新。

三、使用

create  materialized view test_view as select  id from  test;
test=# select  * from test_view;
 id 
----
  1
  2
  3
(3 rows)

四、刷新视图

                                 ^
test=# insert   into  test values (4);
INSERT 0 1
test=# 
test=# select  * from test ;
 id 
----
  1
  2
  3
  4
(4 rows)

test=# select  * from test_view;
 id 
----
  1
  2
  3
(3 rows)

test=# refresh materialized view  test_view ;
REFRESH MATERIALIZED VIEW
test=# 4~
test-#   
test=# 4~
test=# 
test=# select  * from test_view;
 id 
----
  1
  2
  3
  4
(4 rows)

五、定时刷新物化视图

[kingbase@node3 ~]$ crontab  -l
* */5 * * *    kingbase   ksql  -Usystem -h 127.0.0.1   test -c " refresh materialized view  test_view ;"
[kingbase@node3 ~]$ 

无