SHOW

Shows the Cassandra version, host, or data type assumptions for the current cqlsh client session.

Shows the Cassandra version, host, or data type assumptions for the current cqlsh client session.

Synopsis 

SHOW VERSION
| HOST
| ASSUMPTIONS
Legend
  • Uppercase means literal
  • Lowercase means not literal
  • Italics mean optional
  • The pipe (|) symbol means OR or AND/OR
  • Ellipsis (...) means repeatable

A semicolon that terminates CQL statements is not included in the synopsis.

Description 

A SHOW command displays this information about the current cqlsh client session:

  • The version and build number of the connected Cassandra instance, as well as the CQL mode for cqlsh and the Thrift protocol used by the connected Cassandra instance.
  • The host information of the Cassandra node that the cqlsh session is currently connected to.
  • The data type assumptions for the current cqlsh session as specified by the ASSUME command.
SHOW VERSION;

SHOW HOST;

SHOW ASSUMPTIONS;