[influxdb] multiple where clauses

[Catalin Petrescu]

Hi all,

I have a requirement to get the max data of
non_negative_derivative(max(ifHCOutOctets) from a series of multiple
interfaces.


I'm trying to run this query :

SELECT non_negative_derivative(max(ifHCOutOctets), 1s) *8 from
interface_statistics where (hostname =~ /RTR_A/ and ifIndex = '49' AND
hostname =~ /RTR_B/ and ifIndex = '65') AND time >= now()- 12h group by
time(5m) fill(0)

Getting empty results.

with individual ones , eg:

SELECT non_negative_derivative(max(ifHCOutOctets), 1s) *8 from
interface_statistics where (hostname =~ /RTR_A/ and ifIndex = '49') AND
time >= now()- 12h group by time(5m) fill(0)

i get proper results , but the goal is to get the maximum value from both
router/interface pairs per interval.

Any way i can achieve that using a query.

Regards,