Instantly share code, notes, and snippets.

Embed
What would you like to do?
cassandra-cli-midonet
# cassandra-cli -h 192.168.1.5 -p 9160
Connected to: "midonet" on 192.168.1.5/9160
Welcome to Cassandra CLI version 2.1.5
The CLI is deprecated and will be removed in Cassandra 3.0. Consider migrating to cqlsh.
CQL is fully backwards compatible with Thrift data; see http://www.datastax.com/dev/blog/thrift-to-cql3
Type 'help;' or '?' for help.
Type 'quit;' or 'exit;' to quit.
[default@unknown] show cluster name;
midonet
[default@unknown] show keyspaces;
WARNING: CQL3 tables are intentionally omitted from 'show keyspaces' output.
See https://issues.apache.org/jira/browse/CASSANDRA-4377 for details.
WARNING: Could not connect to the JMX on 192.168.1.5:7199 - some information won't be shown.
Keyspace: midonetflowstate:
Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
Durable Writes: true
Options: [replication_factor:1]
Column Families:
WARNING: Could not connect to the JMX on 192.168.1.5:7199 - some information won't be shown.
Keyspace: system:
Replication Strategy: org.apache.cassandra.locator.LocalStrategy
Durable Writes: true
Options: []
Column Families:
ColumnFamily: IndexInfo
"indexes that have been completed"
Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Default column value validator: org.apache.cassandra.db.marshal.BytesType
Cells sorted by: org.apache.cassandra.db.marshal.UTF8Type
GC grace seconds: 0
Compaction min/max thresholds: 4/32
Read repair chance: 0.0
DC Local Read repair chance: 0.0
Caching: KEYS_ONLY
Default time to live: 0
Bloom Filter FP chance: 0.01
Index interval: default
Speculative Retry: 99.0PERCENTILE
Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
Compression Options:
sstable_compression: org.apache.cassandra.io.compress.LZ4Compressor
ColumnFamily: hints
"hints awaiting delivery"
Key Validation Class: org.apache.cassandra.db.marshal.UUIDType
Default column value validator: org.apache.cassandra.db.marshal.BytesType
Cells sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.TimeUUIDType,org.apache.cassandra.db.marshal.Int32Type)
GC grace seconds: 0
Compaction min/max thresholds: 4/32
Read repair chance: 0.0
DC Local Read repair chance: 0.0
Caching: KEYS_ONLY
Default time to live: 0
Bloom Filter FP chance: 0.01
Index interval: default
Speculative Retry: 99.0PERCENTILE
Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
Compaction Strategy Options:
enabled: false
Compression Options:
sstable_compression: org.apache.cassandra.io.compress.LZ4Compressor
ColumnFamily: schema_keyspaces
"keyspace definitions"
Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Default column value validator: org.apache.cassandra.db.marshal.BytesType
Cells sorted by: org.apache.cassandra.db.marshal.UTF8Type
GC grace seconds: 604800
Compaction min/max thresholds: 4/32
Read repair chance: 0.0
DC Local Read repair chance: 0.0
Caching: KEYS_ONLY
Default time to live: 0
Bloom Filter FP chance: 0.01
Index interval: default
Speculative Retry: 99.0PERCENTILE
Column Metadata:
Column Name: strategy_options
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: durable_writes
Validation Class: org.apache.cassandra.db.marshal.BooleanType
Column Name: strategy_class
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
Compression Options:
sstable_compression: org.apache.cassandra.io.compress.LZ4Compressor
WARNING: Could not connect to the JMX on 192.168.1.5:7199 - some information won't be shown.
Keyspace: system_traces:
Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
Durable Writes: true
Options: [replication_factor:2]
Column Families:
[default@unknown] use midonetflowstate;
Authenticated to keyspace: midonetflowstate
[default@midonetflowstate] show schema;
WARNING: CQL3 tables are intentionally omitted from 'show schema' output.
See https://issues.apache.org/jira/browse/CASSANDRA-4377 for details.
create keyspace midonetflowstate
with placement_strategy = 'SimpleStrategy'
and strategy_options = {replication_factor : 1}
and durable_writes = true;
use midonetflowstate;
[default@midonetflowstate] quit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment