Log Architecture & Structural Overview

The ClickHouse Server Columnar DB Log Parser is an essential telemetry stream within the Databases & Key-Value Stores ecosystem. Parse ClickHouse server logs. Audit background merge operations, parts mutations, and query threads.

This schema defines a structure of 9 extracted attributes, including 1 numeric metrics and 8 string dimensions. In production observability architectures, these tokens provide high-cardinality indexing keys for telemetry pipelines before shipping to storage backends such as ClickHouse, Elasticsearch, Amazon S3, or Datadog.

Raw Telemetry Ingestion Profile

A typical raw event line for clickhouse-server-log averages 175 bytes across 9 tokens. Modern collectors such as Fluent Bit and Vector require zero-backtracking regular expressions to avoid CPU spikes during traffic surges.

Extracted Field Schema & Data Types

The transpiled Grok pattern extracts the following schema fields from each raw event line. Data collectors cast these values according to the typed mappings below.

Field Name	Inferred Type	Description & Collector Semantics
year	string	Year of log.
month	string	Month of log.
day	string	Day of log.
time	string	Time of log.
thread_id	integer	Internal execution thread ID.
query_id	string	Distributed query UUID identifier or empty.
level	string	Severity level (<Information>, <Warning>, <Error>).
component	string	ClickHouse internal component.
message	string	Execution message.

Common Regex Traps & Production Edge Cases

Engineers frequently encounter ingestion failures or pipeline drops due to subtle variations in real-world event logs. Watch out for these verified pitfalls:

1ClickHouse formats dates with periods (YYYY.MM.DD).

2Background worker tasks (like merges) have an empty query_id '{ }'.

Production Collector Setup & Configurations

Pre-configured parser definitions ready to be dropped into your infrastructure repository.

Fluent Bit (parsers.conf)

Format: regex

# ==============================================================================
# Fluent Bit Parser Configuration (parsers.conf)
# ==============================================================================
[PARSER]
    Name        logpipeline_parser
    Format      regex
    Regex       ^(?<year>\b[0-9]{4}\b)\.(?<month>(?:0?[1-9]|1[0-2]))\.(?<day>(?:(?:0[1-9])|(?:[12][0-9])|(?:3[01])|[1-9])) (?<time>(?:(?:(?:2[0123]|[01]?[0-9])):(?:(?:[0-5][0-9]))(?::(?:(?:(?:[0-5]?[0-9]|60)(?:[:.,][0-9]+)?))))) \[ (?<thread_id>(?:[+-]?(?:[0-9]+))) \] \{(?: (?<query_id>\S+))? \} <(?<level>\b\w+\b)> (?<component>\S+): (?<message>.*)$
    Time_Key    time
    Time_Format %Y-%m-%dT%H:%M:%S%z
    Types       thread_id:integer

# ==============================================================================
# Fluent Bit Pipeline Filter (fluent-bit.conf)
# ==============================================================================
[FILTER]
    Name         parser
    Match        *
    Key_Name     log
    Parser       logpipeline_parser
    Reserve_Data On

Vector.dev (Remap VRL)

parse_regex!

# ==============================================================================
# Vector.dev Remap Language (VRL) Transform
# Use inside a 'remap' transform in vector.yaml
# ==============================================================================
.parsed, err = parse_regex(.message, r'^(?<year>\b[0-9]{4}\b)\.(?<month>(?:0?[1-9]|1[0-2]))\.(?<day>(?:(?:0[1-9])|(?:[12][0-9])|(?:3[01])|[1-9])) (?<time>(?:(?:(?:2[0123]|[01]?[0-9])):(?:(?:[0-5][0-9]))(?::(?:(?:(?:[0-5]?[0-9]|60)(?:[:.,][0-9]+)?))))) \[ (?<thread_id>(?:[+-]?(?:[0-9]+))) \] \{(?: (?<query_id>\S+))? \} <(?<level>\b\w+\b)> (?<component>\S+): (?<message>.*)$')

if err == null {
    . = merge(., .parsed)
    del(.parsed)

    # Type coercions
    .thread_id = to_int!(.thread_id)

} else {
    log("LogPipeline parsing warning: " + err, level: "warn")
}

# ==============================================================================
# vector.yaml Pipeline Component
# ==============================================================================
transforms:
  parse_logs:
    type: remap
    inputs: ["source_logs"]
    source: |
      .parsed, err = parse_regex(.message, r'^(?<year>\b[0-9]{4}\b)\.(?<month>(?:0?[1-9]|1[0-2]))\.(?<day>(?:(?:0[1-9])|(?:[12][0-9])|(?:3[01])|[1-9])) (?<time>(?:(?:(?:2[0123]|[01]?[0-9])):(?:(?:[0-5][0-9]))(?::(?:(?:(?:[0-5]?[0-9]|60)(?:[:.,][0-9]+)?))))) \[ (?<thread_id>(?:[+-]?(?:[0-9]+))) \] \{(?: (?<query_id>\S+))? \} <(?<level>\b\w+\b)> (?<component>\S+): (?<message>.*)$')
      if err == null {
        . = merge(., .parsed)
        del(.parsed)
      }

Datadog Log Pipeline Grok Parser

match_rules

# ==============================================================================
# Datadog Log Processing Pipeline Grok Parser
# Navigate to: Logs -> Configuration -> Pipelines -> Add Processor -> Grok Parser
# ==============================================================================

# Match Rule:
rule %{YEAR:year}\.%{MONTHNUM:month}\.%{MONTHDAY:day} %{TIME:time} \[ %{INT:thread_id} \] \{(?: %{NOTSPACE:query_id})? \} <%{WORD:level}> %{NOTSPACE:component}: %{GREEDYDATA:message}

# Complete Datadog Pipeline Processor JSON:
{
  "type": "grok-parser",
  "name": "LogPipeline Grok Parser",
  "is_enabled": true,
  "source": "message",
  "samples": [],
  "grok": {
    "match_rules": "rule %{YEAR:year}\\.%{MONTHNUM:month}\\.%{MONTHDAY:day} %{TIME:time} \\[ %{INT:thread_id} \\] \\{(?: %{NOTSPACE:query_id})? \\} <%{WORD:level}> %{NOTSPACE:component}: %{GREEDYDATA:message}",
    "support_rules": ""
  }
}

# Target Fields Created:
# year (string), month (string), day (string), time (string), thread_id (integer), query_id (string), level (string), component (string), message (string)

OpenTelemetry Collector (transform processor)

regex_parser

# ==============================================================================
# OpenTelemetry Collector Configuration (otel-collector-config.yaml)
# Option 1: Filelog Receiver with regex_parser Operator
# ==============================================================================
receivers:
  filelog:
    include: [ /var/log/**/*.log ]
    start_at: beginning
    operators:
      - type: regex_parser
        id: logpipeline_regex_parser
        regex: '^(?<year>\b[0-9]{4}\b)\.(?<month>(?:0?[1-9]|1[0-2]))\.(?<day>(?:(?:0[1-9])|(?:[12][0-9])|(?:3[01])|[1-9])) (?<time>(?:(?:(?:2[0123]|[01]?[0-9])):(?:(?:[0-5][0-9]))(?::(?:(?:(?:[0-5]?[0-9]|60)(?:[:.,][0-9]+)?))))) \[ (?<thread_id>(?:[+-]?(?:[0-9]+))) \] \{(?: (?<query_id>\S+))? \} <(?<level>\b\w+\b)> (?<component>\S+): (?<message>.*)$'
        timestamp:
          parse_from: attributes.time
          layout: '%Y-%m-%dT%H:%M:%S%z'

# ==============================================================================
# Option 2: Transform Processor (OTel Transformation Language - OTTL)
# ==============================================================================
processors:
  transform:
    error_mode: ignore
    log_statements:
      - context: log
        statements:
          - merge_maps(attributes, extract_patterns(body, "^(?<year>\\b[0-9]{4}\\b)\\.(?<month>(?:0?[1-9]|1[0-2]))\\.(?<day>(?:(?:0[1-9])|(?:[12][0-9])|(?:3[01])|[1-9])) (?<time>(?:(?:(?:2[0123]|[01]?[0-9])):(?:(?:[0-5][0-9]))(?::(?:(?:(?:[0-5]?[0-9]|60)(?:[:.,][0-9]+)?))))) \\[ (?<thread_id>(?:[+-]?(?:[0-9]+))) \\] \\{(?: (?<query_id>\\S+))? \\} <(?<level>\\b\\w+\\b)> (?<component>\\S+): (?<message>.*)$"), "insert")

service:
  pipelines:
    logs:
      receivers: [filelog]
      processors: [transform]
      exporters: [otlp]

Logstash Filter Configuration

filter.grok

# ==============================================================================
# Logstash Pipeline Configuration (/etc/logstash/conf.d/logpipeline.conf)
# ==============================================================================
filter {
  grok {
    match => { "message" => "%{YEAR:year}\.%{MONTHNUM:month}\.%{MONTHDAY:day} %{TIME:time} \[ %{INT:thread_id:integer} \] \{(?: %{NOTSPACE:query_id})? \} <%{WORD:level}> %{NOTSPACE:component}: %{GREEDYDATA:message}" }
    tag_on_failure => [ "_grokparsefailure" ]
  }

  date {
    match => [ "time", "ISO8601", "dd/MMM/yyyy:HH:mm:ss Z" ]
    target => "@timestamp"
    remove_field => [ "time" ]
  }
}