Phoenix Tips (14) mutable 和 immutable 表区别

最新推荐文章于 2023-05-31 15:02:27 发布

荒岛码农

最新推荐文章于 2023-05-31 15:02:27 发布

阅读量1.5k

点赞数

分类专栏：大数据-云计算

本文链接：https://blog.csdn.net/lihui6636/article/details/40950107

版权

大数据-云计算专栏收录该内容

133 篇文章 0 订阅

订阅专栏

分别创建表：

create table my_mutable (id varchar not null primary key, cf1.a varchar , cf1.b varchar, cf2.c varchar, cf2.d varchar) ;

create table my_immutable (id varchar not null primary key, cf1.a varchar , cf1.b varchar, cf2.c varchar, cf2.d varchar) immutable_rows=true ;

分别创建索引：

create index index_my_mutable on my_mutable(a,c) include (b,d);

create index index_my_immutable on my_immutable(a,c) include (b,d);

分别插入数据

upsert into my_mutable values ('1000001','a1','b1','c1','d1');
upsert into my_mutable values ('1000001','a2','b2','c2','d2');
upsert into my_mutable values ('1000001','a3','b3','c3','d3');

upsert into my_immutable values ('1000001','a1','b1','c1','d1');
upsert into my_immutable values ('1000001','a2','b2','c2','d2');
upsert into my_immutable values ('1000001','a3','b3','c3','d3');

查看数据：

select * from my_mutable ;
-----------------------------------------------------------------
| ID | A | B | C | D |
-----------------------------------------------------------------
| 1000001 | a3 | b3 | c3 | d3 |
-----------------------------------------------------------------

select * from my_immutable ;
---------------------------------------------------------------
| ID | A | B | C | D |
----------------------------------------------------------------
| 1000001 | a1 | b1 | c1 | d1 |
| 1000001 | a2 | b2 | c2 | d2 |
| 1000001 | a3 | b3 | c3 | d3 |
----------------------------------------------------------------

select * from index_my_mutable ;
---------------------------------------------------------------------------
| CF1:A | CF2:C | :ID | CF1:B | CF2:D |
---------------------------------------------------------------------------
| a3 | c3 | 1000001 | b3 | d3 |
---------------------------------------------------------------------------

select * from index_my_immutable ;
---------------------------------------------------------------------------
| CF1:A | CF2:C | :ID | CF1:B | CF2:D |
---------------------------------------------------------------------------
| a1 | c1 | 1000001 | b1 | d1 |
| a2 | c2 | 1000001 | b2 | d2 |
| a3 | c3 | 1000001 | b3 | d3 |
---------------------------------------------------------------------------