read from Hive and load into MongoDB

Anonymous — Sat, 16 Nov 2024 11:13:31 GMT

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" :
}

Re: read from Hive and load into MongoDB

Anonymous — Tue, 02 Jun 2015 02:42:56 GMT

Hi
Refer to this https://community.talend.com/t5/Design-and-Development/Import-data-into-MongoDB-Bug-with-tMongoDBOutput/td-p/93677, 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

topic Re: read from Hive and load into MongoDB in Talend Studio

read from Hive and load into MongoDB

Re: read from Hive and load into MongoDB