Select from influxDB value null

Store
, ,
1

Hello,

Influxdb version: 1.7.6

I have a problem to request (select) values called “null”.

I have a 1st script (launched once a day) that updates 2 field (host, value_op) for LOSS measurement.

Then, I have a 2nd script launched every 5 minutes, which updates the field “value”.

So, for data, I sometimes have empty values for some tag.

I would like to recover only the non-zero values of “value”.

SELECT value,value_op FROM LOSS WHERE (host =~ /^toto/);
name: LOSS
time value value_op

1574258100000000000 1
1574258400000000000 1
1574258700000000000 1
1574259000000000000 1
1574259300000000000 1
1574259600000000000 1
1574259900000000000 1
1574260200000000000 1
1574260500000000000 1
1574260800000000000 1
1574261100000000000 1
1574261400000000000 1
1574261700000000000 1
1574262000000000000 1
1574262300000000000 1
1574262600000000000 1
1574262900000000000 0 1
1574263200000000000 0 1
1574263500000000000 0 1
1574263800000000000 0 1
1574264100000000000 0 1
1574264400000000000 0 1
1574264700000000000 0 1
1574265000000000000 0 1
1574265300000000000 0 1
1574265600000000000 0 1
1574265900000000000 0 1
1574266200000000000 0 1
1574266500000000000 0 1
1574266800000000000 0 1
1574267100000000000 0 1
1574267400000000000 0 1
1574267700000000000 0 1
1574268000000000000 0 1

I would like to recover only the non-zero values of “value”.

SELECT value,value_op FROM LOSS WHERE (host =~ /^toto/ and value!=‘’);

SELECT value,value_op FROM LOSS WHERE (host =~ /^toto/ and value !~ /./);

I have no results.

Is it possible to ignore the null values in a select influxdb query?

Regards,

Chris.

2

Hello @chrisH,
Is this helpful to you? TL;DR InfluxDB Tech Tips - Eliminate Blank Field Values in Query Results & More! | InfluxData