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>- VERSION
-
Show the version for CQL shell, the database, the CQL specification, and native protocol.
- HOST
-
Show the node details for the CQL shell 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 CQL shell 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 VERSIONExample 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 CQL shell session host:
SHOW HOSTReturns 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
. . .