Neo4j删除指定type的Feat节点及关联至req_id的节点与关系

Got it, let's work through this to safely remove only the subgraph you've marked (the blue region) without touching your valid data. Here's a step-by-step approach:

Step 1: First, Verify What You're Deleting (Critical!) #

Never delete without confirming you're targeting the right nodes and relationships. Run this query to preview exactly what will be removed:

MATCH path = (f:Feat {type: "ABC"})-[*]-(req:req_id)
RETURN DISTINCT nodes(path) AS target_nodes, relationships(path) AS target_relationships

This will list every node (including the ABC-type Feat, DR nodes, req_id nodes, and any intermediates) and relationship in the blue-marked subgraph. Double-check that none of your valid external data shows up here.

Step 2: Delete the Target Subgraph #

Once you've confirmed the selection, use this query to remove the subgraph. Neo4j requires deleting relationships first before deleting connected nodes, so we'll handle that in two stages:

// Match all paths from ABC-type Feat nodes to req_id nodes (captures all intermediates)
MATCH path = (f:Feat {type: "ABC"})-[*]-(req:req_id)
// Collect unique nodes and relationships to avoid duplicate processing
WITH collect(DISTINCT nodes(path)) AS targetNodes, collect(DISTINCT relationships(path)) AS targetRels
// Delete all relationships first
UNWIND targetRels AS rel
DELETE rel
// Now delete all the isolated target nodes
WITH targetNodes
UNWIND targetNodes AS node
DELETE node

Key Details: #

• The [*] pattern matches all-length paths from the ABC Feat nodes to req_id nodes, so it grabs every intermediate node (like DR) and relationship in between.
• Using DISTINCT ensures we don't waste time processing the same node/relationship multiple times if there are overlapping paths.
• If there are multiple Feat nodes with type: "ABC", this query handles all of them in one run.
• Any Feat nodes connected to your ABC Feat but not part of the path to req_id will stay untouched—they aren't included in the matched paths.

内容的提问来源于stack exchange，提问作者Rajat