GC issue when running select query for large dataset

Hello,

I am facing GC issue on druid when running select query on large dataset having 4 million records.

Historical broke with GC issue. I am using paging identifier to create pagination for the select query.

I don’t know why it fetches all the data when using pagination in select query and druid historical broke with GC issue.

Please help me with this issue. Any workaround or anything would be appreciated.

Thanks

Please use the Scan Query, it is part of Druid core starting from 0.11.0

http://druid.io/docs/latest/querying/scan-query.html