0

I currently use Version 1.1 of Apache IoTDB, and I need to find the recent data updated in the server. I wonder how to query the devices which data has been updated in the last hour in IoTDB? How should I write the query statement?

Sihan Liu
  • 128
  • 1
  • 6

1 Answers1

0

Try this query statement in Apache IoTDB: select count(s1) from root.db.** where time >= now() -1h and time < now() having count(s1) > 0 align by device.

Yuan Tian
  • 98
  • 1
  • 4