ClickHouse / ClickHouse/ClickHouse

Clickhouse sequenceMatchEvents

Open
#82,190 1 comment 0 reactions 0 assignees View on GitHub
comp-aggregate-functions external question
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

### Company or project name

How can the clickhouse sequenceMatchEvents function add a time limit to the overall condition?

### Question

For example, sequenceMatchEvents('(?1).*(?2).*(?3)') I want to impose a 3600s limit on the entire range of 1 to 3. After consulting the official documentation, I found that we can use (?t operator value). For instance, '(?1)' t < 1800).*(? 2).*(?3)', In this case, it indicates that the time range from 1 to 2 is 3600 seconds, rather than the time range from 1 to 3 being 3600 seconds. Could you please tell me what I should do?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.