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/05/11 10:42:16 UTC

[GitHub] [iotdb] mzp0514 commented on issue #3058: Wrong result when applying aggregation function on series with * and where clause

mzp0514 commented on issue #3058:
URL: https://github.com/apache/iotdb/issues/3058#issuecomment-838249969


   > It's not a bug i think.
   > `select temperature from root.ln.*.* where temperature > 50` means
   > select `root.ln.*.*.temperature` ... where `root.ln.*.*.temperature` > 50.
   > 
   > Therefore, root.ln.wf01.wt01.temperature, root.ln.wf01.wt02.temperature, root.ln.wf02.wt01.temperature, root.ln.wf02.wt02.temperature will be considered at the same time.
   > 
   > If you want to take just root.ln.wf02.wt02 as filter, write sql like this:
   > `select temperature from root.ln.*.* where root.ln.wf02.wt02.temperature > 50`
   
   I see... It seems that there is not an approach to selecting the count of data points whose value > 50 of **each** timeseries **respectively** in **one** sql?


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