i am trying to execute below query in influxdb by reference of this document https://docs.influxdata.com/influxdb/v0.8/api/query_language/
select table1.value,table2.value from jmeter as table1 inner join jmeter as table2 where table1.metric = 'avg' and table2.metric = 'pct90' and time > now() - 10m ; Server returned error: error parsing query: found AS, expected ; at line 1, char 46 Please correct me if my query is wrong. Regards, Venkat On Thursday, March 30, 2017 at 7:46:01 PM UTC-4, [email protected] wrote: > > I have stubbled across this: > https://docs.influxdata.com/influxdb/v0.8/api/query_language/ which has > two sections that might be helpful - Merging Series and Joining Series > > > > On Thursday, March 23, 2017 at 11:24:45 AM UTC-7, surendra matta wrote: > > Hi , > > > > > > Please let me know how to write joins in influxdb > > > > > > My req :- i have two columns name metric and value > > > > > > in metric i have the values avg and 90 % which is constant and in value > i have the values related to avg & 90% but i want to display Avg and 90 % > in a same row instead of separate row in grafana > > > > > > regards, > > Venkat > > -- 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/bed1a9ec-9d1d-4a84-b010-64bc666b6293%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
