Execute the following command in neo4j:
LOAD CSV WITH HEADERS FROM "file:///accident.csv" AS line MERGE (p:accident{id:line.id,name:line.code,casualty:line.casualty})
Report an error:
Cannot merge the following node because of null property value for 'casualty': (:accident {casualty: null}) (Failure when processing file '/E:/Program/...../neo4j-community-4.4.8/import/accident.csv' on line 2.)
Cause: In the first time the entity is created and the casualty value in the file is empty.
Solution: Change merge to create
Source: Explanation of error “Cannot merge node using null property value for” – Knowledge Base
Read More:
- [Solved] Neo4j error: Import-Module & neo4j Neo.ClientError.Security.Unauthorized
- [neo4j] error report when visiting neo4j in spring boot project
- [Solved] Neo4j Error: Error occurred during initialization of VM Incompatible minimum and maximum heap sizes spec
- [Solved] uview u-sticky Error: Cannot read property ‘bottom‘ of null
- openlayers — Cannot read property ‘slice‘ of null—Map cannot be loaded
- El-cascader error: Cannot read property’level’ of null
- Vue ElementUI el-dropdown Error: Uncaught TypeError: Cannot read property ‘disabled‘ of null
- VUE Echarts Loading Error TypeError: Cannot read property getAttribute of null?
- TypeException: Error setting non null for parameter #1 with JdbcType null
- log4j Error: Please initialize the log4j system properly [How to Solve]
- [Solved] Error: Cannot run with sound null safety, because the following dependenciesdon‘t support null safe
- Android Working Directory:NULL Environment:NULL Error
- Node Kubelet Error: node “xxxxx“ not found [How to Solve]
- [Solved] Git Error: fatal: refusing to merge unrelated histories
- Mybatis Integrate SQLSERER Null Value Error: Error setting null for parameter # with JdbcType OTHER
- [Solved] Git Error: fatal: refusing to merge unrelated histories
- Git Error: refusing to merge unrelated histories [How to Solve]
- Git: How to Solve Error: Please commit your changes or stash them before you merge.
- [Solved] git Error: error: Your local changes to the following files would be overwritten by merge
- [Solved] Doris StreamLoad Error: load by MERGE or DELETE need to upgrade table to support batch delete