Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

 

Thanks,

Sreeram

Anonymous
Not applicable
Author

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


0683p000009LzaQ.png

krrohit1256
Contributor
Contributor

@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.