topic Re: tMongoDBInput_1 - The query does not contain any reference an index. in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 10:55:38 GMT

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.

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

Anonymous — Mon, 07 Dec 2015 03:08:13 GMT

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#query-optimization
Best regards
Sabrina

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

Anonymous — Mon, 09 Jul 2018 00:04:11 GMT

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

Thanks,

Sreeram

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

Anonymous — Mon, 20 Aug 2018 14:07:56 GMT

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

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

krrohit1256 — Thu, 06 Feb 2020 16:55:04 GMT

@rchinta @xdshi .. Any idea how to suppress this warning?

In prod server i do not see this warning.

I deployed a new version of job in dev env with some modification and started getting this warning.