Skip to content

Instantly share code, notes, and snippets.

@chbatey
Created July 3, 2015 07:55
Show Gist options
  • Save chbatey/0d5c076c8c3d864cd51e to your computer and use it in GitHub Desktop.
Save chbatey/0d5c076c8c3d864cd51e to your computer and use it in GitHub Desktop.
CREATE TABLE daily_aggregate_precip (
wsid text,
year int,
month int,
day int,
precipitation counter,
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