start-cli -e 'query' just return 1000 lines and redirect to file can't auto stop in I-CodePudding

Home > Software engineering > start-cli -e 'query' just return 1000 lines and redirect to file can't auto stop in I

start-cli -e 'query' just return 1000 lines and redirect to file can't auto stop in I

Time：12-19

When I use start-cli.sh to execute a query SQL, it only returns top 1000 rows of the whole results. And then, I use start-cli.sh -e "sql" > redirect.txt, but it only gets 1000 rows and must use ctrl c to stop. How can I get the whole result?

CodePudding user response：

this is a known issue. One simple solution is using start-cli.sh -maxPRC -1 -e "sql" > redirect.txt. Thanks!

Page link：https//www.codepudding.com/Softwareengineering/233422.html

Prev:Failed to execute goal com.diffplug.spotless:spotless-maven-plugin when building IoTDB database

Next:Cannot query for more than 1000 timeseries after upgrading to 0.12.3 in IoTDB database

Tags：

database

apache-iotdb

iotdb

Links：
CodePudding