Stack Overflow
Stack Overflow

Questions tagged [opencypher]

For questions related to openCypher, a declarative graph query language

openCypher, a declarative graph database query language, is an open source project, including a language specification, located at here and the specification is available here.

105 questions
0
votes
1 answer

Querying nodes using array property - neo4j

I have a property on the node which is stored as array of strings. But when I use this field to find the node, it's not returning any results. What am I doing wrong? Below is the node: MATCH (n:Product) WHERE n.id_product =…
Tom
  • 86
  • 1
  • 10
0
votes
1 answer

What is the difference between two FOREACH block codes in Cypher?

Are these two blocks actually the same? The goal is to create three nodes with IDs 1, 2, 3, and 4. Block 1: FOREACH ( i IN [1, 2, 3, 4] | CREATE (n {id : i}) ) Block 2: CREATE (n { prop : [[1, 2], [3, 4]]); MATCH (n) FOREACH ( inner_list IN…
KWriter
  • 1,024
  • 4
  • 22
0
votes
1 answer

Is DETACH a clause or a some kind of modifier?

I'm trying to figure out the naming convention for parts of Cypher queries. In Cypher Query Language Reference, Version 9 DETACH is listed on page 197 as a clause. But in all examples, I've seen DETACH used only in pairs with DELETE. So it is always…
KWriter
  • 1,024
  • 4
  • 22
0
votes
2 answers

When should I use CREATE and when MERGE in Cypher queries?

I've seen that sometimes CREATE is used to create nodes, and in other situations, MERGE is used. What's the difference, and when should one be used in place of another?
KWriter
  • 1,024
  • 4
  • 22
0
votes
1 answer

Does counting hops start from zero of from one?

When counting hops, has the first node (the one that is directly connected) the distance of one hop or zero hops? For example, in this code will return the results when the path is equal to or shorter than 3 hops: MATCH path=(n {id:…
KWriter
  • 1,024
  • 4
  • 22
0
votes
1 answer

Downtime required for 20 GB of Neo4j DB data migration to Neptune

I want to migrate 20 GB of Neo4j Graph data to AWS Neptune. how much Neo4j DB downtime is needed for entire data migration and how to handle the data lost during downtime.
anisha
  • 1
0
votes
1 answer

openCypher equivalent of Gremlin repeat...until loop

Using the air-routes data set, the following Gremlin query will find five routes between Austin (AUS) and Wellington (WLG). g.V().has('code','AUS'). repeat(out('route').simplePath()). until(has('code','WLG')). limit(5). path(). …
Kelvin Lawrence
  • 14,674
  • 2
  • 16
  • 38
0
votes
1 answer

create AWS Neptune graph from raw csv

I saw a lot of tutorials about how to load csv (Gremlin) data in the format of vertices and edges into AWS Neptune. For a lot of reasons, I cannot create vertices and edges for data loading. Instead I have just the raw csv file where each row is a…
Gene Xu
  • 609
  • 1
  • 8
  • 18
0
votes
1 answer

openCypher client for AWS Neptune

I'm looking for a graph exploration tool similar to https://github.com/prabushitha/gremlin-visualizer for querying AWS Neptune while using openCypher to enjoy the new…
Avner Levy
  • 6,601
  • 9
  • 53
  • 92
-1
votes
1 answer

Cannot stop an executing Cypher query in Galaxybase

In the Galaxybase cluster management platform (51314 interface)-Services-Cypher execution list, the Cypher statement being executed does not take effect immediately after clicking Stop. What should I do to stop a cypher query execution?
CreateLink Galaxybase
  • 270
  • 1
  • 7
-1
votes
1 answer

Executing a Cypher query in the Galaxybase studio prompts "Query time exceeded"

I'm trying to do a cypher query in the graph database Galaxybase, but it prompts "Query time exceed". MATCH (n:`bankid`),(e:`person`) WHERE n.bankid IN bank_code AND e.idnumber IN person_code AND cumulativeinflow > 200000 WITH collect(n.bankid) AS…
CreateLink Galaxybase
  • 270
  • 1
  • 7
-1
votes
3 answers

Variable Edges Query

Can anyone explain with just words how this query works? SELECT * FROM cypher('graph_name', $$ MATCH p = (actor {name: 'Willam Defoe'})-[:ACTED_IN*2]-(co_actor) RETURN relationships(p) $$) as (r agtype); It's quite confusing and not very…
Peter
  • 43
  • 4
-1
votes
1 answer

Neo4j Type mismatch: map key must be given as String, but was Integer

I have an integer-value that I want to be saved as a string-value in Neo4j using Cypher. LOAD CSV WITH HEADERS FROM 'file:///nodes-addresses.csv' AS line CREATE (:Address line[0], address: line[1], name: line[2], countries: line[3],…
ZM.TSS
  • 31
  • 3
-2
votes
5 answers

pg_regress: initdb failed with 'invalid permissions' error

I am trying to run an installation check for PostgreSQL using make PG_CONFIG=../postgresql-11.17/bin/pg_config installcheck in the age directory and I am getting an error message saying "pg_regress: initdb failed" with a DETAIL message saying that…
Nnaemeka Daniel John
  • 333
  • 1
  • 7
-3
votes
9 answers

WHERE, AND in Cypher query

While using the WHERE clause in cypher queries how do one join multiple conditions?. Is it valid to use AND as in WHERE condition1 AND condition2 or what’s the valid way to do something of such?.
Peter
  • 43
  • 4
1 2 3 4 5 6
7