How do I change default row limit value for query database node?

Changing Appian configurations for these types of purposes often indicates that you need to reconsider your overall approach. These limits are in Appian for a reason and you may run into more problems in the future should you use Appian for problems that it isn't intended to solve.

With that in mind, you can update the
resources.appian.process.application.arv.limit property in the custom.properties which should allow you to return more rows. Note that you'll need to test whether 1000 works since there is likely a hard limit for this configuration.

Changing Appian configurations for these types of purposes often indicates that you need to reconsider your overall approach. These limits are in Appian for a reason and you may run into more problems in the future should you use Appian for problems that it isn't intended to solve.

With that in mind, you can update the
resources.appian.process.application.arv.limit property in the custom.properties which should allow you to return more rows. Note that you'll need to test whether 1000 works since there is likely a hard limit for this configuration.