Short answer, you cannot merge or join across measurements in InfluxDB 0.9+. All series in a measurement are automatically merged, but your schema has one series per measurement, so it is significantly sub-optimal for queries.
The behavior changed with InfluxDB 0.9. The 0.8 schema no longer work. Please see https://docs.influxdata.com/influxdb/v0.9/concepts/08_vs_09/#joins for more. On Fri, Jul 22, 2016 at 1:18 PM, <[email protected]> wrote: > пятница, 2 мая 2014 г., 23:44:02 UTC+2 пользователь [email protected] > написал: > > After running a query such as this... > > > > select sum(value) from /.*total_delivered.*/; > > > > ...I would hope to get a single summed value across all series. Instead > I get a summed value of all the data points in each series individually. > > > > Any way to get a sum across multiple series? > > Did you find how to do it for influxdb 0.9+ ? > I ran: > select sum(value) from /network\..*.sFlow\.(syn|udp)_pktsIn/; > > And get: > name: network.1.sFlow.udp_pktsIn > -------------------------------------------- > time sum > 0 10 > > > name: network.2.sFlow.syn_pktsIn > -------------------------------------------- > time sum > 0 10 > > But I wanted to get something like > name: network.*.sFlow.syn_pktsIn > -------------------------------------------- > time sum > 0 20 > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" 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/fd1f9d6b-e3ea-46b3-9797-46691ad43127%40googlegroups.com > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/CALGqCvOACmNpvfkDj4MhELR0kxs0NAk6OdU45sCAZobHSazLOA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
