Skip to content

Instantly share code, notes, and snippets.

@chbatey
Created July 3, 2015 07:53
Show Gist options
  • Save chbatey/aedc95e61934ddd8cddd to your computer and use it in GitHub Desktop.
Save chbatey/aedc95e61934ddd8cddd to your computer and use it in GitHub Desktop.
CREATE TABLE daily_aggregate_temperature (
wsid text,
year int,
month int,
day int,
high double,
low double,
mean double,
variance double,
stdev double,
PRIMARY KEY ((wsid), year, month, day)
) WITH CLUSTERING ORDER BY (year DESC, month DESC, day DESC);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment