Hello Guys,
when I insert a row in Mongo shell:
db.mycoll.insert(
{
"column1":
}
)
result is:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : }
but when I load data with Talend tMongoDBOutput component, even I choice column1's data type is "Object" in output side, Talend still load it as string, result like this:
{ "_id" : ObjectId("58b82d52957107b7c5d11062"), "column1" : "" }
Because input_row is from Oracle, it is string, so I tried to add a tJavaRow component convert the string to array, but I can not set the result value to ouput_row which is tMongoDBOutput component's input_row, so anybody know What the best way I can do to resolved this problem? By the way, I must use Talend tMongoDBOutput to do it.
Thanks