Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a problem when reading data from a MongoDB collection with the talend tMongoDBInput component. I have the following error:
mongoDb Exception in component tMongoDBInput: java.util.regex.PatternSyntaxException: Unclosed character class near index 64
I think while creating indexes on the mongoDB collection I'm trying to read they used square brackets which I component talend misinterpret.
Have you ever encountered this case and do you have any solutions for me?
thanks in advance.
Hello,
Could you please post your current job design screenshots here? What does your data look like?
Are you trying to read Array Data from Mongo Collection?
If so in the schema settings of tMongoDbInput, you can setup type to "List" for the array field , then use tExtractJSONFields component to extract the child elements of the array field.
Best regards
Sabrina