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/
