[
https://issues.apache.org/jira/browse/CASSANDRA-8012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14157232#comment-14157232
]
Shawn Zhou commented on CASSANDRA-8012:
---------------------------------------
Here is the result:
cqlsh> SELECT * FROM system.schema_keyspaces;
keyspace_name | durable_writes | strategy_class
| strategy_options
-----------------+----------------+------------------------------------------------------+----------------------------
as_id_store | True |
org.apache.cassandra.locator.NetworkTopologyStrategy |
{"DC2":"2","DC1":"2"}
as_user_segment | True |
org.apache.cassandra.locator.NetworkTopologyStrategy |
{"DC2":"2","DC1":"2"}
as_user_fact | True |
org.apache.cassandra.locator.NetworkTopologyStrategy |
{"DC2":"0","DC1":"2"}
OpsCenter | True |
org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"2"}
system | True |
org.apache.cassandra.locator.LocalStrategy | {}
system_traces | True |
org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"2"}
(6 rows)
cqlsh> SELECT * FROM system.schema_columnfamilies;
keyspace_name | columnfamily_name | bloom_filter_fp_chance | caching
| cf_id |
column_aliases | comment
| compaction_strategy_class
| compaction_strategy_options | comparator
| compression_parameters
| default_time_to_live | default_validator
| dropped_columns | gc_grace_seconds | index_interval |
is_dense | key_aliases | key_validator
|
local_read_repair_chance | max_compaction_threshold | max_index_interval |
memtable_flush_period_in_ms | min_compaction_threshold | min_index_interval |
read_repair_chance | speculative_retry | subcomparator | type | value_alias
-----------------+---------------------------+------------------------+---------------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------------------------------+-----------------------------------------------------------------+------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+----------------------+-------------------------------------------+-----------------+------------------+----------------+----------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------+--------------------------+--------------------+-----------------------------+--------------------------+--------------------+--------------------+-------------------+---------------+----------+-------------
as_id_store | foreign_id_to_netid_store | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
aaefa7d7-9d72-3d18-b5f0-02b30cee5bd7 | ["type_from"] |
|
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{"sstable_size_in_mb":"256"} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
2592000 | org.apache.cassandra.db.marshal.UTF8Type | null |
3600 | null | True |
["id_from"] |
org.apache.cassandra.db.marshal.UTF8Type | 0.1 |
32 | 2048 | 0 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | netid
as_user_segment | taxid_to_segid_map | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
cfaa0d76-a48c-330b-a821-bf237a65a7b9 | [] |
|
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{"sstable_size_in_mb":"8"} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.Int32Type | 0.1 |
32 | 2048 | 0 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
as_user_segment | user_segments | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
e586ee3b-bec5-3594-9b94-edbd5e09a03c | [] |
|
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{"sstable_size_in_mb":"256"} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
2592000 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UTF8Type | 0.1 |
32 | 2048 | 0 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
as_user_segment | user_segments_blob | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
0973df41-2b4f-30d0-b21b-05bf758d464e | [] |
|
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{"sstable_size_in_mb":"256"} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
2592000 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UTF8Type | 0.1 |
32 | 2048 | 0 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
as_user_fact | user_profile | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
0f1126aa-3fc4-34b7-84a7-d81acce2194c | [] |
|
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{"sstable_size_in_mb":"256"} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
259200 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UTF8Type | 0.1 |
32 | 2048 | 0 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
OpsCenter | bestpractice_results | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
5f792e9a-85b9-3923-8fe1-f08392c64c6e | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
8 | 2048 | 0 |
2 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | events | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
e6952b0e-d35b-3154-bcd0-cbff061250cb | [] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.UTF8Type | null |
864000 | null | False |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
12 | 2048 | 0 |
8 | 128 | 0.25 | NONE |
null | Standard | null
OpsCenter | events_timeline | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
2b1e2b5a-f040-3042-8e93-7b9db78c2342 | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.LongType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
864000 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
8 | 2048 | 0 |
4 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | pdps | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
cab03baa-a7ab-3d19-8284-2c75e552f716 | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 0 |
4 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | rollups300 | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
45c85324-387b-3523-8d05-6678f8fa8b0f | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.IntegerType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
16 | 2048 | 0 |
4 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | rollups60 | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
98bb99a2-42f2-3fcd-af67-208a4faae5fa | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.IntegerType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 0 |
4 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | rollups7200 | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
349c2c14-e97d-367c-a2ac-d4de7ec12e7f | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.IntegerType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
8 | 2048 | 0 |
2 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | rollups86400 | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
f26e53f3-184c-39a9-9123-8cdea2bad63b | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.IntegerType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
8 | 2048 | 0 |
2 | 128 | 0.25 | NONE |
null | Standard | value
OpsCenter | settings | null |
{"keys":"ALL", "rows_per_partition":"NONE"} |
c1071195-c026-3f5e-b31f-b5780bf41c55 | ["column1"] |
{"info": "OpsCenter management data.", "version": [5, 0, 1]} |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.BytesType |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
864000 | null | True |
["key"] |
org.apache.cassandra.db.marshal.BytesType | 0 |
12 | 2048 | 0 |
8 | 128 | 1 | NONE |
null | Standard | value
system | IndexInfo | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
9f5c6374-d485-3229-9a0a-5094af9ad1e3 | ["index_name"] |
indexes that have been completed |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
0 | null | True |
["table_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard |
system | batchlog | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
0290003c-977e-397c-ac3e-fdfdc01d626b | [] |
uncommited batches |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{"min_threshold":"2"} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
2 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | compaction_history | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
b4dbb7b4-dc49-3fb5-b3bf-ce6e434832ca | [] |
show all compaction history |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(726f77735f6d6572676564:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.LongType)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
604800 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | compactions_in_progress | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
55080ab0-5d9c-3886-90a4-acb25fe1f77b | [] |
unfinished compactions |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(696e70757473:org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.Int32Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | hints | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
2666e205-73ef-38b3-90fe-fecf96e8f0c7 | ["hint_id","message_version"] |
hints awaiting delivery |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{"enabled":"false"} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.Int32Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | True |
["target_id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | mutation
system | local | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
7ad54392-bcdd-35a6-8417-4e047860b377 | [] |
information about the local node |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(7472756e63617465645f6174:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.BytesType),746f6b656e73:org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.UTF8Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["key"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | paxos | 0.1 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
b7b7f0c2-fd0a-3410-8c05-3ef614bb7c2d | ["cf_id"] |
in-progress paxos proposals |
org.apache.cassandra.db.compaction.LeveledCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["row_key"] |
org.apache.cassandra.db.marshal.BytesType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | peer_events | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
59dfeaea-8db2-3341-91ef-109974d81484 | [] |
cf contains events related to peers |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(68696e74735f64726f70706564:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.Int32Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["peer"] |
org.apache.cassandra.db.marshal.InetAddressType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 |
99.0PERCENTILE | null | Standard | null
system | peers | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
37f71aca-7dc2-383b-a706-72528af04d4f | [] |
known peers in the cluster |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(746f6b656e73:org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.UTF8Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["peer"] |
org.apache.cassandra.db.marshal.InetAddressType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 |
99.0PERCENTILE | null | Standard | null
system | range_xfers | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
55d76438-4e55-3f8b-9f6e-676d4af3976d | [] |
ranges requested for transfer here |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["token_bytes"] |
org.apache.cassandra.db.marshal.BytesType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | schema_columnfamilies | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
45f5b360-24bc-3f83-a363-1034ea4fa697 | ["columnfamily_name"] |
ColumnFamily definitions |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(64726f707065645f636f6c756d6e73:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.LongType)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 604800 | null | False |
["keyspace_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | schema_columns | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
296e9c04-9bec-3085-827d-c17d3df2122a | ["columnfamily_name","column_name"] |
ColumnFamily column attributes |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 604800 | null | False |
["keyspace_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | schema_keyspaces | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
b0f22357-4458-3cdb-9631-c43e59ce3676 | [] |
keyspace definitions |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.UTF8Type |
{"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType | null |
604800 | null | False |
["keyspace_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | schema_triggers | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
0359bc71-7123-3ee1-9a4a-b9dfb11fc125 | ["columnfamily_name","trigger_name"] |
triggers metadata table |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(747269676765725f6f7074696f6e73:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 604800 | null | False |
["keyspace_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | schema_usertypes | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
3aa75225-4f82-350b-8d5c-430fa221fa0a | ["type_name"] |
Defined user types |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(6669656c645f6e616d6573:org.apache.cassandra.db.marshal.ListType(org.apache.cassandra.db.marshal.UTF8Type),6669656c645f7479706573:org.apache.cassandra.db.marshal.ListType(org.apache.cassandra.db.marshal.UTF8Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 604800 | null | False |
["keyspace_name"] |
org.apache.cassandra.db.marshal.UTF8Type | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system | sstable_activity | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
5a1ff267-ace0-3f12-8563-cfae6103c65e | [] |
historic sstable read rates |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["keyspace_name","columnfamily_name","generation"] |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.Int32Type)
| 0 | 32 | 2048 |
3600000 | 4 | 128 |
0 | 99.0PERCENTILE | null | Standard | null
system_traces | events | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
8826e8e9-e16a-3728-8753-3bc1fc713c25 | ["event_id"] |
|
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.UTF8Type)
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["session_id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
system_traces | sessions | 0.01 |
{"keys":"ALL", "rows_per_partition":"NONE"} |
c5e99f16-8677-3914-b17e-960613512345 | [] |
traced sessions |
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy |
{} |
org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.ColumnToCollectionType(706172616d6574657273:org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)))
| {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} |
0 | org.apache.cassandra.db.marshal.BytesType |
null | 0 | null | False |
["session_id"] |
org.apache.cassandra.db.marshal.UUIDType | 0 |
32 | 2048 | 3600000 |
4 | 128 | 0 | 99.0PERCENTILE |
null | Standard | null
(32 rows)
cqlsh> SELECT * FROM system.schema_columns;
keyspace_name | columnfamily_name | column_name |
component_index | index_name | index_options | index_type | type |
validator
-----------------+---------------------------+-----------------------------+-----------------+------------+---------------+------------+----------------+-----------------------------------------------------------------------------------------------------------------------------
as_id_store | foreign_id_to_netid_store | id_from |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
as_id_store | foreign_id_to_netid_store | netid |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.UTF8Type
as_id_store | foreign_id_to_netid_store | type_from |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
as_user_segment | taxid_to_segid_map | calculation_time |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimestampType
as_user_segment | taxid_to_segid_map | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.Int32Type
as_user_segment | taxid_to_segid_map | mapping |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
as_user_segment | user_segments | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
as_user_segment | user_segments | segments |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
as_user_segment | user_segments_blob | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
as_user_segment | user_segments_blob | segments |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
as_user_fact | user_profile | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
as_user_fact | user_profile | profile |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | bestpractice_results | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.ReversedType(org.apache.cassandra.db.marshal.IntegerType)
OpsCenter | bestpractice_results | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | bestpractice_results | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | events | action |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.LongType
OpsCenter | events | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | events | level |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.LongType
OpsCenter | events | success |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.BooleanType
OpsCenter | events | time |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.LongType
OpsCenter | events_timeline | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.LongType
OpsCenter | events_timeline | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | events_timeline | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | pdps | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | pdps | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | pdps | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | rollups300 | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.IntegerType
OpsCenter | rollups300 | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | rollups300 | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | rollups60 | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.IntegerType
OpsCenter | rollups60 | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | rollups60 | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | rollups7200 | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.IntegerType
OpsCenter | rollups7200 | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | rollups7200 | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | rollups86400 | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.IntegerType
OpsCenter | rollups86400 | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
OpsCenter | rollups86400 | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | settings | column1 |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | settings | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.BytesType
OpsCenter | settings | value |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
system | IndexInfo | |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
system | IndexInfo | index_name |
null | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | IndexInfo | table_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | batchlog | data |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
system | batchlog | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system | batchlog | version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | batchlog | written_at |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimestampType
system | compaction_history | bytes_in |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.LongType
system | compaction_history | bytes_out |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.LongType
system | compaction_history | columnfamily_name |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | compaction_history | compacted_at |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimestampType
system | compaction_history | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system | compaction_history | keyspace_name |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | compaction_history | rows_merged |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.Int32Type,org.apache.cassandra.db.marshal.LongType)
system | compactions_in_progress | columnfamily_name |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | compactions_in_progress | id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system | compactions_in_progress | inputs |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.Int32Type)
system | compactions_in_progress | keyspace_name |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | hints | hint_id |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.TimeUUIDType
system | hints | message_version |
1 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.Int32Type
system | hints | mutation |
null | null | null | null | compact_value |
org.apache.cassandra.db.marshal.BytesType
system | hints | target_id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system | local | bootstrapped |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | cluster_name |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | cql_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | data_center |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | gossip_generation |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | local | host_id |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UUIDType
system | local | key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | local | native_protocol_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | partitioner |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | rack |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | release_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | schema_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UUIDType
system | local | thrift_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | local | tokens |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.UTF8Type)
system | local | truncated_at |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.BytesType)
system | paxos | cf_id |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UUIDType
system | paxos | in_progress_ballot |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimeUUIDType
system | paxos | most_recent_commit |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
system | paxos | most_recent_commit_at |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimeUUIDType
system | paxos | proposal |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.BytesType
system | paxos | proposal_ballot |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimeUUIDType
system | paxos | row_key |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.BytesType
system | peer_events | hints_dropped |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.Int32Type)
system | peer_events | peer |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.InetAddressType
system | peers | data_center |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | peers | host_id |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UUIDType
system | peers | peer |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.InetAddressType
system | peers | preferred_ip |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.InetAddressType
system | peers | rack |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | peers | release_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | peers | rpc_address |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.InetAddressType
system | peers | schema_version |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UUIDType
system | peers | tokens |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.UTF8Type)
system | range_xfers | requested_at |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimestampType
system | range_xfers | token_bytes |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.BytesType
system | schema_columnfamilies | bloom_filter_fp_chance |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.DoubleType
system | schema_columnfamilies | caching |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | cf_id |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UUIDType
system | schema_columnfamilies | column_aliases |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | columnfamily_name |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | comment |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | compaction_strategy_class |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | compaction_strategy_options |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | comparator |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | compression_parameters |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | default_time_to_live |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | default_validator |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | dropped_columns |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.LongType)
system | schema_columnfamilies | gc_grace_seconds |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | index_interval |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | is_dense |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.BooleanType
system | schema_columnfamilies | key_aliases |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | key_validator |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | keyspace_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | local_read_repair_chance |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.DoubleType
system | schema_columnfamilies | max_compaction_threshold |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | max_index_interval |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | memtable_flush_period_in_ms |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | min_compaction_threshold |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | min_index_interval |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columnfamilies | read_repair_chance |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.DoubleType
system | schema_columnfamilies | speculative_retry |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | subcomparator |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | type |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columnfamilies | value_alias |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | column_name |
1 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | columnfamily_name |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | component_index |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system | schema_columns | index_name |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | index_options |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | index_type |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | keyspace_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | type |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_columns | validator |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_keyspaces | durable_writes |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.BooleanType
system | schema_keyspaces | keyspace_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_keyspaces | strategy_class |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_keyspaces | strategy_options |
null | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_triggers | columnfamily_name |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_triggers | keyspace_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_triggers | trigger_name |
1 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_triggers | trigger_options |
2 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)
system | schema_usertypes | field_names |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.ListType(org.apache.cassandra.db.marshal.UTF8Type)
system | schema_usertypes | field_types |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.ListType(org.apache.cassandra.db.marshal.UTF8Type)
system | schema_usertypes | keyspace_name |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | schema_usertypes | type_name |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.UTF8Type
system | sstable_activity | columnfamily_name |
1 | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | sstable_activity | generation |
2 | null | null | null | partition_key |
org.apache.cassandra.db.marshal.Int32Type
system | sstable_activity | keyspace_name |
0 | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UTF8Type
system | sstable_activity | rate_120m |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.DoubleType
system | sstable_activity | rate_15m |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.DoubleType
system_traces | events | activity |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system_traces | events | event_id |
0 | null | null | null | clustering_key |
org.apache.cassandra.db.marshal.TimeUUIDType
system_traces | events | session_id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system_traces | events | source |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.InetAddressType
system_traces | events | source_elapsed |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system_traces | events | thread |
1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system_traces | sessions | coordinator |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.InetAddressType
system_traces | sessions | duration |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.Int32Type
system_traces | sessions | parameters |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.MapType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)
system_traces | sessions | request |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
system_traces | sessions | session_id |
null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.UUIDType
system_traces | sessions | started_at |
0 | null | null | null | regular |
org.apache.cassandra.db.marshal.TimestampType
(166 rows)
> cqlsh "DESCRIBE KEYSPACES;" returns empty after upgrade
> -------------------------------------------------------
>
> Key: CASSANDRA-8012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8012
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Environment: cassandra 2.1.0
> Reporter: Shawn Zhou
> Labels: cqlsh
>
> after upgrade from 2.0.7 to 2.1.0
> run cqlsh "DESCRIBE KEYSPACES;" returns empty result;
> query individual table does return data;
> See below:
> {noformat}
> [root@dc1-stg-cassandra-08 cassandra]# cqlsh
> dc1-stg-cassandra-08.dc01.revsci.net -k as_user_segment
> Connected to Stage Cluster at dc1-stg-cassandra-08.dc01.revsci.net:9042.
> [cqlsh 5.0.1 | Cassandra 2.1.0 | CQL spec 3.2.0 | Native protocol v3]
> Use HELP for help.
> cqlsh:as_user_segment> DESCRIBE KEYSPACES;
> <empty>
> cqlsh:as_user_segment> select * from user_segments_blob where id =
> '8e6090087fc1a7591a99dc4cb744ac43';
> id | segments
> ----------------------------------+------------------------------------------------------------------------------------
> 8e6090087fc1a7591a99dc4cb744ac43 |
> 0x94160000b0150000911d00003b0e0000211a0000ee22000072160000ab1c0000df0f000042040000
> (1 rows)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
