Translation of InfluxDB2 UNION query into HA yaml syntax

1

To avoid a ““Error: Panic: runtime error: invalid memory address or nil pointer dereference.”” error, I split the table into 2, excluding the range of timestamps causing the unclear error.

Flwg. union query works, but I can’t figure out how to translate it into HA yaml (multiple tables, range_starts and range_stops).

import "generate"

    t1 =
        from(bucket: "HomeAssistant")
        |> range(start: -365d, stop: 2022-12-02T00:00:00Z)
        |> filter(fn: (r) => r["_field"] == "value")
        |> filter(fn: (r) => r["entity_id"] == "viessmann_getbrennerstunden1")
        |> keep(columns: ["_time", "_value"])
    t2 =
        from(bucket: "HomeAssistant")
        |> range(start: 2023-01-09T00:00:00Z, stop: now())
        |> filter(fn: (r) => r["_field"] == "value")
        |> filter(fn: (r) => r["entity_id"] == "viessmann_getbrennerstunden1")
        |> keep(columns: ["_time", "_value"])
    union(tables: [t1, t2])
        |> aggregateWindow(every: 1d, fn: first)
        |> group()
        |> aggregateWindow(every: inf, fn: spread, createEmpty: false)
        |> keep(columns: ["_value"])
        |> sort(columns: ["_value"], desc: true)
        |> first()