cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shawn Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8012) cqlsh "DESCRIBE KEYSPACES;" returns empty after upgrade
Date Thu, 02 Oct 2014 21:39:35 GMT

    [ 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)

Mime
View raw message