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 2022/05/20 01:50:30 UTC

[GitHub] [iotdb] a1135656335 opened a new issue, #5964: Duplicate data point aggregation(重复数据点聚合查询)

a1135656335 opened a new issue, #5964:
URL: https://github.com/apache/iotdb/issues/5964

   ![image](https://user-images.githubusercontent.com/34510920/169432223-32ebc1da-2a23-4950-8d37-8453ed5e7925.png)
   
   insert data:
   insert into root.open.api.wf02.1123(timestamp,success,fail) aligned  values(1,10,10);
   insert into root.open.api.wf02.1123(timestamp,success,fail) aligned  values(1,11,11);
   insert into root.open.api.wf02.1123(timestamp,success,fail) aligned  values(2,11,11);
   insert into root.open.api.wf02.1123(timestamp,success,fail) aligned  values(3,11,11);
   
   select:
   IoTDB> select SUM(success),SUM(fail) from root.open.api.** align by device;
   +-----------------------+------------+---------+
   |                 Device|SUM(success)|SUM(fail)      |
   +-----------------------+------------+---------+
   |root.open.api.wf02.1123|        43.0  |     43.0   |
   +-----------------------+------------+---------+
   Total line number = 2
   It costs 0.005s
   
   if duplicate data point is update,  result should be 33.0.


-- 
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.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [iotdb] a1135656335 commented on issue #5964: Duplicate data point aggregation(重复数据点聚合查询)

Posted by GitBox <gi...@apache.org>.
a1135656335 commented on issue #5964:
URL: https://github.com/apache/iotdb/issues/5964#issuecomment-1135264923

   closed


-- 
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 #5964: Duplicate data point aggregation(重复数据点聚合查询)

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #5964:
URL: https://github.com/apache/iotdb/issues/5964#issuecomment-1132364141

   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


[GitHub] [iotdb] a1135656335 closed issue #5964: Duplicate data point aggregation(重复数据点聚合查询)

Posted by GitBox <gi...@apache.org>.
a1135656335 closed issue #5964: Duplicate data point aggregation(重复数据点聚合查询)
URL: https://github.com/apache/iotdb/issues/5964


-- 
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] HTHou commented on issue #5964: Duplicate data point aggregation(重复数据点聚合查询)

Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #5964:
URL: https://github.com/apache/iotdb/issues/5964#issuecomment-1132692345

   Hi, the bug has been fixed now. You can download the latest snapshot version from https://github.com/SteveYurongSu/apache-iotdb-nightly-releases .


-- 
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