Hello! * I have just tried modifying this example: https://github.com/apache/ignite/blob/master/modules/platforms/nodejs/examples/SqlExample.js and it was able to list all 4000+ cities from City table with no problems (mind the SQL file in examples directory shipped with Ignite). What version are you using? Can you provide complete reproducer together with data?
* To get field names in cursor, you first have to do query.setIncludeFieldNames(true). By default you are not getting them. Regards, -- Ilya Kasnacheev пн, 10 февр. 2020 г. в 22:59, nithin91 < [email protected]>: > 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/ >
