Cassandra Super Column Familyの使い方

このドキュメントの内容は、以下の通りです。

• はじめに
• Super Column Family の作り方
• Super Column Family への値のセットの仕方
• 実行例

はじめに

Super Column Family の作り方

% cassandra-cli -h localhost
create column family s1
with column_type = Super
and comparator = UTF8Type
and subcomparator=UTF8Type
and default_validation_class=UTF8Type
and key_validation_class=UTF8Type;

Super Column Family への値のセットの仕方

set s1['a']['b1']['c1']='1';
set s1['a']['b1']['c2']='2';
set s1['a']['b2']['c1']='3';
set s1['a']['b2']['c2']='4';

実行例

[default@test] set s1['a']['b1']['c1']='1';
Value inserted.
Elapsed time: 16 msec(s).
[default@test] set s1['a']['b1']['c2']='2';
Value inserted.
Elapsed time: 20 msec(s).
[default@test] set s1['a']['b2']['c1']='3';
Value inserted.
Elapsed time: 9.25 msec(s).
[default@test] set s1['a']['b2']['c2']='4';
Value inserted.
Elapsed time: 5.16 msec(s).
[default@test] list s1;
Using default limit of 100
Using default column limit of 100
-------------------
RowKey: a
=> (super_column=b1,
		(column=c1, value=1, timestamp=1361088770683000)
		(column=c2, value=2, timestamp=1361088770712000))
=> (super_column=b2,
		(column=c1, value=3, timestamp=1361088770727000)
		(column=c2, value=4, timestamp=1361088770739000))

1 Row Returned.
Elapsed time: 15 msec(s).