nero4j导入关系数据以及节点操作

1.  先看下构建好的关系图谱如下:

2. 构建节点,并且导入数据

create table ch_from_to_count(
id int primary key auto_increment,
fromWho VARCHAR(100),
toWho varchar(100),
caseId VARCHAR(24),
countNum int(11)
)charset utf8;
表中插入数据：
insert into ch_from_to_count(fromWho,toWho,caseId,countNum) 
SELECT * from( 
SELECT DISTINCT fromWho,substring_index(substring_index(t.toWho,';', b.help_topic_id + 1), ';', -1) toWho ,caseId,countNum
FROM ( 
SELECT DISTINCT *  from from_to_count_2
) t 
   join mysql.help_topic b  
ON b.help_topic_id <  (LENGTH(t.toWho) - LENGTH(REPLACE(t.toWho, ';', '')) + 1) 
) a 
---------------------------------------------------------------

3.neo4j数据导入ch_from_to_count节点：

load csv with headers from 'file:///ch_from_to_count.csv' as line
merge (a:ch_from_to_count { id:line.id, fromWho:line.fromWho, toWho:line.toWho, caseId:line.caseId, countNum:line.countNum})
return a.id as id, a.fromWho AS fromWho, a.toWho AS toWho, a.caseId AS caseId, a.countNum as countNum
neo4j数据导入ch_toWho节点：
load csv with headers from 'file:///ch_toWho.csv' as line
merge (a:ch_toWho { from_id:line.from_id, toWho:line.toWho, to_id:line.to_id})
return a.from_id as from_id, a.toWho AS toWho, a.to_id as to_id

4. 导入关系数据

MATCH (f:fromWho),(t:toWho) where f.id=t.id
CREATE (f)-[r:rel_b{caseId:f.caseId,countNum:f.countNum}]->(t) 
return r

转载于:https://www.cnblogs.com/fei-tian/p/9729968.html