4paradigm / 4paradigm/OpenMLDB
long window: count where op with a rows bucket based pre-agg table may produce incorrect result
- 主要语言
- C++
- 星标
- 1.7k
- 派生
- 331
- 平均合并
- 12 天 12 小时
- 30 天内合并 PR
- 1
描述
**Describe the feature you'd like**
```sql
deploy dp options (long_windows = 'w1:3')
select count_where(.....
```
`3` as a rows based bucket size, since there is a extra filter key for pre-agg table added, rows in pre-agg table, where their
ts_begin and ts_end value, are not aligned.
currently, this op (`*_where with rows bucket`) is turned off in #2255 -> compile time error
**Additional context**
Add any other context or screenshots about the feature request here.
贡献指南
调研方向
The issue mentions a pre-aggregation table with misaligned timestamps causing incorrect results for count_where operations with row-based buckets. Start by examining the code changes in #2255 that disabled this operation. Look for the long window implementation and pre-agg table handling, particularly around filter keys and bucket alignment. Running existing tests related to long windows and pre-agg tables will help understand the failure.
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql
- 领域
- databases, machine-learning
- Issue 类型
- 缺陷
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 停滞
- 描述清晰度
- 需要澄清
- 新手友好度
- 25/100