Skip to content

Instantly share code, notes, and snippets.

@tom-clickhouse

tom-clickhouse/wikistat.sql Secret

Last active August 17, 2023 12:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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.
Download ZIP
Raw
wikistat.sql
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