One Star

tMongoDBInput_1 - The query does not contain any reference an index.

Hello All,
I m using talend Big data 6.1 version and mongodb of 3.0 version
while i am using tmongoinput,
 I m getting error viz, "tMongoDBInput_1 - The query does not contain any reference an index.  ", but all records are displayed successfully
whenever i gave reference id inside the querry , it doesnt give any error,but records  are not displayed,please help me.
3 REPLIES
Moderator

Re: tMongoDBInput_1 - The query does not contain any reference an index.

Hi,
"tMongoDBInput_1 - The query does not contain any reference an index.  "

It is a warning to help the user to optimize their query for the query is empty or if the query does not contain any indexed fields. This warning is not relevant for the "_id", but it is always useful for people to know all the indexes.
Here is the related reference:https://docs.mongodb.org/manual/core/query-optimization/?&_ga=1.206319571.1127928241.1401451924#quer...
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tMongoDBInput_1 - The query does not contain any reference an index.

@xdshi Could you let me know how to suppress this warning? 

 

Thanks,

Sreeram

One Star

Re: tMongoDBInput_1 - The query does not contain any reference an index.

Hi All,

after so many tries I found that if you are using tAggregateRow you need to put all the column name in "Group by"

as given below


Capture.PNG