[default@pond_na1] show schema;
create keyspace pond_na1
  with placement_strategy = 'NetworkTopologyStrategy'
  and strategy_options = {na1-1 : 2, na4-1 : 1, na1-2 : 2}
  and durable_writes = true;

use pond_na1;

create column family hash_to_id
  with column_type = 'Standard'
  and comparator = 'UTF8Type'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType)'
  and rows_cached = 5000.0
  and row_cache_save_period = 0
  and row_cache_keys_to_save = 2147483647
  and keys_cached = 50000.0
  and key_cache_save_period = 14400
  and read_repair_chance = 0.1
  and gc_grace = 259200
  and min_compaction_threshold = 5
  and max_compaction_threshold = 31
  and replicate_on_write = true
  and row_cache_provider = 'SerializingCacheProvider'
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
  and column_metadata = [
    {column_name : 'parameterId',
    validation_class : LongType}];

create column family metric
  with column_type = 'Standard'
  and comparator = 'IntegerType'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType)'
  and rows_cached = 5.0
  and row_cache_save_period = 0
  and row_cache_keys_to_save = 2147483647
  and keys_cached = 10000.0
  and key_cache_save_period = 14400
  and read_repair_chance = 0.1
  and gc_grace = 259200
  and min_compaction_threshold = 5
  and max_compaction_threshold = 31
  and replicate_on_write = true
  and row_cache_provider = 'SerializingCacheProvider'
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy';

create column family metric_by_date
  with column_type = 'Standard'
  and comparator = 'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'LongType'
  and rows_cached = 1000.0
  and row_cache_save_period = 0
  and row_cache_keys_to_save = 2147483647
  and keys_cached = 10000.0
  and key_cache_save_period = 14400
  and read_repair_chance = 0.1
  and gc_grace = 259200
  and min_compaction_threshold = 5
  and max_compaction_threshold = 31
  and replicate_on_write = true
  and row_cache_provider = 'SerializingCacheProvider'
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy';

create column family metric_by_parameter
  with column_type = 'Standard'
  and comparator = 'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.LongType)'
  and default_validation_class = 'BytesType'
  and key_validation_class = 'LongType'
  and rows_cached = 1000.0
  and row_cache_save_period = 0
  and row_cache_keys_to_save = 2147483647
  and keys_cached = 10000.0
  and key_cache_save_period = 14400
  and read_repair_chance = 0.1
  and gc_grace = 259200
  and min_compaction_threshold = 5
  and max_compaction_threshold = 31
  and replicate_on_write = true
  and row_cache_provider = 'SerializingCacheProvider'
  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy';