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.

Commencez par reproduire la requête unique `select count(*) from root.test.** group by level =3` avec plus de 1000 colonnes de résultat et comparez-la au nombre attendu de 50000×100. Suivez le traitement du résultat de la requête pour identifier l'endroit où les colonnes sont tronquées. C'est terminé lorsqu'une seule instruction SQL renvoie le nombre complet pour le grand jeu de données indiqué.

Rédigé par le modèle d'indexation à partir du texte de l'issue.