[influxdb] how to write joins

[surendra matta]

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

[Frank Inselbuch]

Not clear what you are trying to do.
But joins are not currently supported AFAIK.

Post by surendra matta
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

[a.sanchez.stephens via InfluxData]

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

Post by surendra matta
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

[surendra matta]

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,

Post by a.sanchez.stephens via InfluxData
https://docs.influxdata.com/influxdb/v0.8/api/query_language/ which has
two sections that might be helpful - Merging Series and Joining Series

Post by surendra matta
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

Post by surendra matta
regards,
Venkat

[Frank Inselbuch]

notice that is version 0.8 documentation




Frank Inselbuch
Unix Edge, Inc.
***@unixedge.com
713-701-5421 (primary)
713-240-6700 (cellular)
https://zoom.us/j/7137015421 (telecon)

From: <***@googlegroups.com<mailto:***@googlegroups.com>> on behalf of surendra matta <***@gmail.com<mailto:***@gmail.com>>
Reply-To: <***@googlegroups.com<mailto:***@googlegroups.com>>
Date: Friday, March 31, 2017 at 9:45 AM
To: InfluxData <***@googlegroups.com<mailto:***@googlegroups.com>>
Cc: <***@googlemail.com<mailto:***@googlemail.com>>
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, ***@googlemail.com<mailto:***@googlemail.com> 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

Post by surendra matta
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 influxdb+***@googlegroups.com<mailto:influxdb+***@googlegroups.com>.
To post to this group, send email to ***@googlegroups.com<mailto:***@googlegroups.com>.
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.

[Fulvio Spelta]

Join is no more supported:
https://docs.influxdata.com/influxdb/v0.10/concepts/08_vs_010/
<https://docs.influxdata.com/influxdb/v0.10/concepts/08_vs_010/>

[Frank Inselbuch]

Would love to see an example of that Jack.




Frank Inselbuch
Unix Edge, Inc.
***@unixedge.com
713-701-5421 (primary)
713-240-6700 (cellular)
https://zoom.us/j/7137015421 (telecon)

From: Jack Zampolin <***@influxdb.com<mailto:***@influxdb.com>>
Date: Wednesday, April 5, 2017 at 3:07 PM
To: InfluxData <***@googlegroups.com<mailto:***@googlegroups.com>>
Cc: Frank Inselbuch <***@unixedge.com<mailto:***@unixedge.com>>
Subject: Re: [influxdb] Re: how to write joins

This is true, however many of those usecases can be covered by having measurements with many fields and doing math across them. This line protocol documentation<https://docs.influxdata.com/influxdb/v1.2/write_protocols/line_protocol_tutorial/> should help.

In the future please ask questions like this over on our community site<https://community.influxdata.com>.

On Wednesday, April 5, 2017 at 7:32:08 AM UTC-7, Fulvio Spelta wrote:
Join is no more supported: https://docs.influxdata.com/influxdb/v0.10/concepts/08_vs_010/<https://docs.influxdata.com/influxdb/v0.10/concepts/08_vs_010/>