Database Reference
In-Depth Information
4.
Select from the column family as follows:
select * from counternoreptable;
As shown in
Figure 2-22
, it results in zero rows. Whether it res-
ults in zero rows may depend on which node it is written to.
Figure 2-22
.
Inconsistent result on fetching from counter table
5.
Let's update
pagecount
for some more values and verify the res-
ults:
update counternoreptable set
pagecount=pagecount+12 where id = '1';
select * from counternoreptable;
Figure 2-23
shows the result of this command.
Figure 2-23
.
Retrieving from the counter table after incrementing the counter column value
update counternoreptable set
pagecount=pagecount-2 where id = '1';
select * from counternoreptable;
The result is different for this command (see
Figure 2-24
).
Figure 2-24
.
Inconsistent result of counter column without replication