Skip to content

Instantly share code, notes, and snippets.

@umurgdk
Created July 28, 2016 11:24
Show Gist options
  • Select an option

  • Save umurgdk/8504cb3f241dd7c1921a588b16ad66e4 to your computer and use it in GitHub Desktop.

Select an option

Save umurgdk/8504cb3f241dd7c1921a588b16ad66e4 to your computer and use it in GitHub Desktop.
CREATE TABLE "Measures" (
key text,
created_at timestamp,
updated_at timestamp,
version = timestamp,
start_date text,
end_date text,
unit text,
target varint,
target_type text,
target_delta varint,
target_delta_is_percent boolean,
baseline_type text,
baseline varint,
metric text,
metric_with_metadata text,
comparison text,
metadata text,
target_tolerance varint,
PRIMARY KEY ((key))
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.010000 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=0.100000 AND
replicate_on_write='true' AND
populate_io_cache_on_flush='false' AND
default_time_to_live=0 AND
speculative_retry='99.0PERCENTILE' AND
memtable_flush_period_in_ms=0 AND
compaction={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
@msimav
Copy link

msimav commented Jul 28, 2016

CREATE TABLE "Measures" (
  key text,
  created_at timestamp,
  end_date text,
  metric text,
  metric_with_metadata text,
  unit text,
  target text,
  target_type text,
  target_delta text,
  target_delta_is_percent boolean,
  target_tolerance text,
  baseline text,
  baseline_type text,
  comparison text,
  metadata text,
  start_date text,
  status text,
  updated_at timestamp,
  version timestamp,
  PRIMARY KEY ((key))
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.010000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  index_interval=128 AND
  read_repair_chance=0.100000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'class': 'SizeTieredCompactionStrategy'} AND
  compression={'sstable_compression': 'SnappyCompressor'};

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment