On Monday, March 19, 2018 at 6:02:38 AM UTC-5, [email protected] wrote: > On Tuesday, August 23, 2016 at 9:12:21 AM UTC+5:30, [email protected] > wrote: > > Is it possible to perform GROUP BY aggregation across multiple > > measurements, such that they can be selected into a new single measurement? > > > > For example, I'd like to do something like: > > > > SELECT COUNT(value) as h_count, SUM(value) as h_sum, MIN(value) as h_min, > > MAX(value) as h_max INTO hourly FROM /rawdata.*/ GROUP BY time(1h), tag1, > > tag2 > > > > The result I'm seeing when I try this leads me to believe the aggregate > > function isn't being applied across all the matched measurements -- just > > within each. Is there a way to aggregate across all of them with InfluxQL? > > If so, how? > > > > If not, I can probably work around this with a different schema, but it > > seems like it'd be a useful thing to be able to do. > > > > Thanks, > > Casey > > HI casey, > > Were you able to perform aggregation with multiple measurements . Which one > did you choose ?. Even i want to achieve similar kind of challenge.
I ended up going with PostgreSQL for this particular application, it was a better fit for my use case. > > > Thanks, > Tejesh S -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/88998c4c-57db-4be1-86cc-54d01f1660e8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
