1. Keyspaces are similar to schemas/databases.
Here is an example of how to create a keyspace.
create keyspace endpoint_scripts
with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy'
and strategy_options=[{eu-west:3, us-east:3}];
2. Column families are similar to tables.
create column family scripts
with comparator = 'UTF8Type'
and key_validation_class = 'UTF8Type'
and default_validation_class = 'BytesType'
and column_metadata=[
{column_name: uri, validation_class: UTF8Type, index_type: 0},
{column_name: revision, validation_class: LongType, index_type: 0},
{column_name: active, validation_class: BooleanType, index_type: 0},
{column_name: user_authentication_required, validation_class: BooleanType, index_type: 0},
{column_name: creation_date, validation_class: DateType, index_type: 0}
]
and rows_cached = 10000
and row_cache_provider = SerializingCacheProvider
and keys_cached = 1.0
and memtable_flush_after = 120
and memtable_operations = 2
and memtable_throughput = 256
and read_repair_chance = 0.0;