Skip to content

Instantly share code, notes, and snippets.

@skaag
Created June 1, 2016 22:30
Show Gist options
  • Save skaag/d5186ae8c369003f52708ad95482935b to your computer and use it in GitHub Desktop.
Save skaag/d5186ae8c369003f52708ad95482935b to your computer and use it in GitHub Desktop.
CREATE KEYSPACE bids WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
CREATE TABLE bids.bid_data (url varchar primary key, impressions bigint, bid_request_count bigint, response_200 bigint, response_204 bigint, bid_rate double, win_rate double, avergae_encounter_rate double);
CREATE INDEX ON bids.bid_data(impressions);
CREATE INDEX ON bids.bid_data(bid_request_count);
CREATE INDEX ON bids.bid_data(response_200);
CREATE INDEX ON bids.bid_data(response_204);
CREATE INDEX ON bids.bid_data(bid_rate);
CREATE INDEX ON bids.bid_data(win_rate);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment