Skip to content

Instantly share code, notes, and snippets.

@arodrime
Created March 12, 2014 16:39
Show Gist options
  • Save arodrime/9510920 to your computer and use it in GitHub Desktop.
Save arodrime/9510920 to your computer and use it in GitHub Desktop.
DROP TABLE stats_teads;
CREATE TABLE stats_teads (
dim text,
dimId text,
level text,
event text,
date text,
value int,
PRIMARY KEY ((dim, dimId, level, event), date)
) WITH
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.100000 AND
read_repair_chance=0.000000 AND
compaction={'class': 'LeveledCompactionStrategy'} AND
compression={'sstable_compression': ''};
@arodrime
Copy link
Author

CREATE TABLE stats_teads (
date text,
level text,
dim text,
dimId text,
event text,
value int,
PRIMARY KEY ((date,level), dim, dimId, event)
)

@thobbs
Copy link

thobbs commented Mar 12, 2014

CREATE TABLE stats_teads (
dim text,
dimId text,
level text,
event text,
month text,
date text,
value int,
PRIMARY KEY ((dim, dimId, level, event, month), date)
)

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