interval(1h) fill(VALUE,0) 查询一段时间内没有任何数据时，返回结果为空，期望是按照时间切片返回结果
Open
@yu285 is already working on this.
Since Sep 26, 2025.
bug
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
SELECT sum(number_value) as number_value,_wstart as ts,device_id FROM super_device_property WHERE device_id in (9) AND property = '100' AND ts between now - 6h and now partition by device_id INTERVAL(1h) FILL(VALUE, 0)
sql result
SELECT sum(number_value) as number_value,_wstart as ts,device_id FROM super_device_property WHERE device_id in (9) AND property = '100' AND ts between now - 6h and now - 1h partition by device_id INTERVAL(1h) FILL(VALUE, 0)
大佬，问下这个要怎么解决呢？非常感谢
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.