sstableofflinerelevel
Uses LeveledCompactionStrategy to create a decent leveling for the given keyspace and table while the DSE node is offline.
Restriction: Stop DataStax Enterprise before you run this command.
The default location of this SSTable tool depends on the type of installation:
-
Package installations:
/usr/bin/
-
Tarball installations:
<installation_location>/resources/cassandra/tools/bin
Synopsis
sstableofflinerelevel
[--dry-run]
<keyspace_name> <table_name>
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
<`Italics>` |
Variable value. Replace with a valid option or user-defined value. |
|
Optional.
Square brackets ( |
|
Group.
Parentheses ( |
|
Or.
A vertical bar ( |
|
Repeatable.
An ellipsis ( |
|
Single quotation ( |
|
Map collection.
Braces ( |
|
Set, list, map, or tuple.
Angle brackets ( |
|
End CQL statement.
A semicolon ( |
|
Separate the command line options from the command arguments with two hyphens ( |
|
Search CQL only: Single quotation marks ( |
|
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files. |
Definition
The short form and long form parameters are comma-separated.
Command arguments
- --dry-run
-
Test command syntax and environment. Do not execute the command.
- keyspace_name
-
Keyspace name. Required.
- table_name
-
Table name. Required.
Examples
Verify DataStax Enterprise is not running
nodetool status
Datacenter: Graph
================================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 10.200.177.92 265.04 KiB 1 ? 980cab6a-2e5d-44c6-b897-0733dde580ac rack1
DN 10.200.177.94 426.21 KiB 1 ? 7ecbbc0c-627d-403e-b8cc-a2daa93d9ad3 rack1
Relevel calendar table on cycling keyspace
Restriction: Stop DataStax Enterprise before you run this command.
sstableofflinerelevel cycling calendar
No sstables to relevel for cycling.calendar