apache / apache/iotdb

IoTDB doesn't distinguish between zero and null values in sum aggregation

Open
#4,224 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
6.4k
Forks
1.2k
Avg merge
1d 23h
Merged PRs (30d)
115

Description

In IoTDB, the aggregate result of sum is like:

![iotdb](https://user-images.githubusercontent.com/33111881/138632492-fecf8ecb-2256-4d80-a1a3-309d2357405a.png)

You can see that both a 0 value and a null value result in 0, without distinction.

But in **MySQL**, the aggregate result of sum is like:

mysql

I wonder if IoTDB can similarly distinguish between zero values and null values in the aggregate result of sum

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the sum aggregation behavior described in the issue and compare results for zero and null values with MySQL's behavior. Trace IoTDB's sum aggregation implementation and its existing tests; done means zero and null produce distinguishable aggregate results consistent with the intended semantics.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.