ClickHouse / ClickHouse/ClickHouse
Clickhouse sequenceMatchEvents
Open
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
Assessment
This issue has not been assessed yet.