JOINs are not supported in InfluxDB 0.9+. Your schema is not optimal for InfluxDB 0.9+. Metadata should be encoded in key-value pair tags, not in the measurement name. See https://docs.influxdata.com/influxdb/v0.9/concepts/08_vs_09 for more on that, and watch the schema webinar https://vimeo.com/169742452.
On Fri, Jul 1, 2016 at 3:39 AM, <[email protected]> wrote: > Hi, > > I am totally new in InfluxDb so I really need to know how could we perform > multi queries with InfluxDb if it datas were fetched by Graphique. > > In fact I am using Jmeter to do some load test and in my database, I have > 2 measurements with prefix like "jmeter.name_of_transaction.ok.count" and > "jmeter.name_of_transaction.ko.count". > > And we have throughput = number of request processed / total time. > > So by the way,in InfluxDb, I already have number of passed/failed request > and I do some group by time, I could get the throughtput value. > > But the problem is when I perform such query : select s1.value + s2.value > from "jmeter.TR01_01_RechercheGoogle.ok.count" as s1 inner join > "jmeter.TR01_01_RechercheGoogle.ko.count" as s2 group by time(1s); > > it always return this error : Server returned error: error parsing query: > found AS, expected ; at line 1, char 75 > > FYI, I am using InfluxDb 0.13. > > Any help would be appreciated. > > Regards. > > -- > 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/df54e661-0c01-49a3-a6e4-06082b7ac6a8%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/CALGqCvPk0EFz7D_o0rL%3DTPVgO-oQGeQLsRf8MacZYB%3DMNN%3DuxA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
