Thank you Yuan, that works!
Thanks Trevor Hart ---- On Thu, 04 Apr 2024 14:10:43 +1300 Yuan Tian <jackietie...@gmail.com> wrote --- Hi Trevor, Maybe you can try count_time agg function, https://iotdb.apache.org/UserGuide/latest/Reference/Function-and-Expression.html#count-time . select count_time(*) from root.logs.device; Best regards, ------------------------- Yuan Tian On Thu, Apr 4, 2024 at 2:24 AM Trevor Hart <mailto:tre...@ope.nz> wrote: > Hello All > > > > Question; whats the correct way to get a full count of all rows in a > timeseries using SQL? > > > > I can do this; > > > > select count(status) from root.logs.device > > > > But this only gives me the count of status that are not null. > > > > The queries below both return zero results. > > > select count(time) from root.logs.device > > and > > select count(timestamp) from root.logs.device > > > > Thanks > > Trevor Hart
