mysql의 show tables, show databases와 같은 기능은 다음과 같다.
1. show databases;
cqlsh:os_ui> select * from system.schema_keyspaces;
keyspace_name | durable_writes | strategy_class | strategy_options
---------------+----------------+------------------------------------------------------+----------------------------
os_ui | True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"1"}
2. show tables;
cqlsh:os_ui> select * from system.schema_columnfamilies;
keyspace_name | columnfamily_name | bloom_filter_fp_chance | caching | 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 | key_aliases | key_validator | local_read_repair_chance | max_compaction_threshold | memtable_flush_period_in_ms | min_compaction_threshold | populate_io_cache_on_flush | read_repair_chance | replicate_on_write | speculative_retry | subcomparator | type | value_alias
---------------+-------------------------+------------------------+-----------+--------------------------------------+-------------------------------------+-----------------------------------------------------------------+-----------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------+----------------------+-------------------------------------------+-----------------+------------------+----------------+----------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------+--------------------------+-----------------------------+--------------------------+----------------------------+--------------------+--------------------+-------------------+---------------+----------+-------------
os_ui | cpu_util_pct | 0.01 | KEYS_ONLY | ["ts"] | | org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy | {} | org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.TimestampType,org.apache.cassandra.db.marshal.UTF8Type) | {"sstable_compression":"org.apache.cassandra.io.compress.LZ4Compressor"} | 0 | org.apache.cassandra.db.marshal.BytesType | null | 864000 | 128 | ["guid"] | org.apache.cassandra.db.marshal.UTF8Type | 0 | 32 | 0 | 4 | False | 0.1 | True | 99.0PERCENTILE | null | Standard | null
'nosql' 카테고리의 다른 글
cassandra 운영 툴 - ops center, dev center (0) | 2013.11.26 |
---|---|
cassandra 2.0 - unit test (standalone cassandra daemon) (0) | 2013.11.18 |
cassandra 2.0.2 - insert 시 기존 데이터 update (append 되지 않음) (0) | 2013.11.18 |
cassandra 2.0 - data type 지원 (primitive type, map, set, list) (1) | 2013.11.13 |
cassandra - localhost에서 clustering구성시 사용하는 스크립트 (0) | 2013.11.13 |