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/03 00:35:37 UTC

[GitHub] [iotdb] tn987 opened a new issue, #5773: 聚合查询丢失记录，版本13.0.

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

   IoTDB> select count(Ua)  from root.tjwy.A group by  ([2022-05-01T00:00:00, 2022-05-01T21:00:00),1h)
   +-----------------------------+---------------------+
   |                         Time|count(root.tjwy.A.Ua)|
   +-----------------------------+---------------------+
   |2022-05-01T00:00:00.000+08:00|                   60|
   |2022-05-01T01:00:00.000+08:00|                   60|
   |2022-05-01T02:00:00.000+08:00|                   60|
   |2022-05-01T03:00:00.000+08:00|                   60|
   |2022-05-01T04:00:00.000+08:00|                   60|
   |2022-05-01T05:00:00.000+08:00|                   60|
   |2022-05-01T06:00:00.000+08:00|                   60|
   |2022-05-01T07:00:00.000+08:00|                   60|
   |2022-05-01T08:00:00.000+08:00|                   60|
   |2022-05-01T09:00:00.000+08:00|                   60|
   |2022-05-01T10:00:00.000+08:00|                   60|
   |2022-05-01T11:00:00.000+08:00|                   60|
   |2022-05-01T12:00:00.000+08:00|                   60|
   |2022-05-01T13:00:00.000+08:00|                   60|
   |2022-05-01T14:00:00.000+08:00|                   60|
   |2022-05-01T15:00:00.000+08:00|                   60|
   |2022-05-01T16:00:00.000+08:00|                   60|
   |2022-05-01T17:00:00.000+08:00|                   60|
   ```
   **|2022-05-01T18:00:00.000+08:00|                    0|
   |2022-05-01T19:00:00.000+08:00|                    0|
   |2022-05-01T20:00:00.000+08:00|                    0|**
   ```
   +-----------------------------+---------------------+
   Total line number = 21
   It costs 0.019s
   IoTDB> select count(Ua)  from root.tjwy.A group by  ([2022-05-01T17:00:00, 2022-05-01T21:00:00),1h)
   +-----------------------------+---------------------+
   |                         Tim
   [data.zip](https://github.com/apache/iotdb/files/8606713/data.zip)
   e|count(root.tjwy.A.Ua)|
   +-----------------------------+---------------------+
   **|2022-05-01T17:00:00.000+08:00|                   60|
   ```
   |2022-05-01T18:00:00.000+08:00|                   60|
   |2022-05-01T19:00:00.000+08:00|                   60|
   |2022-05-01T20:00:00.000+08:00|                   60|**
   +-----------------------------+---------------------+
   ```
   
   
   Total line number = 4
   It costs 0.007s
   IoTDB>
   
   样本数据：[data.zip](https://github.com/apache/iotdb/files/8606715/data.zip)


-- 
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] tn987 commented on issue #5773: 聚合查询丢失记录，版本13.0.

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

   ![QQ图片20220503083623](https://user-images.githubusercontent.com/30252478/166365264-a60b005f-ff83-44f1-a875-fcddf65f670b.png)
   


-- 
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 closed issue #5773: 聚合查询丢失记录，版本13.0.

Posted by GitBox <gi...@apache.org>.
JackieTien97 closed issue #5773: 聚合查询丢失记录，版本13.0.
URL: https://github.com/apache/iotdb/issues/5773


-- 
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 #5773: 聚合查询丢失记录，版本13.0.

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

   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] SteveYurongSu commented on issue #5773: 聚合查询丢失记录，版本13.0.

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

   Thanks for reporting this!!  @tn987 
   
   @JackieTien97 @Alima777 PTAL


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