You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have two continuous queries for saving in the bucket 'hour_infinite' data that Home assistant send to my 'raw_weeks' bucket (I am using influxdb 1.8).
The first one save hourly data with field = value and work very well:
CREATE CONTINUOUS QUERY "cq_1h_temperature" ON "HAdb"
BEGIN
SELECT mean("value") AS value
INTO "hour_infinite"."temperature"
FROM "raw_weeks"."temperature"
GROUP BY time(1h), entity_id
FILL(previous)
TZ('Europe/Rome')
END
with the second continuous query I want save hourly the data with field = dew_point, heat_index and wet_bulb:
CREATE CONTINUOUS QUERY "cq_1h_1_temperature" ON "HAdb"
BEGIN
SELECT mean("dew_point") AS "dew_point", mean("heat_index") AS "heat_index", mean("wet-bulb") AS "wet_bulb"
INTO "hour_infinite"."temperature"
FROM "raw_weeks"."temperature"
WHERE entity_id = "airlink_temperature"
GROUP BY time(1h), entity_id
FILL(previous)
TZ('Europe/Rome')
END
but unfortunatly the second one don't save any data
Does anyeone have any suggestions about what I am wrong?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have two continuous queries for saving in the bucket 'hour_infinite' data that Home assistant send to my 'raw_weeks' bucket (I am using influxdb 1.8).
The first one save hourly data with field = value and work very well:
CREATE CONTINUOUS QUERY "cq_1h_temperature" ON "HAdb"
BEGIN
SELECT mean("value") AS value
INTO "hour_infinite"."temperature"
FROM "raw_weeks"."temperature"
GROUP BY time(1h), entity_id
FILL(previous)
TZ('Europe/Rome')
END
with the second continuous query I want save hourly the data with field = dew_point, heat_index and wet_bulb:
CREATE CONTINUOUS QUERY "cq_1h_1_temperature" ON "HAdb"
BEGIN
SELECT mean("dew_point") AS "dew_point", mean("heat_index") AS "heat_index", mean("wet-bulb") AS "wet_bulb"
INTO "hour_infinite"."temperature"
FROM "raw_weeks"."temperature"
WHERE entity_id = "airlink_temperature"
GROUP BY time(1h), entity_id
FILL(previous)
TZ('Europe/Rome')
END
but unfortunatly the second one don't save any data
Does anyeone have any suggestions about what I am wrong?
Thank
danilo
Beta Was this translation helpful? Give feedback.
All reactions