Hi, I recently update influxdb to the last version and since, I have an error (no error with the previous version).
My request is :
SELECT 1-last(“nb_tot_gsm_message”)/last(“nb_tot_message”) FROM “nb_gsm_message”, “nb_message”
I use grafana to visualize the result, and I have this message : Multiple Series Error
I suppose in the new version the is a trick with the divider.
Thanks.
David
@davidL I think the issue is that you are trying to select from multiple measurements. That is not supported in InfluxDB. What version are you running?
But FROM “nb_gsm_message”, “nb_message” is supposed to work for multiple measurements, isn’t it ?
I use the last version of influxdb v1.2, on v0.13 it was working.
@davidL I did not know that behavior was allowed! I’ve gone ahead and tested on both versions and it appears that this behavior is still in 1.2.4
.
0.13.0
> insert foo v1=1,v2=2
> insert bar v1=1,v2=2
> select 1 - last(v1)/last(v2) from foo,bar
name: bar
---------
time last_last
0 0.5
name: foo
---------
time last_last
0 0.5
1.2.4
> insert foo v1=1,v2=2
> insert bar v1=1,v2=2
> select 1 - last(v1)/last(v2) from foo,bar
name: bar
time last_last
---- ---------
0 0.5
name: foo
time last_last
---- ---------
0 0.5