Hi Nithin, 1. You can use Query.setPageSize method to instruct the Cursor to read the result set in chunks bigger than 1024. However, regardless of the pageSize the Cursor returns the whole result: https://github.com/apache/ignite/blob/master/modules/platforms/nodejs/lib/Query.js#L56
2. That's how cursor._fieldnames are implemented: https://github.com/apache/ignite/blob/master/modules/platforms/nodejs/lib/Cursor.js#L264 - Denis On Mon, Feb 10, 2020 at 11:59 AM nithin91 < nithinbharadwaj.govindar...@franklintempleton.com> wrote: > Hi , > > We are trying to build an Rest API on top of ignite cache using node > express. > > Following is the way we are fetching data from ignite. > > await igniteClient.connect(new IgniteClientConfiguration(ENDPOINT)); > const cache = igniteClient.getCache(CacheNAME); > > const querysql=new SqlFieldsQuery("SqL"); > const cursor = await cache.query(querysql); > const row =await cursorProductDetails.getValue(); > > We are facing the following issues while fetching the data in cursor. > > 1. cursor._values property is always having only 1024 rows even though the > table as 100k rows. > 2. cursor._fieldnames property is not displaying the field names as > result > of which we have created an > array with list of fields and creating a list of json objects using this > array and traversing each row of cursor._values using map function. > > Please check below for sample code > > var dataProductDetails=cursor._values ; > > var res_data_prddetails=[]; > > var fields=[field1,field2] > > await dataProductDetails.map(function(arr){ > var prdobj={}; > fields.forEach((k,v)=> prdobj[k]=arr[v]); > res_data_prddetails.push(prdobj); > } > > > ); > > Also can you please let me know whether there is a way to directly convert > the sql fields query output to JSON using node express. > > > > > > > > > > > > > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >