How to get list of records which got failed during batch loading in neo4j

[akshat_mittal]

Hello Team,

I am using Neo4j 3.5.5 and I am trying to load the data using periodic iterate statement in neo4j.
I want to know the how many records got failed and passed and their lists which got failed?

Please help!

Best Regards
Akshat

[intouch_vivek]

Hi Akshat,

Best way to solve this is via a programming language.

[akshat_mittal]

Hi Vivek,

Thanks for replying !!
But how ?? Any logic!!
Is neo4j not capable of giving these details?

Regards
Akshat

[intouch_vivek]

I suggest to you pre-process the data set first and then kick ingestion. In the preprocessing you can get all the details good data and bad data list.
I do not think there is anything we have in apoc or general cypher for data quality check. And moreover it is not very generic too to built. DQC is source and data specific

[akshat_mittal]

Hi Vivek,

Can u please share some sample query to perform this pre-processing ??

Regards
Akshat

[intouch_vivek]

Hi Akshat,

Sorry for delay in the reply!
Pre-Processing is very customized solution. It will be really great fi you provide your requirement in more detail.

Regards
Vivek

[akshat_mittal]

Hi Vivek,

Thanks for the quick reply !!

Requirement is to data load using one of the views of oracle DB in Neo4j Label using MERGE statement. I am using iterate statement while loading data in label.
So I need to know the list of failure records in one file.

Second Requirement related to failure records,
I am using iterate statement while creating the relations using MERGE statement
So I need to know the list of failure records in one file or neo4j logs.

It is the need to get these failure records either in logs or some csv file.

Regards
Akshat