topic MongoDb Output - How to Write Array fields/values in a collection? in Talend Studio

MongoDb Output - How to Write Array fields/values in a collection?

Anonymous — Sat, 16 Nov 2024 12:00:42 GMT

Hello,
I have a need to write string arrays into a mongodb collection and I am using Talend Big Data and the components that come with that.
However, I do not see any option to define the output field as an array. Is writing to array possible?
Example:
This is the key/value format I need in my collection.
search_key:

Re: MongoDb Output - How to Write Array fields/values in a collection?

Anonymous — Fri, 31 May 2013 04:07:02 GMT

Hi,
I think you need a tjavaflex component in your job design.
See the related forum https://community.talend.com/t5/Design-and-Development/resolved-creating-and-using-Arraylists-in-Talend/td-p/100161
Best regards
Sabrina

Re: MongoDb Output - How to Write Array fields/values in a collection?

Anonymous — Fri, 31 May 2013 06:42:01 GMT

Thank you. This is good insight. However, I am getting the value of NULL now.
Here is what I am doing:
tMongodbConnection -->
SQLInput --> tjavaflex --> tmap --> tMongoOutput
tjavaflex:
Start:
// start part of your Java code
java.util.ArrayList list1 = new java.util.ArrayList();

Main:
list1.add("hello");
list1.add("there");
list1.add("test");
globalMap.put("latlong", list1);
-------------------
Then in tmap, I on right side, I have:
column: latlongtest, type: list, Expression: (java.util.ArrayList)globalMap.get("latlong")

I also tried entering (java.util.ArrayList)globalMap.get("latlong") in the Variable section but still getting NULL in mongodb.
latlongtest is defined as list in mongodb schema.
Please help as my project is due on Monday.
Thanks.

Re: MongoDb Output - How to Write Array fields/values in a collection?

Anonymous — Fri, 31 May 2013 07:28:57 GMT

Hi,
To make a testing for that, you can use a tlogrow instead of tMongoOutput in your work flow to see if there any data can be out put on console?
Best regards
Sabrina

Re: MongoDb Output - How to Write Array fields/values in a collection?

Anonymous — Fri, 31 May 2013 07:33:12 GMT

I did try tLogRow and it shows null.
Is there any documentation of Array/List and globalMap.put?