connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

How to use chunksize while fetching huge dataset from DB

Open suresh-subramaniyan-s opened this issue 3 years ago • 5 comments

i have more than 10GB of data in oracle database . Need to process the data in chunks . Is there any option to retrieve the data in smaller chunks

suresh-subramaniyan-s avatar Apr 06 '22 13:04 suresh-subramaniyan-s

Hi @suresh-subramaniyan-s , thanks for opening the issue. We currently do not support return in chunks, but we are working on it now.

wangxiaoying avatar Apr 06 '22 16:04 wangxiaoying

I have the same problem. This library is already great. Getting the SQL results as "arrow chunks" would make it perfect.

bigbohne avatar Nov 24 '22 09:11 bigbohne

Hi @wangxiaoying, how is the progress on this feature?

mirecl avatar Dec 14 '22 19:12 mirecl

I have a memory error on big dataset. Is there any plan to retrieve the data in smaller chunks?

mtreguer avatar Sep 18 '23 21:09 mtreguer

@wangxiaoying Any update, this would be awesome? Thanks!

jtlz2 avatar Oct 23 '23 13:10 jtlz2