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
14
votes
2 answers

DETACH DELETE Neo4j 2.3.x/Cypher

What is the behaviour and purpose of the new Cypher operator DETACH DELETE added in Neo4j 2.3.x?
alexanoid
  • 24,051
  • 54
  • 210
  • 410
3
votes
5 answers

Storing different types in vertex properties with the same name on Apache AGE

Apache AGE allows me to store values of different types in vertex properties with the same name. For example: Creating a vertex with pages = 10: SELECT * FROM cypher('books', $$ CREATE (v:Book {title: 'A book', pages: 10}) RETURN v $$) as (v…
Carla
  • 326
  • 1
  • 7
3
votes
1 answer

AWS Neptune simple opencypher count query takes too long

I have a graph database in AWS neptune which has 60M nodes. A simple count query to count all nodes takes ~6-7 minutes. query is: MATCH (n) RETURN count(n) as count Is 6 minutes to count 60 million nodes normal? what can I do to make it…
Mustahsan
  • 3,852
  • 1
  • 18
  • 34
2
votes
0 answers

Query Timeout in Neptune OpenCypher - Different Results for Similar Queries

I apologize for the naive question as I am relatively new to graph databases and currently working with Neptune OpenCypher for my use case. I am experiencing different outcomes for two similar queries and would like to understand the reasons behind…
topgun007
  • 21
  • 2
2
votes
1 answer

problem to access of the properties of an edge when using plpython3u in PostgreSQL to create functions

I implement python function for for the following query and i get correct answer, but when i try to create functions in postgreSQL by using plpython3u extension, it doesn't have any error but still doesn't return the results to the table. Also, I…
Jaber
  • 23
  • 4
2
votes
1 answer

How to find vertices with a property which contains a value inside a curly braces and it follows a pattern?

I created some vertices to represent MTG cards. Each card has a property called mana_cost, which is the cost to play that card in the game. The mana_cost value is stored between curly braces in a string. For example, "{G}{G}" would represent two…
Matheus Farias
  • 716
  • 1
  • 10
2
votes
2 answers

What does separate curly bracket means in Cypher?

I have read the document, and i found that curly brackets are normally used to form a subquery or it can be used to describe the properties of a node or relationships. But i notice that some times curly brackets are used separately, and i can't…
Frisia
  • 23
  • 4
2
votes
1 answer

Simulate a MERGE in Neptune's OpenCypher implementation

I'm trying to run a MERGE query against an AWS Neptune database using their new OpenCypher implementation but MERGE is not yet supported as a clause. Is there a way to get the behaviour of a MERGE without using a MERGE in Neptune's OpenCypher…
Sam Martin
  • 1,238
  • 10
  • 19
1
vote
1 answer

How to solve this cypher problem in Galaxybase?

The log shows: com.graphdbapi.driver.v1.exceptions.DatabaseException:Cypher task execution blocking time overruns What causes this problem? How to solve it? I feel like it's because there are too many concurrent queries. Is concurrency not…
Chris Han
  • 67
  • 4
1
vote
2 answers

Adding case in Match statement of iterate function in neo4j

I've recently started working on Cypher. Created a Book database. I want to implement following things using Cypher query- Find all books containing at least 1 capital letter in its isbn property value. Traverse over all of such books and for each…
nik
  • 1,464
  • 4
  • 18
  • 32
1
vote
16 answers

Removing the label name in Apache agedb produces error

I am using the following sample query to create a node with a label. SELECT * FROM cypher('vg-graph', $$ CREATE (m:Movie {name: "Movie Name", uid: "12345678", body: "Description"}) $$) as (n agtype); Following query should remove label…
Abdul
  • 69
  • 5
1
vote
1 answer

Memgraph - How to find the closest node with specific property efficiently

I have a pretty large network that contains privileged information. Because of this i can't share the exact graph but in its simplest form it can be abstracted as follows. (Person{name:str, age:int})-[:KNOWS]-(Person{name:str, age:int}) I would…
Jasper
  • 65
  • 8
1
vote
1 answer

Memgraph cypher recursive tree with depth and filtering query

I'm using Memgraph (but open to using Neo4j) and need some help on building a recursive query to build out a tree. I'm new to Cypher so my attempts so far haven't been successful. I've played around with the CALL subqueries but can't seem to get the…
NathanS
  • 163
  • 2
  • 10
1
vote
11 answers

Apache agedb produces error when ORDER BY and RETURN AS r is used. Unexpected behaviour

When I execute these queries on apache ageDB SELECT * FROM cypher('sample_graph', $$ CREATE (:opt_match_v {prop: 'value1'})-[:opt_match_e]->(:opt_match_v {prop: 'value2'}), (:opt_match_v {prop: 'value3'})-[:opt_match_e]->(:opt_match_v…
Abdul
  • 69
  • 5
1
vote
2 answers

Ambiguous count results in Apache ageDB cypher query when alias is not defined: Why?

I am not able to get why this apache agedb behaviour is not returning correct result in the following query when alias in not defined SELECT * from cypher('sample_graph', $$ CREATE (a:Part {part_num: '111'}), (b:Part {part_num: '222'}), …
Abdul
  • 69
  • 5
1
2 3 4 5 6 7