<p dir="auto">In the example below, the FILTER operation applied to paths does not return a correct result. Or am I getting it wrong?</p>
<p dir="auto"><strong>Neo4j Version:</strong> 3.0.4<br>
<strong>Operating System:</strong> Windows 10<br>
<strong>API:</strong> Browser (Google Chrome) / Cypher</p>
<h3 dir="auto">Steps to reproduce</h3>
<ol dir="auto">
<li>
<p dir="auto">Create the graph "SIL" with the Cypher script below. This represents a subset inclusion lattice with the basic sets a,b,c,d,e,f. The lattice has 63 nodes and 186 relationships (the empty set is omitted from the lattice)</p>
</li>
<li>
<p dir="auto">Compute the complement of the :abcd sub-lattice with:</p>
<p dir="auto">// All nodes and relationships in the lattice<br>
MATCH n=(:abcdef)--&gt;(l01)--&gt;(l02)--&gt;(l03)--&gt;(l04)--&gt;(l05)<br>
// All nodes in the downset of :abcd<br>
MATCH p=(:abcd)--&gt;(l11)--&gt;(l12)--&gt;(l13)<br>
// Get those nodes that are not in the downset of :abcd<br>
RETURN FILTER (x IN nodes(n) WHERE NOT (x IN nodes(p)))</p>
</li>
</ol>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Return all nodes and relationships that do not belong to the :abcd sub-lattice</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">All nodes except the upper bound of the complete lattice (:abcdef) and their relationships are returned. The computation takes on the order of a minute on a Lenovo T400s.</p>
<h3 dir="auto">Cypher statements to create "SIL"</h3>
<p dir="auto">// All n = 6 elements in one set<br>
Create (abcdef:abcdef {headline:'a,b,c,d,e,f'})</p>
<p dir="auto">// n-1 = 5 elements per set<br>
Create (bcdef:bcdef {headline:'b,c,d,e,f'})<br>
Create (acdef:acdef {headline:'a,c,d,e,f'})<br>
Create (abdef:abdef {headline:'a,b,d,e,f'})<br>
Create (abcef:abcef {headline:'a,b,c,e,f'})<br>
Create (abcdf:abcdf {headline:'a,b,c,d,f'})<br>
Create (abcde:abcde {headline:'a,b,c,d,e'})<br>
// superset relationships level 6 - level 5<br>
CREATE (abcdef) - [:superset] -&gt;(bcdef)<br>
CREATE (abcdef) - [:superset] -&gt;(acdef)<br>
CREATE (abcdef) - [:superset] -&gt;(abdef)<br>
CREATE (abcdef) - [:superset] -&gt;(abcef)<br>
CREATE (abcdef) - [:superset] -&gt;(abcdf)<br>
CREATE (abcdef) - [:superset] -&gt;(abcde)</p>
<p dir="auto">// n-2 = 4 elements per set<br>
Create (cdef:cdef {headline:'c,d,e,f'})<br>
Create (bdef:bdef {headline:'b,d,e,f'})<br>
Create (bcef:bcef {headline:'b,c,e,f'})<br>
Create (bcdf:bcdf {headline:'b,c,d,f'})<br>
Create (bcde:bcde {headline:'b,c,d,e'})<br>
Create (adef:adef {headline:'a,d,e,f'})<br>
Create (acef:acef {headline:'a,c,e,f'})<br>
Create (acdf:acdf {headline:'a,c,d,f'})<br>
Create (acde:acde {headline:'a,c,d,e'})<br>
Create (abef:abef {headline:'a,b,e,f'})<br>
Create (abdf:abdf {headline:'a,b,d,f'})<br>
Create (abde:abde {headline:'a,b,d,e'})<br>
Create (abcf:abcf {headline:'a,b,c,f'})<br>
Create (abce:abce {headline:'a,b,c,e'})<br>
Create (abcd:abcd {headline:'a,b,c,d'})<br>
// superset relationships level 5 to level 4<br>
CREATE (bcdef) - [:superset] -&gt;(cdef)<br>
CREATE (bcdef) - [:superset] -&gt;(bdef)<br>
CREATE (bcdef) - [:superset] -&gt;(bcef)<br>
CREATE (bcdef) - [:superset] -&gt;(bcdf)<br>
CREATE (bcdef) - [:superset] -&gt;(bcde)<br>
CREATE (acdef) - [:superset] -&gt;(cdef)<br>
CREATE (acdef) - [:superset] -&gt;(adef)<br>
CREATE (acdef) - [:superset] -&gt;(acef)<br>
CREATE (acdef) - [:superset] -&gt;(acdf)<br>
CREATE (acdef) - [:superset] -&gt;(acde)<br>
CREATE (abdef) - [:superset] -&gt;(bdef)<br>
CREATE (abdef) - [:superset] -&gt;(adef)<br>
CREATE (abdef) - [:superset] -&gt;(abef)<br>
CREATE (abdef) - [:superset] -&gt;(abdf)<br>
CREATE (abdef) - [:superset] -&gt;(abde)<br>
CREATE (abcef) - [:superset] -&gt;(bcef)<br>
CREATE (abcef) - [:superset] -&gt;(acef)<br>
CREATE (abcef) - [:superset] -&gt;(abef)<br>
CREATE (abcef) - [:superset] -&gt;(abcf)<br>
CREATE (abcef) - [:superset] -&gt;(abce)<br>
CREATE (abcdf) - [:superset] -&gt;(bcdf)<br>
CREATE (abcdf) - [:superset] -&gt;(acdf)<br>
CREATE (abcdf) - [:superset] -&gt;(abdf)<br>
CREATE (abcdf) - [:superset] -&gt;(abcf)<br>
CREATE (abcdf) - [:superset] -&gt;(abcd)<br>
CREATE (abcde) - [:superset] -&gt;(bcde)<br>
CREATE (abcde) - [:superset] -&gt;(acde)<br>
CREATE (abcde) - [:superset] -&gt;(abde)<br>
CREATE (abcde) - [:superset] -&gt;(abce)<br>
CREATE (abcde) - [:superset] -&gt;(abcd)</p>
<p dir="auto">// n-3 = 3 elements per set<br>
Create (def:def {headline:'d,e,f'})<br>
Create (cef:cef {headline:'c,e,f'})<br>
Create (cdf:cdf {headline:'c,d,f'})<br>
Create (cde:cde {headline:'c,d,e'})<br>
Create (bef:bef {headline:'b,e,f'})<br>
Create (bdf:bdf {headline:'b,d,f'})<br>
Create (bde:bde {headline:'b,d,e'})<br>
Create (bcf:bcf {headline:'b,c,f'})<br>
Create (bce:bce {headline:'b,c,e'})<br>
Create (bcd:bcd {headline:'b,c,d'})<br>
Create (aef:aef {headline:'a,e,f'})<br>
Create (adf:adf {headline:'a,d,f'})<br>
Create (ade:ade {headline:'a,d,e'})<br>
Create (acf:acf {headline:'a,c,f'})<br>
Create (ace:ace {headline:'a,c,e'})<br>
Create (acd:acd {headline:'a,c,d'})<br>
Create (abf:abf {headline:'a,b,f'})<br>
Create (abe:abe {headline:'a,b,e'})<br>
Create (abd:abd {headline:'a,b,d'})<br>
Create (abc:abc {headline:'a,b,c'})<br>
// superset relationships level 4 to level 3<br>
Create (cdef) - [:superset] -&gt;(def)<br>
Create (cdef) - [:superset] -&gt;(cef)<br>
Create (cdef) - [:superset] -&gt;(cdf)<br>
Create (cdef) - [:superset] -&gt;(cde)<br>
Create (bdef) - [:superset] -&gt;(def)<br>
Create (bdef) - [:superset] -&gt;(bef)<br>
Create (bdef) - [:superset] -&gt;(bdf)<br>
Create (bdef) - [:superset] -&gt;(bde)<br>
Create (bcef) - [:superset] -&gt;(cef)<br>
Create (bcef) - [:superset] -&gt;(bef)<br>
Create (bcef) - [:superset] -&gt;(bcf)<br>
Create (bcef) - [:superset] -&gt;(bce)<br>
Create (bcdf) - [:superset] -&gt;(cdf)<br>
Create (bcdf) - [:superset] -&gt;(bdf)<br>
Create (bcdf) - [:superset] -&gt;(bcf)<br>
Create (bcdf) - [:superset] -&gt;(bcd)<br>
Create (bcde) - [:superset] -&gt;(cde)<br>
Create (bcde) - [:superset] -&gt;(bde)<br>
Create (bcde) - [:superset] -&gt;(bce)<br>
Create (bcde) - [:superset] -&gt;(bcd)<br>
Create (adef) - [:superset] -&gt;(def)<br>
Create (adef) - [:superset] -&gt;(aef)<br>
Create (adef) - [:superset] -&gt;(adf)<br>
Create (adef) - [:superset] -&gt;(ade)<br>
Create (acef) - [:superset] -&gt;(cef)<br>
Create (acef) - [:superset] -&gt;(aef)<br>
Create (acef) - [:superset] -&gt;(acf)<br>
Create (acef) - [:superset] -&gt;(ace)<br>
Create (acdf) - [:superset] -&gt;(cdf)<br>
Create (acdf) - [:superset] -&gt;(adf)<br>
Create (acdf) - [:superset] -&gt;(acf)<br>
Create (acdf) - [:superset] -&gt;(acd)<br>
Create (acde) - [:superset] -&gt;(cde)<br>
Create (acde) - [:superset] -&gt;(ade)<br>
Create (acde) - [:superset] -&gt;(ace)<br>
Create (acde) - [:superset] -&gt;(acd)<br>
Create (abef) - [:superset] -&gt;(bef)<br>
Create (abef) - [:superset] -&gt;(aef)<br>
Create (abef) - [:superset] -&gt;(abf)<br>
Create (abef) - [:superset] -&gt;(abe)<br>
Create (abdf) - [:superset] -&gt;(bdf)<br>
Create (abdf) - [:superset] -&gt;(adf)<br>
Create (abdf) - [:superset] -&gt;(abf)<br>
Create (abdf) - [:superset] -&gt;(abd)<br>
Create (abde) - [:superset] -&gt;(bde)<br>
Create (abde) - [:superset] -&gt;(ade)<br>
Create (abde) - [:superset] -&gt;(abe)<br>
Create (abde) - [:superset] -&gt;(abd)<br>
Create (abcf) - [:superset] -&gt;(bcf)<br>
Create (abcf) - [:superset] -&gt;(acf)<br>
Create (abcf) - [:superset] -&gt;(abf)<br>
Create (abcf) - [:superset] -&gt;(abc)<br>
Create (abce) - [:superset] -&gt;(bce)<br>
Create (abce) - [:superset] -&gt;(ace)<br>
Create (abce) - [:superset] -&gt;(abe)<br>
Create (abce) - [:superset] -&gt;(abc)<br>
Create (abcd) - [:superset] -&gt;(bcd)<br>
Create (abcd) - [:superset] -&gt;(acd)<br>
Create (abcd) - [:superset] -&gt;(abd)<br>
Create (abcd) - [:superset] -&gt;(abc)</p>
<p dir="auto">// n-4 = 2 elements per set<br>
Create (ef:ef {headline:'e,f'})<br>
Create (df:df {headline:'d,f'})<br>
Create (de:de {headline:'d,e'})<br>
Create (cf:cf {headline:'c,f'})<br>
Create (ce:ce {headline:'c,e'})<br>
Create (cd:cd {headline:'c,d'})<br>
Create (bf:bf {headline:'b,f'})<br>
Create (be:be {headline:'b,e'})<br>
Create (bd:bd {headline:'b,d'})<br>
Create (bc:bc {headline:'b,c'})<br>
Create (af:af {headline:'a,f'})<br>
Create (ae:ae {headline:'a,e'})<br>
Create (ad:ad {headline:'a,d'})<br>
Create (ac:ac {headline:'a,c'})<br>
Create (ab:ab {headline:'a,b'})<br>
// Superset relationships level 3 to level 2<br>
Create (def) - [:superset] -&gt; (ef)<br>
Create (def) - [:superset] -&gt; (df)<br>
Create (def) - [:superset] -&gt; (de)<br>
Create (cef) - [:superset] -&gt; (ef)<br>
Create (cef) - [:superset] -&gt; (cf)<br>
Create (cef) - [:superset] -&gt; (ce)<br>
Create (cdf) - [:superset] -&gt; (df)<br>
Create (cdf) - [:superset] -&gt; (cf)<br>
Create (cdf) - [:superset] -&gt; (cd)<br>
Create (cde) - [:superset] -&gt; (de)<br>
Create (cde) - [:superset] -&gt; (ce)<br>
Create (cde) - [:superset] -&gt; (cd)<br>
Create (bef) - [:superset] -&gt; (ef)<br>
Create (bef) - [:superset] -&gt; (bf)<br>
Create (bef) - [:superset] -&gt; (be)<br>
Create (bdf) - [:superset] -&gt; (df)<br>
Create (bdf) - [:superset] -&gt; (bf)<br>
Create (bdf) - [:superset] -&gt; (bd)<br>
Create (bde) - [:superset] -&gt; (de)<br>
Create (bde) - [:superset] -&gt; (be)<br>
Create (bde) - [:superset] -&gt; (bd)<br>
Create (bcf) - [:superset] -&gt; (cf)<br>
Create (bcf) - [:superset] -&gt; (bf)<br>
Create (bcf) - [:superset] -&gt; (bc)<br>
Create (bce) - [:superset] -&gt; (ce)<br>
Create (bce) - [:superset] -&gt; (be)<br>
Create (bce) - [:superset] -&gt; (bc)<br>
Create (bcd) - [:superset] -&gt; (cd)<br>
Create (bcd) - [:superset] -&gt; (bd)<br>
Create (bcd) - [:superset] -&gt; (bc)<br>
Create (aef) - [:superset] -&gt; (ef)<br>
Create (aef) - [:superset] -&gt; (af)<br>
Create (aef) - [:superset] -&gt; (ae)<br>
Create (adf) - [:superset] -&gt; (df)<br>
Create (adf) - [:superset] -&gt; (af)<br>
Create (adf) - [:superset] -&gt; (ad)<br>
Create (ade) - [:superset] -&gt; (de)<br>
Create (ade) - [:superset] -&gt; (ae)<br>
Create (ade) - [:superset] -&gt; (ad)<br>
Create (acf) - [:superset] -&gt; (cf)<br>
Create (acf) - [:superset] -&gt; (af)<br>
Create (acf) - [:superset] -&gt; (ac)<br>
Create (ace) - [:superset] -&gt; (ce)<br>
Create (ace) - [:superset] -&gt; (ae)<br>
Create (ace) - [:superset] -&gt; (ac)<br>
Create (acd) - [:superset] -&gt; (cd)<br>
Create (acd) - [:superset] -&gt; (ad)<br>
Create (acd) - [:superset] -&gt; (ac)<br>
Create (abf) - [:superset] -&gt; (bf)<br>
Create (abf) - [:superset] -&gt; (af)<br>
Create (abf) - [:superset] -&gt; (ab)<br>
Create (abe) - [:superset] -&gt; (be)<br>
Create (abe) - [:superset] -&gt; (ae)<br>
Create (abe) - [:superset] -&gt; (ab)<br>
Create (abd) - [:superset] -&gt; (bd)<br>
Create (abd) - [:superset] -&gt; (ad)<br>
Create (abd) - [:superset] -&gt; (ab)<br>
Create (abc) - [:superset] -&gt; (bc)<br>
Create (abc) - [:superset] -&gt; (ac)<br>
Create (abc) - [:superset] -&gt; (ab)</p>
<p dir="auto">// n-(n-1) = 1 element per set<br>
Create (a:a {headline:'a'})<br>
Create (b:b {headline:'b'})<br>
Create (c:c {headline:'c'})<br>
Create (d:d {headline:'d'})<br>
Create (e:e {headline:'e'})<br>
Create (f:f {headline:'f'})<br>
// Superset relationships level 3 to level 2<br>
Create (ef) - [:superset] -&gt; (f)<br>
Create (ef) - [:superset] -&gt; (e)<br>
Create (df) - [:superset] -&gt; (f)<br>
Create (df) - [:superset] -&gt; (d)<br>
Create (de) - [:superset] -&gt; (e)<br>
Create (de) - [:superset] -&gt; (d)<br>
Create (cf) - [:superset] -&gt; (f)<br>
Create (cf) - [:superset] -&gt; (c)<br>
Create (ce) - [:superset] -&gt; (e)<br>
Create (ce) - [:superset] -&gt; (c)<br>
Create (cd) - [:superset] -&gt; (d)<br>
Create (cd) - [:superset] -&gt; (c)<br>
Create (bf) - [:superset] -&gt; (f)<br>
Create (bf) - [:superset] -&gt; (b)<br>
Create (be) - [:superset] -&gt; (e)<br>
Create (be) - [:superset] -&gt; (b)<br>
Create (bd) - [:superset] -&gt; (d)<br>
Create (bd) - [:superset] -&gt; (b)<br>
Create (bc) - [:superset] -&gt; (c)<br>
Create (bc) - [:superset] -&gt; (b)<br>
Create (af) - [:superset] -&gt; (f)<br>
Create (af) - [:superset] -&gt; (a)<br>
Create (ae) - [:superset] -&gt; (e)<br>
Create (ae) - [:superset] -&gt; (a)<br>
Create (ad) - [:superset] -&gt; (d)<br>
Create (ad) - [:superset] -&gt; (a)<br>
Create (ac) - [:superset] -&gt; (c)<br>
Create (ac) - [:superset] -&gt; (a)<br>
Create (ab) - [:superset] -&gt; (b)<br>
Create (ab) - [:superset] -&gt; (a)</p>
<ul dir="auto">
<li>Neo4j version: 3.5.4</li>
<li>Operating system: debian-9-x86</li>
<li>API/Driver: neo4j-admin</li>
<li><strong>Steps to reproduce</strong><br>
Try to import 30GB(after zipped) csv data to fresh installed neo4j,<br>
command i ran:</li>
</ul>
<div class="highlight highlight-source-shell notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="sudo -u neo4j /opt/bitnami/neo4j/bin/neo4j-admin import \
--nodes:Group=&quot;header_group.csv,groups.*.zip&quot; \
--nodes:Person=&quot;header_person.csv,people.*.zip&quot; \
--relationships:IN_GROUP=&quot;header_ingroup.csv,people.*.zip&quot; \
--input-encoding=&quot;UTF-16LE&quot; --ignore-duplicate-nodes --ignore-missing-nodes  --delimiter=&quot;\t&quot;"><pre class="notranslate">sudo -u neo4j /opt/bitnami/neo4j/bin/neo4j-admin import \
--nodes:Group=<span class="pl-s"><span class="pl-pds">"</span>header_group.csv,groups.*.zip<span class="pl-pds">"</span></span> \
--nodes:Person=<span class="pl-s"><span class="pl-pds">"</span>header_person.csv,people.*.zip<span class="pl-pds">"</span></span> \
--relationships:IN_GROUP=<span class="pl-s"><span class="pl-pds">"</span>header_ingroup.csv,people.*.zip<span class="pl-pds">"</span></span> \
--input-encoding=<span class="pl-s"><span class="pl-pds">"</span>UTF-16LE<span class="pl-pds">"</span></span> --ignore-duplicate-nodes --ignore-missing-nodes  --delimiter=<span class="pl-s"><span class="pl-pds">"</span>\t<span class="pl-pds">"</span></span></pre></div>
<p dir="auto">nodes import done in 30 minutes, but then the command stuck on this 'Prepare node index'stage for 2 days already:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="
        ******** DETAILS 2019-04-13 19:11:19.799+0000 ********
        Nodes
        [*Nodes---------------------------------------------------------------------------------------]1.53B
        Memory usage: 12.45 GB
        I/O throughput: 72.87 MB/s
        Duration: 35m 41s 667ms
        Done batches: 153631
        Prepare node index
        [*SORT----------------------------------------------------------------------------------------]7.33B
        Memory usage: 123.34 GB
        VM stop-the-world time: 2s 23ms
        Duration: 2d 5h 25m 29s 892ms
        Done batches: 733092
        Environment information:
          Free physical memory: 219.49 MB
          Max VM memory: 17.78 GB
          Free VM memory: 73.79 MB
          VM stop-the-world time: 2s 23ms
          Duration: 2d 6h 1m 11s 559ms"><pre class="notranslate"><code class="notranslate">
        ******** DETAILS 2019-04-13 19:11:19.799+0000 ********
        Nodes
        [*Nodes---------------------------------------------------------------------------------------]1.53B
        Memory usage: 12.45 GB
        I/O throughput: 72.87 MB/s
        Duration: 35m 41s 667ms
        Done batches: 153631
        Prepare node index
        [*SORT----------------------------------------------------------------------------------------]7.33B
        Memory usage: 123.34 GB
        VM stop-the-world time: 2s 23ms
        Duration: 2d 5h 25m 29s 892ms
        Done batches: 733092
        Environment information:
          Free physical memory: 219.49 MB
          Max VM memory: 17.78 GB
          Free VM memory: 73.79 MB
          VM stop-the-world time: 2s 23ms
          Duration: 2d 6h 1m 11s 559ms
</code></pre></div>
<p dir="auto">some sample data:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="// header_group.csv
:IGNORE	QunNum:ID(Group-ID)	MastQQ:int	CreateDate:date	Title	Class	QunText

groups node:

78	100263	19	2002-08-31	BTBBS	0	btbbs.3322.org
79	100264	1	2002-08-31	1	0	1
80	100265	1	2002-08-31	1	0	1
81	100269	11	2002-08-31	★顺网论坛内务群★	3126	

// header_person.csv
:IGNORE	QQNum:ID(Person-ID)	:IGNORE	:IGNORE	:IGNORE	:IGNORE	:IGNORE

// header_ingroup.csv
:IGNORE	:START_ID(Person-ID)	Nick	Age:int	Gender:int	Auth:int	:END_ID(Group-ID)

person nodes:
2	32507773	黄璘	105	1	2	100100
3	389737625	niki	26	1	3	100100
4	10095	Paul	31	0	2	100100
5	795019031	一二三四五六	2	0	1	100100
6	251000782	赵耀	33	0	1	100100"><pre class="notranslate"><code class="notranslate">// header_group.csv
:IGNORE	QunNum:ID(Group-ID)	MastQQ:int	CreateDate:date	Title	Class	QunText

groups node:

78	100263	19	2002-08-31	BTBBS	0	btbbs.3322.org
79	100264	1	2002-08-31	1	0	1
80	100265	1	2002-08-31	1	0	1
81	100269	11	2002-08-31	★顺网论坛内务群★	3126	

// header_person.csv
:IGNORE	QQNum:ID(Person-ID)	:IGNORE	:IGNORE	:IGNORE	:IGNORE	:IGNORE

// header_ingroup.csv
:IGNORE	:START_ID(Person-ID)	Nick	Age:int	Gender:int	Auth:int	:END_ID(Group-ID)

person nodes:
2	32507773	黄璘	105	1	2	100100
3	389737625	niki	26	1	3	100100
4	10095	Paul	31	0	2	100100
5	795019031	一二三四五六	2	0	1	100100
6	251000782	赵耀	33	0	1	100100
</code></pre></div>
<p dir="auto">those csv files are generate from a SQL database, as you can see both Person nodes and the IN_GROUP using same set of csv data. There are some node id is duplicated, that's why i put <code class="notranslate">--ignore-duplicate-nodes --ignore-missing-nodes</code> options in there.</p>
<p dir="auto">Please help!</p>