Re: Query requires iterating over all vertices


Boxuan Li
 

Can you show the profile output? Just add .profile() to the end of your query.

「Laura Morales <lauretas@...>」在 2021年7月23日 週五,下午4:13 寫道:

I was able to open my lucene folder with a tool called "luke" for peeking at the data, and all the "country" values seems to be in there. I assume by looking at this that the index was created and persisted. I really don't understand why Janus is not able to use it...


> Sent: Thursday, July 22, 2021 at 5:52 PM
> From: "Laura Morales" <lauretas@...>
> To: janusgraph-users@...
> Cc: janusgraph-users@...
> Subject: Re: [janusgraph-users] Query requires iterating over all vertices
>
> > Try rewriting your query as:
> > `  g.V().has("country", P.neq(null)).values("country").dedup().order().limit(10)`
>
> Unfortunately this does not seem to remove the warning.
>
> WARN  org.janusgraph.graphdb.transaction.StandardJanusGraphTx  - Query requires iterating over all vertices [(country <> null)]. For better performance, use indexes
>
> I only followed the instructions in the documentations, verbatim. I hope that's all there is to create the index.





Join janusgraph-users@lists.lfaidata.foundation to automatically receive all group messages.