Insert super column using Cassandra command line-优快云博客

本文介绍 Cassandra 命令行界面(CLI)的基本使用方法及示例操作，包括连接集群、设置与获取超级列族数据等。通过具体实例展示如何在 Cassandra 中进行数据的插入、查询等操作。

cassandra> [color=green]connect 10.240.70.60/9160[/color]
Connected to: "Test Cluster" on 10.240.70.60/9160
cassandra> [color=green]help[/color]
List of all CLI commands:
? Same as help.
help Display this help.
connect <hostname>/<port> Connect to thrift service.
describe keyspace <keyspacename> Describe keyspace.
exit Exit CLI.
quit Exit CLI.
show config file Display contents of config file.
show cluster name Display cluster name.
show keyspaces Show list of keyspaces.
show api version Show server API version.
get <ksp>.<cf>['<key>'] Get a slice of columns.
get <ksp>.<cf>['<key>']['<super>'] Get a slice of sub columns.
get <ksp>.<cf>['<key>']['<col>'] Get a column value.
get <ksp>.<cf>['<key>']['<super>']['<col>'] Get a sub column value.
set <ksp>.<cf>['<key>']['<col>'] = '<value>' Set a column.
set <ksp>.<cf>['<key>']['<super>']['<col>'] = '<value>' Set a sub column.
del <ksp>.<cf>['<key>'] Delete record.
del <ksp>.<cf>['<key>']['<col>'] Delete column.
del <ksp>.<cf>['<key>']['<super>']['<col>'] Delete sub column.
count <ksp>.<cf>['<key>'] Count columns in record.
count <ksp>.<cf>['<key>']['<super>'] Count columns in a super column.
cassandra> [color=green]set Keyspace1.Super2['key1']['super1']['column1']='value1'[/color]
Value inserted.
cassandra> [color=green]set Keyspace1.Super2['key1']['super1']['column2']='value2'[/color]
Value inserted.
cassandra> [color=green]set Keyspace1.Super2['key1']['super2']['column1']='value3'[/color]
Value inserted.
cassandra>[color=green] set Keyspace1.Super2['key1']['super2']['column2']='value4'[/color]
Value inserted.
cassandra> [color=green]set Keyspace1.Super2['key2']['super1']['column1']='value5'[/color]
Value inserted.
cassandra>[color=green] set Keyspace1.Super2['key2']['super1']['column2']='value6'[/color]
Value inserted.
cassandra> [color=green]set Keyspace1.Super2['key2']['super2']['column1']='value7'[/color]
Value inserted.
cassandra> [color=green]set Keyspace1.Super2['key2']['super2']['column2']='value8'[/color]
Value inserted.
cassandra> [color=green]get Keyspace1.Super2['key1'][/color]
=> (super_column=super2,
(column=column1, value=value3, timestamp=1279599872232000)
(column=column2, value=value4, timestamp=1279599881611000))
=> (super_column=super1,
(column=column1, value=value1, timestamp=1279599818380000)
(column=column2, value=value2, timestamp=1279599829557000))
Returned 2 results.
cassandra> [color=green]get Keyspace1.Super2['key2'][/color]
=> (super_column=super2,
(column=column1, value=value7, timestamp=1279599937855000)
(column=column2, value=value8, timestamp=1279599945124000))
=> (super_column=super1,
(column=column1, value=value5, timestamp=1279599913391000)
(column=column2, value=value6, timestamp=1279599921910000))
Returned 2 results.
cassandra>