SHOW
Shows this information depending on the options selected:
-
Software version.
-
Current session node.
-
Tracing session details captured in the past 24 hours.
Synopsis
SHOW VERSION | HOST | SESSION <tracing_session_id>
Syntax legend
Syntax conventions | Description |
---|---|
UPPERCASE |
Literal keyword. |
Lowercase |
Not literal. |
|
Variable value. Replace with a 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. |
- VERSION
-
Show the version for cqlsh, the database, the CQL specification, and native protocol.
- HOST
-
Show the node details for the cqlsh session host.
- SESSION <tracing_session_id>
-
Show the activity details for a specific query provided in <tracing_session_id>. Session IDs are shown in the query results and are recorded to the system_traces.sessions table.
All queries run from a TRACING enabled cqlsh session are captured in the session and events table and saved for 24 hours. After that time, the tracing information time-to-live expires.
Examples
Show the version:
SHOW VERSION
Example output, which varies depending on your implementation:
[cqlsh 6.8.0 | DSE 6.8.0 | CQL spec 3.4.5 | DSE protocol v2]
Show the host information for the cqlsh session host:
SHOW HOST
Returns the host name, IP address, and port of the CQL shell session. For example:
Connected to Test Cluster at 127.0.0.1:9042.
Show the request activity details for a specific session:
SHOW SESSION d0321c90-508e-11e3-8c7b-73ded3cb6170
Use a session ID from the query results or from the system_traces.sessions table. |
Sample output from SHOW SESSION:
Tracing session: d0321c90-508e-11e3-8c7b-73ded3cb6170
activity | timestamp | source | source_elapsed
-----------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------+----------------
execute_cql3_query | 12:19:52,372 | 127.0.0.1 | 0
Parsing CREATE TABLE emp (\n empID int,\n deptID int,\n first_name varchar,\n last_name varchar,\n PRIMARY KEY (empID, deptID)\n); | 12:19:52,372 | 127.0.0.1 | 153
Request complete | 12:19:52,372 | 127.0.0.1 | 650
. . .