clickhouse.bootstrap.sql

CREATE DATABASE IF NOT EXISTS `logs`;

SET allow_experimental_object_type=1;

CREATE TABLE IF NOT EXISTS logs.syslog (
  timestamp DateTime,
  facility LowCardinality(String),
  severity LowCardinality(String),
  hostname LowCardinality(String),
  program String,
  tag String,
  message String,
  data JSON
) ENGINE = MergeTree()
  PARTITION BY toYYYYMMDD(timestamp)
  ORDER BY (timestamp);

CREATE TABLE IF NOT EXISTS logs.http (
  timestamp DateTime,
  hostname LowCardinality(String),
  method LowCardinality(String),
  vhost String,
  uri String,
  status UInt16,
  bytes UInt64,
  referer String,
  user_agent String
) ENGINE = MergeTree()
  PARTITION BY toYYYYMMDD(timestamp)
  ORDER BY (timestamp);