How to map ServerityNumber to ServerityText?

[Wudadada]

I have tried some configurations but it didn't work

 

full config

receivers:
  otlp:
    protocols:
      grpc:
        endpoint: 0.0.0.0:4317
      http:
        endpoint: 0.0.0.0:4318
  prometheus:
    config:
      scrape_configs:
        - job_name: 'otel-collector'
          scrape_interval: 5s
          static_configs:
            - targets: ['0.0.0.0:19100']

processors:
  batch:
    timeout: 5s
    send_batch_size: 100000
  attributes:
    actions:
      - key: SeverityText
        action: insert
        from_attribute: SeverityNumber
        value: |
          if (SeverityNumber == 1, "TRACE",
              if (SeverityNumber == 5, "DEBUG",
              if (SeverityNumber == 9, "INFO",
              if (SeverityNumber == 13, "WARN",
              if (SeverityNumber == 17, "ERROR",
              if (SeverityNumber == 21, "FATAL", "DEFAULT"))))))

exporters:
  clickhouse:
    endpoint: tcp://10.105.212.248:9000?dial_timeout=10s
    create_schema: true
    database: otel
    async_insert: true
    ttl: 72h
    compress: lz4
    timeout: 5s
    retry_on_failure:
      enabled: true
      initial_interval: 5s
      max_interval: 30s
      max_elapsed_time: 300s
    username: "default"
    password: "123"
    cluster_name: cluster_3S_1R
    table_engine:
      name: "ReplicatedMergeTree"

    logs_table_name: otel_logs

    traces_table_name: otel_traces

    metrics_tables:
      gauge: 
        name: "otel_metrics_gauge"
      sum: 
        name: "otel_metrics_sum"
      summary: 
        name: "otel_metrics_summary"
      histogram: 
        name: "otel_metrics_histogram"
      exponential_histogram: 
        name: "otel_metrics_exp_histogram"

service:
  pipelines:
    traces:
      receivers: [otlp]
      processors: [batch]
      exporters: [clickhouse]
    logs:
      receivers: [otlp]
      processors: [batch]
      exporters: [clickhouse]
    metrics:
      receivers: [otlp, prometheus]
      processors: [batch]
      exporters: [clickhouse]

  telemetry:
    logs:
      level: "debug"

[Wudadada]

it works with the follow config
processors:
batch:
timeout: 5s
send_batch_size: 100000
transform:
log_statements:

• context: log
  statements:
• set(severity_text, "INFO") where IsString(body) and IsMatch(body, "\tinfo\t")
• set(severity_text, "WARN") where IsString(body) and IsMatch(body, "\twarn\t")
• set(severity_text, "ERROR") where IsString(body) and IsMatch(body, "\terror\t")
• set(severity_text, "TRACE") where severity_number == 1
• set(severity_text, "DEBUG") where severity_number == 5
• set(severity_text, "INFO") where severity_number == 9
• set(severity_text, "WARN") where severity_number == 13
• set(severity_text, "ERROR") where severity_number == 17
• set(severity_text, "FATAL") where severity_number == 21
• set(severity_text, "TRACE") where resource.attributes["severity_number"] == "1"
• set(severity_text, "DEBUG") where resource.attributes["severity_number"] == "5"
• set(severity_text, "INFO") where resource.attributes["severity_number"] == "9"
• set(severity_text, "WARN") where resource.attributes["severity_number"] == "13"
• set(severity_text, "ERROR") where resource.attributes["severity_number"] == "17"
• set(severity_text, "FATAL") where resource.attributes["severity_number"] == "21"