Update MongoDB destination based on _id column

asked 2019-01-14 12:31:44 -0500

srinath_222 gravatar image

updated 2019-01-14 12:33:16 -0500

Hi,

I am having MongoDB collection test1 as origin and also trying to update a different MongoDB collection test. I am trying to update based on _id(MongoDB default unique key) column.

It is not updating the target. The _id column is of data type object in MongoDB collection but when I run data preview on Streamsets processors it is processed as String. Can we change the data type of a column to Object type (tried using Field Type Converter processor but object data type is not present).

I have also read in Streamsets JIRA that MongoDB destination does not allow upserts with non-string unique keys: https://issues.streamsets.com/browse/...

Can you please suggest how to proceed with this scenario.image description

edit retag flag offensive close merge delete