Insert array of double datatype for MongoDB

Anonymous — Sat, 16 Nov 2024 08:29:06 GMT

I am trying to insert the following json into mongodb using tMongoDBInput-->tmap-->tMongoDBOutput. The "coordinates" values show up as string in the output collection. All through the job the values(longitude, latitude) of coordinates are defined as double. I want them to have a double datatype. I have defined "coordinates" with Node Status = loop element and @class with Static Value = array. @type is defined as double in the Link target of tMongoDBOutput. But still data is showing up as string in the array. What am i doing wrong ?

{
"_id" : "5ab51c8b2c75d21a40665d76",
"location" : {
"position" : {
"type" : "Point",
"coordinates" : [
"85.0",
"65.0"
]
}
}
}

Re: Insert array of double datatype for MongoDB

Anonymous — Fri, 30 Mar 2018 15:15:34 GMT

This seems to be a basic functionality that should be accommodated in Talend but now thinking this is not possible through the tool and have to use custom code to update datatype ?

topic Insert array of double datatype for MongoDB in Talend Studio

Insert array of double datatype for MongoDB

Re: Insert array of double datatype for MongoDB