Created
June 1, 2016 22:30
-
-
Save skaag/d5186ae8c369003f52708ad95482935b to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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