Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

cypher: schema index support for IN predicates #2079

Closed
shaikatzir opened this Issue · 5 comments

4 participants

@shaikatzir

posted a question about it on SO:
http://stackoverflow.com/questions/21617625/cypher-2-0-using-label-based-index-to-search-a-set-of-nodes

I would like to be able to use the following cypher query:
MATCH (gr:Group) <--(us:User)--(gr2:Group)
WHERE gr.name in {groups}
return distinct gr2

where 'groups' is a given parameter - array of group names.
And the engine should take advantage of the fact that there is label index on Group{name}.

@cleishm
Owner

Thanks shaikatzir,

Having the schema indexes support IN predicates is definitely something we'd like to add support for in a future release. I'll be sure to add your vote to it.

Cheers,
Chris

@aseemk

I didn't realize this was the case today. Big +1 from me as well — we do batch processing, i.e. queries across multiple nodes, in a number of cases, but we still specify indexed properties for those.

Is it possible to achieve via a USING INDEX statement?

@cleishm
Owner

This is supported as of Neo4j 2.1.2.

@cleishm cleishm closed this
@aseemk

Awesome! =) Thanks Chris.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.