system.local - DSE vs DSC

system_local_schema.md

For 4.6.0 DataStax Enterprise (nightly, 10/21)

cqlsh:system> DESC TABLE local; 

CREATE TABLE local (
  key text,
  bootstrapped text,
  cluster_name text,
  cql_version text,
  data_center text,
  dse_version text,
  gossip_generation int,
  host_id uuid,
  native_protocol_version text,
  partitioner text,
  rack text,
  release_version text,
  schema_version uuid,
  thrift_version text,
  tokens set<text>,
  truncated_at map<uuid, blob>,
  workload text,
  PRIMARY KEY ((key))
)...
...
cqlsh:system> SELECT cluster_name, release_version, dse_version, schema_version, cql_version FROM local;  

 cluster_name   | release_version | dse_version | schema_version                       | cql_version
----------------+-----------------+-------------+--------------------------------------+-------------
 andrew_lenards |       2.0.10.71 |       4.6.0 | 85fc126e-3bcf-31e6-8940-6ef891f6e63a |       3.1.7

(1 rows)

For 2.0.10 DataStax Community edition tarball

cqlsh:system> DESC TABLE local; 

CREATE TABLE local (
  key text,
  bootstrapped text,
  cluster_name text,
  cql_version text,
  data_center text,
  gossip_generation int,
  host_id uuid,
  native_protocol_version text,
  partitioner text,
  rack text,
  release_version text,
  schema_version uuid,
  thrift_version text,
  tokens set<text>,
  truncated_at map<uuid, blob>,
  PRIMARY KEY ((key))
) ... 
...
cqlsh:system> SELECT cluster_name, release_version, schema_version, cql_version FROM local; 

 cluster_name | release_version | schema_version                       | cql_version
--------------+-----------------+--------------------------------------+-------------
 Test Cluster |          2.0.10 | 1b33d2c1-4cbe-3d8a-adab-b7e7ee64772f |       3.1.7

(1 rows)