4paradigm / 4paradigm/OpenMLDB

long window: count where op with a rows bucket based pre-agg table may produce incorrect result

未关闭
#2,313 1 条评论 0 个 reaction 已指派 1 人 已被 @aceforeverd 认领 在 GitHub 查看
execute-engine storage-engine
主要语言
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

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。