topic guess schema for mongoDB in Talend Studio

guess schema for mongoDB

_AnonymousUser — Mon, 22 Feb 2016 13:23:34 GMT

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?

Re: guess schema for mongoDB

Anonymous — Tue, 23 Feb 2016 06:36:47 GMT

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

Re: guess schema for mongoDB

_AnonymousUser — Tue, 23 Feb 2016 09:51:55 GMT

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

Re: guess schema for mongoDB

_AnonymousUser — Thu, 25 Feb 2016 09:27:42 GMT

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.