read from Hive and load into MongoDB

I have the below Hive table with complex data types. I want to read the Hive table and load into MongoDB. how can I do this?
Thanks for your help.
create table transaction(transaction_id int,code string,attempts array<string>,case array<string>)
row format delimited
fields terminated by ‘,’
collection items terminated by ‘~’;
Hive Table
------------
123456789,abc,1~2~3,23~45~47~76
Final output format into MongoDB
---------------------------------
{
"_id" : ObjectId("528ba7691738025d11aab772"),
"Transaction" : "123456789",
"code" : "abc",
"attempts" : ,
"case" :
}
1 REPLY
Community Manager

Re: read from Hive and load into MongoDB

Hi 
Refer to this topic, it is possible to generate an array in a json data, but now, it is not allowed to configure multiple loop elements in a Json tree structure on tMongoDBOutput.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business