How to set resultset size?

[samwzm]

Hi, there,

For a big query with huge number of recorders/rows (couple millions), it will take a very long time to retrieve all the results (it has been 20 minutes and still running). I believe if we can setup the resultset size to retrieve how many rows each time, it can boost the performance a lot. But I can't find any doc about that setting. Could anyone let me know how to do that?

Thanks,
Sam

[its-nikhil]

@samwzm did you find any solution around this? I am working on similar stuff

[MasterOdin]

The client doesn't support this, though it's maybe possible via an undocumented query param targetResultSize which gets passed to /v1/statement/executing which can be used to set number of rows that'd be returned, and it sounds like it'll return 1MB of rows at a time (referenced at https://trinodb.slack.com/archives/CP1MUNEUX/p1671524526820449?thread_ts=1671516357.690159&cid=CP1MUNEUX).