Neo4j

paolodipietro58 · 06-13-2022

Can someone explain why a query is running but the CALL dbms.listQueries() reports no query is running?

paolodipietro58 · 06-12-2022

Hi all,I have the following short query, which reads a 40.000 lines input files, but suddenly stops after the first line. LOAD CSV WITH HEADERS FROM 'file:///Customers/data.csv" as row FIELDTERMINATOR ';' WITH row, trim(row.`nome del produttor...

paolodipietro58 · 06-06-2022

Server community edition 4.4.7Is there a way to create indexes for all the nodes who have a property with a given name?

paolodipietro58 · 06-06-2022

I'm running a community edition 4.4.7I'm importing some data using `LOAD CSV`.The functions ``linenumber()` and `file()` runs only outside `apoc.do.when` but return `null` if used inside.The following statement doesn't run: call apoc.do.when(x IS ...

paolodipietro58 · 05-25-2022

I don't know if this thread would be of interest but let me try: I have the following concept (maybe nodes?): A Card (million of nodes)A Brand(could be Visa, Mastercard, Amex, JCB, .... not more than 20)A Subbrand (could be standard, platinum, gold, ...

paolodipietro58 · 06-07-2022

This is the solution if someone is interested:// Create an index on all CALL db.labels() YIELD label UNWIND label as lab WITH "CREATE INDEX index_created_at_" + lab + " IF NOT EXISTS FOR (n:" + lab + ") ON (n.CREATED_AT)" as v1, "CREATE INDEX ind...

paolodipietro58 · 06-06-2022

I tried with:CALL db.labels() YIELD label UNWIND label as lab call apoc.cypher.run("CREATE INDEX index_created_at_" + lab + " IF NOT EXISTS FOR (n:" + lab + ") on (n.'CREATED_AT')",{lab: lab}) YIELD value as v1but it returns an error:Neo.ClientErro...

paolodipietro58 · 06-06-2022

Do you know any way to edit a post after posting in this new version of the community? It look like if you publish, you can never make any correction!

paolodipietro58 · 06-06-2022

I agree with you: technically it makes sense. But it is an annoying limit.As we've already seen in another post, apoc will automatically add variables when not explicit declared.And, as there are only these two functions, apoc could add them to the s...

paolodipietro58 · 05-27-2022

@glilienfield @bennu.neo @Rcolinp I have a little good new on this: I discovered tha you can remove the WITH statement inside and this further simplify the query, just keep attention to the names! CALL apoc.do.when(organisation IS NOT NULL, ...

Neo4j

User Statistics

User Activity

No query is running but a query is running!

LOAD CSV and lucenbe call have a strange behavior when used together

Index creation

A probable error while using LOAD CSV

Which would be the best method to model creadit cards?

Re: Index creation

Re: Index creation

Re: A probable error while using LOAD CSV

Re: A probable error while using LOAD CSV

Re: :auto transaction doesn't run as described in the manual