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

[GitBox <gi...@apache.org>]

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


   I think we need to discuss which semantic is more general, "and" or
   "respectively"?
   (seems "respectively" is more suitable if we compare with other TSDBs).
   
   mzp0514 ***@***.***> 于2021年5月11日周二 下午6:42写道：
   
   > 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?
   >
   > —
   > You are receiving this because you are subscribed to this thread.
   > Reply to this email directly, view it on GitHub
   > <https://github.com/apache/iotdb/issues/3058#issuecomment-838249969>, or
   > unsubscribe
   > <https://github.com/notifications/unsubscribe-auth/AAHZOVXOFUHSRWNT33SBTILTNECZZANCNFSM43QGD3HA>
   > .
   >
   


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