sstableupgrade

Upgrade the SSTables in the specified snapshot to match the currently installed version of DataStax Enterprise.

Rewrite the SSTables in the specified snapshot to match the currently installed version of the DataStax Enterprise database.

To restore a table from a snapshot with sstableloader, upgrade to a compatible SSTable version. SSTable versions are incremented when the format changes (not with each release of the database).

Use the version number and format in the SSTable file name to determine compatibility and upgrade requirements. The first two letters of the file name is the version, where the first letter indicates a major version and the second letter indicates a minor version.

For example, the following SSTable version is aa and the format is bti:
data/cycling/cyclist_expenses-e4f31e122bc511e8891b23da85222d3d/aa-1-bti-Data.db
Table 1. SSTable compatibility and upgrade version
DSE version SSTable sstableloader supported format-version sstableupgrade and nodetool upgradesstables supported format-version
format version
4.7 big ka big-ka and big-jb big-j* only
4.8
5.0.x ma big-ka and big-ma big-k* only
5.0.x mb big-ka, big-ma, and big-mb big-ka and big-ma
5.0.x mc big-ka, big-ma, big-mb, and big-mc big-ka, big-ma, and big-mb
5.1.x
6.0.x bti aa big-ma, big-mb, big-mc, and bti-aa big-ma, big-mb, and big-mc

Cassandra tools directory

The default location of the Cassandra tools depends on the type of installation:
  • Package installations: /usr/bin/
  • Tarball installations: installation_location/resources/cassandra/tools/bin

Usage:

sstableupgrade [options] keyspace_name table_name [snapshot_filename]
SSTable tools are located in the Cassandra tools directory.
Tip: SSTable tools work offline from the DataStax Enterprise database. If you need to pass a JVM parameter, specify it in the command line. For example, to change the max heap size:
MAX_HEAP=2g sstabletoolname

The snapshot option upgrades the specified snapshot only.

Table 2. Options
Flag Option Description
--debug Display stack traces.
-h --help Display help.