Skip to content

Instantly share code, notes, and snippets.

@wizardjedi

wizardjedi/query.sql

Created July 15, 2018 14:59
Show Gist options
  • Save wizardjedi/b4ec7a2ada50a4bcc5c95a7fb2838637 to your computer and use it in GitHub Desktop.
Save wizardjedi/b4ec7a2ada50a4bcc5c95a7fb2838637 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
CREATE TABLE metrics (
date datetime,
name varchar(250),
value double,
primary key(date, name),
date key(date)
) with partitioning(1s to 7day,1m to 30day,1h to 90day,1day to 2year,1month);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment