Database Reference
In-Depth Information
create keyspace twitterkeyspace with
replication = {'class':'SimpleStrategy',
'replication_factor':3}
use twitterkeyspace;
create table user(user_id timeuuid primary
key, fname text,lname text);
2.
Let's insert a few records:
insert into user(user_id,fname,lname)
values(now(),'vivek','mishra');
insert into user(user_id,fname,lname)
values(now(),'Melissa','Maldonado');
insert into user(user_id,fname,lname)
values(now(),'Chris','Nelson');
insert into user(user_id,fname,lname)
values(now(),'Brian','Neill');
select * from user;
user_id |
fname | lname
--------------------------------------+---------+-----------
849d5820-50e3-11e4-abc1-3f484de45426 |
Brian | Neill
74ac3a80-50e3-11e4-abc1-3f484de45426 |
Melissa | Maldonado
7c34a260-50e3-11e4-abc1-3f484de45426 |
Chris | Nelson
f7d1f2c0-50e2-11e4-abc1-3f484de45426 |
vivek | mishra
3.
Let's flush this data into sstables using nodetool flush :
$CASSANDRA_HOME/bin/nodetool flush
4.
Finally, export data in a JSON file using sstable2json :
$CASSANDRA_HOME/bin/sstable2json /var/lib/
cassandra/data/twitterkeyspace/user/
Search WWH ::




Custom Search