You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by Apache Wiki <wi...@apache.org> on 2009/12/14 21:38:32 UTC

[Cassandra Wiki] Update of "Operations" by EricEvans

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Cassandra Wiki" for change notification.

The "Operations" page has been changed by EricEvans.
The comment on this change is: some words about json export/import.
http://wiki.apache.org/cassandra/Operations?action=diff&rev1=16&rev2=17

--------------------------------------------------

  To revert to a snapshot, shut down the node, clear out the old commitlog and sstables, and move the sstables from the snapshot location to the live data directory.
  
  === Import / export ===
- Cassandra can also export data as JSON with `bin/sstable2json`, and import it with `bin/json2sstable`.  Eric to document. :)
+ As an alternative to taking snapshots it's possible to export SSTables to JSON format using the `bin/sstable2json` command:
+ 
+ {{{
+ Usage: sstable2json [-f outfile] <sstable> [-k key [-k key [...]]]
+ }}}
+ 
+ `bin/sstable2json` accepts as a required argument, the full path to an SSTable data file, (files ending in -Data.db), and an optional argument for an output file (by default, output is written to stdout). You can also pass the names of specific keys using the `-k` argument to limit what is exported.
+ 
+ Note: If you are not running the exporter on in-place SSTables, there are a couple of things to keep in mind.
+  1. The corresponding configuration must be present (same as it would be to run a node).
+  2. SSTables are expected to be in a directory named for the keyspace (same as they would be on a production node).
+ 
+ JSON exported SSTables can be "imported" to create new SSTables using `bin/json2sstable`:
+ 
+ {{{
+ Usage: json2sstable -K keyspace -c column_family <json> <sstable>
+ }}}
+ 
+ `bin/json2sstable` takes arguments for keyspace and column family names, and full paths for the JSON input file and the destination SSTable file name.
  
  == Monitoring ==
  Cassandra exposes internal metrics as JMX data.  This is a common standard in the JVM world; OpenNMS, Nagios, and Munin at least offer some level of JMX support.