Correct, there is no way to specify multiple WHERE clause conditions in the same query. InfluxDB does not support sub-queries or JOINs, so you must use CQs or Kapacitor to perform operations between two different series.
On Thu, Aug 25, 2016 at 5:45 AM, wug <[email protected]> wrote: > Hello, > > Thank you for the answer. CQ works perfectly. I am using 0.13 version for > your information, I forgot to specify in my first message. > > If I understood your explanation, I cannot do the follow: > > I have a database with just one measurement. For this measurement , I have > just one field with the field key = value. But I have a lot of different > tag keys. I wanted to do some operations between two series with 2 > different tags value, but the same field. for example a series with one tag > minus a series with an other tag for the same measurement and the same > field. > > I cannot do that without using CQ or Kapacitor? Is it correct? Is it > scheduled to add this feature in a future version? > > Thank you > > wug > > Le mercredi 24 août 2016 17:10:08 UTC+2, Sean Beckett a écrit : >> >> Since you have two mutually exclusive WHERE clauses, you cannot >> accomplish your goal with one query. InfluxDB does not yet support a HAVING >> clause or subqueries. >> >> However, this should be doable with continuous queries, unless I'm >> missing something. >> >> CREATE CQ... >> select 4*mean("value") AS mean_real INTO "puissance.electricite" from >> "puissance.electricite" where station =~ /fmv.hydro.*/ and "typeof" = >> 'real' group by time(15m) >> END >> >> CREATE CQ... >> select sum("value") AS sum_forecast INTO "puissance.electricite" from >> "puissance.electricite" where station =~ /fmv.hydro.*/ and "typeof" = >> 'forecast' group by time(15m) >> END >> >> Then for your difference query: >> >> SELECT mean_real - sum_forecast FROM "puissance.electricite" WHERE time >> > now() - 2w group by time(15m) >> >> >> On Wed, Aug 24, 2016 at 5:48 AM, wug <[email protected]> wrote: >> >>> Hello, >>> >>> I am completely new with InfluxDB. I have a database with one >>> measurement which has a tag key = station with 4 tag values and a tag key >>> = typeof with two tag values: real and forecast. I have values with a >>> period of 1 minute for the tag value real and values with a period of 15 >>> minute for the tag value forecast. >>> >>> The goal is: >>> - First to get series which is the sum on the 4 stations of the values >>> at one timestamp. >>> - Then for the tag value real do the average on 15 minutes to get 15 >>> minutes values. >>> - Finally do the difference between tag with real and tag with forecast. >>> >>> Can I do this in one query? If not what is the way to perform that in >>> InfluxDB. >>> >>> >>> I did the first 2 steps like that: >>> >>> for the real tag: >>> >>> select 4*mean("value") from "puissance.electricite" where station =~ >>> /fmv.hydro.*/ and "typeof" = 'real' and time < now() and time > now() - 2w >>> group by time(15m) >>> >>> >>> >>> for the forecast tag: >>> >>> select sum("value") from "puissance.electricite" where station =~ >>> /fmv.hydro.*/ and "typeof" = 'forecast' and time < now() and time > now() - >>> 2w group by time(15m) >>> >>> >>> >>> And I want to do the difference of this 2 queries. >>> >>> >>> I know that kapacitor or continues queries can do these kind of things. >>> I tried without success. >>> >>> >>> >>> Thank you for your help, >>> >>> >>> wug >>> >>> >>> >>> -- >>> 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/ms >>> gid/influxdb/d3649745-e6f0-4c77-a4c9-8732bbc2e492%40googlegroups.com >>> <https://groups.google.com/d/msgid/influxdb/d3649745-e6f0-4c77-a4c9-8732bbc2e492%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> 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/884940cc-0a61-4955-bf0b-7090faacf965%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/884940cc-0a61-4955-bf0b-7090faacf965%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > 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/CALGqCvM%3D4PGTwfCV18%3DinSOJNR7uBCa1F9sSV-yHunK2DujyZw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
