I have a measurement cpu
which has initially only one series with insert date/time = 04/19, 8:40
Now I have insert one series host=node2 with back date/time 04/18, 3:33, other series host=node3 with forward date/time 04/19, 09:51 and host=node1 with date/time 04/19, 09:51.
Now for below query, I didn’t get result for host=node2 with back date/time 04/18, 3:33, but getting result for host=node1 and host=node3.
SELECT * FROM "cpu" where (Asset = 'node1' and time > '2021-04-19T08:40:00.8650000Z') or (Asset != 'node1')
Question is, what’s wrong with query, why node2
data NOT coming is query result?