Apoc.periodic.iterate fails the batch if there is an duplicate data in parameter

[maheshkhanna]

Neo4j Version : 3.5.3
Neo4j Procedure version : 3.5.0.13

stackoverflow.com

apoc.periodic.iterate fails the batch if there is an duplicate data in parameter

neo4j, cypher, neo4j-apoc

answered by cybersam on 09:19PM - 03 Sep 20 UTC

I would like to see some answers for the above from developers here

[Cobra]

Hello @maheshkhanna and welcome to the Neo4j community

Could we see the query?

Regards,
Cobra

[maheshkhanna]

call apoc.periodic.iterate(‘ UNWIND {propertyList} as property RETURN property.owner as owner ,property.properties as properties ","MERGE (own:MAN {id:owner.key}) SET own += owner FOREACH (property in properties | MERGE (prop:PROPERTY {id:property.key}) SET prop += property MERGE (own)-[:OWNS]->(prop) )”, { batchSize:500 , parallel:true,retries:0 ,iterateList :true ,failedParams :50 , params:{propertyList : $propertyList} })

[Cobra]

Hello @maheshkhanna

I think you are complicating things here, what are you trying to achieve?

Regards,
Cobra

[maheshkhanna]

my data will be like this

• owner can have multiple properties

• We are storing the properties owned by him by connecting the PROPERTY node to MAN node

Since the data set is very huge it can have duplicate properties for other owners too

[Cobra]

Can you share the schema of your database? CALL db.schema.visualization()

Can you give me an example of what is in {propertyList}?