Fabric uses the Cassandra DB as a storage layer. CQL commands can be run to check Cassandra tables on Fabric keyspaces.
Use the following command to connect to Cassandra from the Cassandra server:
For Cassandra 3.11.14 (Python 2.7):
cqlsh -u <username> -p <password> <ip_address>
For Cassandra 4.0.3 / 4.1.3 (Python 3.x):
python3 -m cqlsh <ip_address> -u <username> -p <password>
Note:
On systems like RHEL 7 wherepython
points to Python 2.7 by default, you must usepython3
to launchcqlsh
when working with Cassandra 4.x, otherwise you'll encounter compatibility errors.
The following table holds useful cqlsh commands.
For more information, see https://docs.datastax.com/en/cql-oss/3.x/cql/cql_reference/cqlCommandsTOC.html.
Command Name |
Command Description |
Examples |
HELP |
Get information about the list of Cassandra commands or a specific Cassandra command. |
|
USE |
Move to a specific keyspace |
|
DESCRIBE (shorthand: DESC) |
Describe Cassandra objects. Note that the Describe command is run in a keyspace and returns information about the objects in the keyspace. For more information, see: https://docs.datastax.com/en/cql-oss/3.x/cql/cql_reference/cqlshDescribe.html |
|
EXIT/QUIT |
Exit Cassandra |
|
The Fabric Studio Debug Panel can be used to start, stop and open the local Cassandra Console. Alternatively, do the following:
Fabric uses the Cassandra DB as a storage layer. CQL commands can be run to check Cassandra tables on Fabric keyspaces.
Use the following command to connect to Cassandra from the Cassandra server:
For Cassandra 3.11.14 (Python 2.7):
cqlsh -u <username> -p <password> <ip_address>
For Cassandra 4.0.3 / 4.1.3 (Python 3.x):
python3 -m cqlsh <ip_address> -u <username> -p <password>
Note:
On systems like RHEL 7 wherepython
points to Python 2.7 by default, you must usepython3
to launchcqlsh
when working with Cassandra 4.x, otherwise you'll encounter compatibility errors.
The following table holds useful cqlsh commands.
For more information, see https://docs.datastax.com/en/cql-oss/3.x/cql/cql_reference/cqlCommandsTOC.html.
Command Name |
Command Description |
Examples |
HELP |
Get information about the list of Cassandra commands or a specific Cassandra command. |
|
USE |
Move to a specific keyspace |
|
DESCRIBE (shorthand: DESC) |
Describe Cassandra objects. Note that the Describe command is run in a keyspace and returns information about the objects in the keyspace. For more information, see: https://docs.datastax.com/en/cql-oss/3.x/cql/cql_reference/cqlshDescribe.html |
|
EXIT/QUIT |
Exit Cassandra |
|
The Fabric Studio Debug Panel can be used to start, stop and open the local Cassandra Console. Alternatively, do the following: