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/01/29 08:25:57 UTC

[GitHub] [iotdb] haimeiguo opened a new issue #2600: Improve GROUP BY TIME when endtime - starttime < interval

haimeiguo opened a new issue #2600:
URL: https://github.com/apache/iotdb/issues/2600


   When use GROUP BY TIME if endtime - starttime < interval currently the row result is rounding down, showing 1 row less.
   
   now
   (endtime - starttime) / interval = 5.3 -> 5 rows, currently we will show 5 rows of result. it rounds down
   
   want 
   (endtime - starttime) / interval = 5.3 -> 6 rows, show 6 rows of result. it rounds up. 
   
   e.g., select avg(*) from root group by ( [now() -1h, now()), 7200s) will return 1 row


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

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