cassandra基本操作

最新推荐文章于 2023-03-02 14:25:10 发布

bwz999@88.com

最新推荐文章于 2023-03-02 14:25:10 发布

阅读量264

点赞数

CC 4.0 BY-SA版权

文章标签： cassandra

本文链接：https://blog.youkuaiyun.com/mnbwz/article/details/113796321

此博客展示了如何使用cqlsh连接到名为TestCluster的Cassandra集群，并进行键空间和表的描述性查询。查询结果显示了system_traces、system_schema、system_auth、system和system_distributed等键空间内的表格分布，揭示了数据库的架构和组织。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[db02@centos1 bin]$ ./cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.10 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh> describe cluster;

Cluster: Test Cluster
Partitioner: Murmur3Partitioner

cqlsh> describe keyspaces;

system_traces  system_schema  system_auth  system  system_distributed

cqlsh> describe tables;

Keyspace system_traces
----------------------
events  sessions

Keyspace system_schema
----------------------
tables     triggers    views    keyspaces  dropped_columns
functions  aggregates  indexes  types      columns        

Keyspace system_auth
--------------------
resource_role_permissons_index  role_permissions  role_members  roles

Keyspace system
---------------
available_ranges          peers               batchlog        transferred_ranges
batches                   compaction_history  size_estimates  hints             
prepared_statements       sstable_activity    built_views   
"IndexInfo"               peer_events         range_xfers   
views_builds_in_progress  paxos               local         

Keyspace system_distributed
---------------------------
repair_history  view_build_status  parent_repair_history

cqlsh> show host;
Connected to Test Cluster at 127.0.0.1:9042.
cqlsh> show version;
[cqlsh 5.0.1 | Cassandra 3.11.10 | CQL spec 3.4.4 | Native protocol v4]
cqlsh> exit
[db02@centos1 bin]$