An easy method to count the total number of time-series data

I used workbench to write a large number of data into iotdb, e.g. 50000 devices and 100 sensors for each device. Then I wanted to verify whether the total number of data actually written into iotdb is equal to the number expected.

I used sql statements like "select count(*) from root.test.** group by level =3", but can't get the correct answer which should be 50000\*100. It seems like that result columns over 1000 has been truncated.

What I expect is, when I execute one single sql statement, it can return the correct number of all data in db. In industry, large data is ubiquitous, so a good support for large data might be a common scene.

Now, I used a sql and shell combined way to verify the number, such like "select count(*) from root.test.**.d_${i} group by level =3". Here i ranges from 1 to 50000. And finally add 50000 results together to get the correct number.

Comienza reproduciendo la consulta individual `select count(*) from root.test.** group by level =3` con más de 1000 columnas de resultados y compárala con el recuento esperado de 50000×100. Rastrea el procesamiento del resultado de la consulta para identificar dónde se truncan las columnas. Se considera terminado cuando una única instrucción SQL devuelve el recuento completo del conjunto de datos grande indicado.

Escrito por el modelo de indexación a partir del texto del issue.