notice that is version 0.8 documentation
Frank Inselbuch Unix Edge, Inc. [email protected] 713-701-5421 (primary) 713-240-6700 (cellular) https://zoom.us/j/7137015421 (telecon) From: <[email protected]<mailto:[email protected]>> on behalf of surendra matta <[email protected]<mailto:[email protected]>> Reply-To: <[email protected]<mailto:[email protected]>> Date: Friday, March 31, 2017 at 9:45 AM To: InfluxData <[email protected]<mailto:[email protected]>> Cc: <[email protected]<mailto:[email protected]>> Subject: [influxdb] Re: how to write joins 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]<mailto:[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 a topic in the Google Groups "InfluxData" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/influxdb/SH_0Ph1gpP4/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[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<https://groups.google.com/d/msgid/influxdb/bed1a9ec-9d1d-4a84-b010-64bc666b6293%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- 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/D503DF4A.40FB%25inselbuch%40unixedge.com. For more options, visit https://groups.google.com/d/optout.
