SELECT statement brings records with empty measures in AWS Timestream table

0

Hello: I have a MULTI measure table in AWS Timestream, and when I run a SELECT to bring values from a measurement, it brings rows including those where the measurement does not exist. For example, having measures like 'temp' and 'humidity', the following query:

SELECT temp, time FROM "test"."reports" WHERE  time between ago(1d) and now() ORDER BY time DESC LIMIT 100 

brings these records:

temp       time
21.55	2022-08-27 00:02:43.478000000
-       2022-08-26 23:35:11.490000000
23.2	2022-08-26 23:34:36.090000000
24.1	2022-08-26 23:34:17.332000000
24.1	2022-08-26 23:31:09.975000000
24.1	2022-08-26 23:29:56.867000000

So my question is why the record without 'temp' data is returned by the SELECT statement? How should I filter out this value?

Thanks

gefragt vor 2 Jahren56 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen