createEmpty : true in aggregateWindow does not work for 'selector' functions

[mzakharocsc]

Steps to reproduce:

When performing queries with missing data, for example

from(bucket: "bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "measurement")
  |> filter(fn: (r) => r["_field"] == "field")
  |> aggregateWindow(every: v.windowPeriod, fn: max, createEmpty: true)

if fn parameter in aggregateWindow is part of aggregates things work as expected, however when using selectors, such as last, first, min, max, createEmpty: true does not have any effect

Expected behavior:
Returned datasets would include null in _value column for missing timestamps

Actual behavior:
Returned datasets do NOT include null in _value column for missing timestamps

Environment info:

• System info: Linux 4.15.0-135-generic x86_64
• InfluxDB version: 2.0.7

[ghost]

Having the same issue.

[tlifschitz]

Same problem over here. This prevents us from filling the null values and being able to join data to other irregular sampled series.

[tlifschitz]

Here it is stated that selector functions discard empty tables, not returning a null value by design. Which is the reason for doing this? In some cases it is useful to have the empty data points.

This should be a feature request instead of a bug? Can somebody clarify this? Thank you!@alexpaxton @ebb-tide @jsternberg @danxmoran @wbaker85 @scbrickley @TCL735 @codyshepherd

[mzakharocsc]

It is not uncommon to plot data with empty tabels and aggregate using max/min. Using Grafana + graphite things work fine with max/min. Grafana + Influx runs into issues in plotting max/min with sporatic sensor data. Is there a direct substitue to max/min that will work in Influx for plotting? Otherwise, the bug is in the design and documentation as well.

[DaveMDS]

same issue here, any workaround?

[RanjithDBG]

Anything??