apoc 导数据 时会漏掉一些数据,总是导不全?
发布于 1 个月前 作者 goodwater 117 次浏览 来自 问答

请问有谁用过下面类似语句导数据吗?最近发现总是少了几万条数据,不知如何解决? //F_CERT.CASE_ID unique create constraint on (p:F_CERT) assert p.CASE_ID is unique;

//(:F_CERT)-[:CONTROL]->(:F_CERT) call apoc.periodic.iterate( “call apoc.load.jdbc(‘jdbc:oracle:thin:{username}/{password}@{hostip}:{port}:{servicename or sid}’,“select case_id,proportion from invest where start_type=‘2’ and end_type=‘2’”)”, “merge (n1:F_CERT{CASE_ID:row.START_ID}) with * merge (n2:F_CERT{CASE_ID:row.END_ID}) with * create (n1)-[i:INVEST]->(n2) set i+=row”, {batchSize:100,iterateList:true})

1 回复
回到顶部