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/08 03:56:07 UTC

[GitHub] [iotdb] jixuan1989 commented on issue #2395: What is the difference between the last_value operator and the last operator？

jixuan1989 commented on issue #2395:
URL: https://github.com/apache/iotdb/issues/2395#issuecomment-756530819


   - `last` is an individual statement, while `last_value` is an aggregation function. That means, you can use `last_value` attached with `group by` statement. 
   
   - if you have no filters (`where` clause, or just `where time > ?`), then use `last`, it is far faster than last_value.
   Otherwise, you have to use `last_value`.
   
   
   


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