Skip to content

Instantly share code, notes, and snippets.

@tom-clickhouse
Last active August 17, 2023 12:16
Show Gist options
  • Save tom-clickhouse/7c88c3a231c602b44382f2ffdf98148c to your computer and use it in GitHub Desktop.
Save tom-clickhouse/7c88c3a231c602b44382f2ffdf98148c to your computer and use it in GitHub Desktop.
CREATE TABLE wikistat
(
time DateTime CODEC(Delta, ZSTD(3)),
project LowCardinality(String),
subproject LowCardinality(String),
path String CODEC(ZSTD(3)),
hits UInt64 CODEC(ZSTD(3))
)
ORDER BY (path, time);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment