Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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" :
}
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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