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