You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/10/25 04:01:41 UTC
[GitHub] [iotdb] CRZbulabula opened a new issue #4224: IoTDB doesn't distinguish between zero and null values in sum aggregation
CRZbulabula opened a new issue #4224:
URL: https://github.com/apache/iotdb/issues/4224
In IoTDB, the aggregate result of sum is like:
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:
<img width="399" alt="mysql" src="https://user-images.githubusercontent.com/33111881/138632605-60aa4f28-d655-4695-a703-4b936efcbb67.png">
I wonder if IoTDB can similarly distinguish between zero values and null values in the aggregate result of sum
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] JackieTien97 commented on issue #4224: IoTDB doesn't distinguish between zero and null values in sum aggregation
Posted by GitBox <gi...@apache.org>.
JackieTien97 commented on issue #4224:
URL: https://github.com/apache/iotdb/issues/4224#issuecomment-950547595
Yes, maybe only the `count` operator should return zero instead of `null` while aggregating.This is not considered in the implementation of the previous aggregation query. We'll fix it in the next version, or if you could try to submit a PR for this, we'll appreciate that.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] github-actions[bot] commented on issue #4224: IoTDB doesn't distinguish between zero and null values in sum aggregation
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #4224:
URL: https://github.com/apache/iotdb/issues/4224#issuecomment-950505113
Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org