Database Reference
In-Depth Information
[["","",1412989884066000],
["fname","Brian",1412989884066000],
["lname","Neill",1412989884066000]]},
{"key": "f7d1f2c050e211e4abc13f484de45426","columns":
[["","",1412989647852000],
["fname","vivek",1412989647852000],
["lname","mishra",1412989647852000]]}
]
849d582050e311e4abc13f484de45426 and
f7d1f2c050e211e4abc13f484de45426 are the user IDs for
brian and vivek.
Similarly, we can exclude specific keys using the -x option:
$CASSANDRA_HOME/bin/sstable2json /var/lib/cassandra/data/
twitterkeyspace/user/twitterkeyspace-user-jb-1-Data.db -x
849d582050e311e4abc13f484de45426
f7d1f2c050e211e4abc13f484de45426
[
{"key": "74ac3a8050e311e4abc13f484de45426","columns":
[["","",1412989857319000],
["fname","Melissa",1412989857319000],
["lname","Maldonado",1412989857319000]]},
{"key": "7c34a26050e311e4abc13f484de45426","columns":
[["","",1412989869958000],
["fname","Chris",1412989869958000],
["lname","Nelson",1412989869958000]]}
]
Importing JSON Data with json2sstable
Similarly we can import JSON data back into sstable using json2sstable in a few
simple steps:
1.
First create a table dumpuser with the keyspace twitterkey-
space using the cql shell:
Search WWH ::




Custom Search