Insert super column using Cassandra command line -

a80317

浏览: 8611 次
性别:
来自: 杭州

最近访客更多访客>>

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (4)

社区版块

存档分类

Insert super column using Cassandra command line

Cassandra

cassandra> connect 10.240.70.60/9160
Connected to: "Test Cluster" on 10.240.70.60/9160
cassandra> help
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> set Keyspace1.Super2['key1']['super1']['column1']='value1'
Value inserted.
cassandra> set Keyspace1.Super2['key1']['super1']['column2']='value2'
Value inserted.
cassandra> set Keyspace1.Super2['key1']['super2']['column1']='value3'
Value inserted.
cassandra> set Keyspace1.Super2['key1']['super2']['column2']='value4'
Value inserted.
cassandra> set Keyspace1.Super2['key2']['super1']['column1']='value5'
Value inserted.
cassandra> set Keyspace1.Super2['key2']['super1']['column2']='value6'
Value inserted.
cassandra> set Keyspace1.Super2['key2']['super2']['column1']='value7'
Value inserted.
cassandra> set Keyspace1.Super2['key2']['super2']['column2']='value8'
Value inserted.
cassandra> get Keyspace1.Super2['key1']
=> (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> get Keyspace1.Super2['key2']
=> (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>

分享到：