guess schema for mongoDB

[_AnonymousUser]

If guess schema is clicked for mongodb collection,the obtained schema has issue.If the collection has a record of array type in mongoDB, then while using guess schema it is obtaining as String type. Since it is getting as string type the unwinding of array is not possible and array data cannot be retrieved using tMongoDBInput if this schema is used. Is there alternative for this?

[Anonymous]

Hi,

If guess schema is clicked for mongodb collection,the obtained schema has issue.If the collection has a record of array type in mongoDB, then while using guess schema it is obtaining as String type. Since it is getting as string type the unwinding of array is not possible and array data cannot be retrieved using tMongoDBInput if this schema is used

What does your mongo collection look like? Are you using Talend V6.1.1 ?
Best regards
Sabrina

[_AnonymousUser]

                       
new_field3 in 1st pic is object type in mongodb where as using guess schema its data type is string in 2nd pic


and I am using 6.1.0 version of talend

[_AnonymousUser]

xdshi wrote:
Hi,

If guess schema is clicked for mongodb collection,the obtained schema has issue.If the collection has a record of array type in mongoDB, then while using guess schema it is obtaining as String type. Since it is getting as string type the unwinding of array is not possible and array data cannot be retrieved using tMongoDBInput if this schema is used

What does your mongo collection look like? Are you using Talend V6.1.1 ?
Best regards
Sabrina

new_field3 in 1st pic is object type in mongodb where as using guess schema its data type is string in 2nd pic  and i am using  and I am using 6.1.0 version of talend.