hbase表映射Phoenix视图, 基于视图的二级索引是否实时更新

1. hbase shell

创建表

create 'MY_TABLE', 'CF1','CF2'

添加数据

put 'MY_TABLE','1' ,'CF1:V1', 'uwo1'
put 'MY_TABLE','1' ,'CF2:V2', '1'
put 'MY_TABLE','1' ,'CF1:V3', '10'

put 'MY_TABLE','2' ,'CF1:V1', 'uwo2'
put 'MY_TABLE','2' ,'CF2:V2', '2'
put 'MY_TABLE','2' ,'CF1:V3', '20'

查询hbase表数据

 

2. phoenix shell

创建视图, 视图名要和hbase表名一致

create view MY_TABLE (PK  varchar primary key, CF1.V1 varchar, CF2.V2 varchar, CF1.V3 varchar);

创建二级索引

create index my_index2 on MY_TABLE(V1) include(v2);

查询视图

select * from MY_TABLE;