Hello all getting below error while running a cypher query:
LOAD CSV WITH HEADERS FROM 'file:///cert_exams1.csv' AS line
Match(n:Certifications) where n.name = line.`Certificate Name`
with n.name as na, SPLIT(line.`Prerequis...
I am working on some data ingestion using python in neo4j.
I am using multiple transactions to run a process, if any transaction fails then it should rollback each transaction.
while I am trying to do that then performance is not good.
I am running below query with is dealing with large volume of data and it enters in a forever loop.
match (t1)-[:IN|OUT]-(a1:add) where a1.add= 'abc' return collect(DISTINCT t1) AS tx
is there any way to make this working ??
I am having...
Please find Explain of my query:
And my query for this plan is:
match (t1:tr)-[o]-(a1:add) where a1.add= 'xyz' with distinct t1.id as ids-----(these IDS are around 50k in count)
Match (t3:tr)-[o2:exit]->(a2:add) where t3.id in (ids)
I am facing a very common issue with the cypher. when I am trying to run the below query, I am not getting any output and it running forever.
match (t3:tx)-[o2:exit]->(a2:add) where t3.id in [list which contains 40k records] return disti...
If you are using local then go to folder of your data and delete the database which you want to delete .
folder location should be /neo4j--data--dbms
Note: If you want to delete whole data in your database
I tried with commit and got below screen:
could you please suggest me, why getting this ?
new query is:
CALL apoc.periodic.commit("match (t1)-[:IN]-(a1:add) where a1.add= 'abc' WITH collect(DISTINCT t1) AS tx LIMIT $limit return tx",...
Yes, I have index on a1:add.I am having only one label for t1 and checked with the label as well but the same result.yes I need to collect the whole record since I need to pass the whole record in another query as list and need to use...