<p dir="auto">I want to import data in csv file into neo4j with the following command:<br>
../bin/neo4j-import --into ../data/databases/entity.db --nodes:Entity "nodes_header.csv,node.csv" --relationships:RELE "edges_header.csv,edge.csv" --multiline-fields=true --bad-tolerance 100000000 --stacktrace true --skip-duplicate-nodes true<br>
there are about 2billion nodes and 10billion edges in the csv file.</p>
<p dir="auto">but i get the error like:</p>
<p dir="auto">[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.01B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.03B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.04B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.06B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.08B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.09B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.11B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.13B<br>
[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.14BException in thread "Thread-1302" java.lan<br>
g.IllegalArgumentException: Collision in source with too many lines (-2143568315)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)<br>
at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)<br>
at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)<br>
Import error: Collision in source with too many lines (-2143568315)<br>
Caused by:Collision in source with too many lines (-2143568315)<br>
java.lang.IllegalArgumentException: Collision in source with too many lines (-2143568315)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)<br>
at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)<br>
at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)</p>
<p dir="auto">Input error: Collision in source with too many lines (-2143568315)<br>
Caused by:Collision in source with too many lines (-2143568315)<br>
java.lang.IllegalArgumentException: Collision in source with too many lines (-2143568315)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)<br>
at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)<br>
at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)<br>
at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)</p>
<p dir="auto">Neo4j version: 3.1.2 community<br>
Operating system: linux</p>
<p dir="auto">is this a bug when there are too many nodes or edges?</p>
<h2 dir="auto">Strange behavior of aggregations, aliased in WITH clause</h2>
<p dir="auto"><strong>Neo4j Version:</strong> 3.4.0<br>
<strong>Operating System:</strong> Fedora 26</p>
<p dir="auto">Hello!</p>
<p dir="auto">I've been using Neo4j for quite a while, and noticed some strange behavior regarding aggregations, aliased in the WITH clause of the Cypher query.</p>
<p dir="auto">I have the following node setup in Neo4j:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/6199897/50238039-0e9c2480-03c7-11e9-8c71-2dbcb16415cb.png"><img src="https://user-images.githubusercontent.com/6199897/50238039-0e9c2480-03c7-11e9-8c71-2dbcb16415cb.png" alt="image" style="max-width: 100%;"></a></p>
<h3 dir="auto">Steps to reproduce</h3>
<div class="highlight highlight-source-cypher notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="MATCH (g:Grey)-[:TypeRel3]-(y:Yellow)-[:TypeRel1]-(p:Pink)
WITH g, y, p, COUNT(DISTINCT y) as _count1, COUNT(DISTINCT p) as _count2
RETURN y.name, _count1, _count2"><pre class="notranslate"><span class="pl-k">MATCH</span> (<span class="pl-smi">g</span>:<span class="pl-smi">Grey</span>)<span class="pl-c1">-</span><span class="pl-k">[</span><span class="pl-en"><span class="pl-k">:</span><span class="pl-en">TypeRel3</span></span><span class="pl-k">]</span><span class="pl-c1">-</span>(<span class="pl-smi">y</span>:<span class="pl-smi">Yellow</span>)<span class="pl-c1">-</span><span class="pl-k">[</span><span class="pl-en"><span class="pl-k">:</span><span class="pl-en">TypeRel1</span></span><span class="pl-k">]</span><span class="pl-c1">-</span>(<span class="pl-smi">p</span>:<span class="pl-smi">Pink</span>)
<span class="pl-k">WITH</span> <span class="pl-smi">g</span>, <span class="pl-smi">y</span>, <span class="pl-smi">p</span>, <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">y</span>) <span class="pl-k">as</span> <span class="pl-smi">_count1</span>, <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">p</span>) <span class="pl-k">as</span> <span class="pl-smi">_count2</span>
<span class="pl-k">RETURN</span> <span class="pl-smi">y</span>.<span class="pl-smi">name</span>, <span class="pl-smi">_count1</span>, <span class="pl-smi">_count2</span></pre></div>
<h3 dir="auto">Expected behavior</h3>
<table role="table">
<thead>
<tr>
<th>y.name</th>
<th align="center">_count1</th>
<th align="right">_count2</th>
</tr>
</thead>
<tbody>
<tr>
<td>"x"</td>
<td align="center">1</td>
<td align="right">3</td>
</tr>
</tbody>
</table>
<h3 dir="auto">Actual behavior</h3>
<table role="table">
<thead>
<tr>
<th>y.name</th>
<th align="center">_count1</th>
<th align="right">_count2</th>
</tr>
</thead>
<tbody>
<tr>
<td>"x"</td>
<td align="center">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>"x"</td>
<td align="center">1</td>
<td align="right">1</td>
</tr>
<tr>
<td>"x"</td>
<td align="center">1</td>
<td align="right">1</td>
</tr>
</tbody>
</table>
<p dir="auto">However, when I use <code class="notranslate">COUNT(...)</code> functions in the <code class="notranslate">RETURN</code> statement instead of the <code class="notranslate">_count1</code> and <code class="notranslate">_count2</code> aliases from the <code class="notranslate">WITH</code> clause as follows:</p>
<div class="highlight highlight-source-cypher notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="MATCH (g:Grey)-[:TypeRel3]-(y:Yellow)-[:TypeRel1]-(p:Pink)
WITH g, y, p, COUNT(DISTINCT y) as _count1, COUNT(DISTINCT p) as _count2
RETURN y.name, COUNT(DISTINCT y), COUNT(DISTINCT p)"><pre class="notranslate"><span class="pl-k">MATCH</span> (<span class="pl-smi">g</span>:<span class="pl-smi">Grey</span>)<span class="pl-c1">-</span><span class="pl-k">[</span><span class="pl-en"><span class="pl-k">:</span><span class="pl-en">TypeRel3</span></span><span class="pl-k">]</span><span class="pl-c1">-</span>(<span class="pl-smi">y</span>:<span class="pl-smi">Yellow</span>)<span class="pl-c1">-</span><span class="pl-k">[</span><span class="pl-en"><span class="pl-k">:</span><span class="pl-en">TypeRel1</span></span><span class="pl-k">]</span><span class="pl-c1">-</span>(<span class="pl-smi">p</span>:<span class="pl-smi">Pink</span>)
<span class="pl-k">WITH</span> <span class="pl-smi">g</span>, <span class="pl-smi">y</span>, <span class="pl-smi">p</span>, <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">y</span>) <span class="pl-k">as</span> <span class="pl-smi">_count1</span>, <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">p</span>) <span class="pl-k">as</span> <span class="pl-smi">_count2</span>
<span class="pl-k">RETURN</span> <span class="pl-smi">y</span>.<span class="pl-smi">name</span>, <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">y</span>), <span class="pl-c1">COUNT</span>(<span class="pl-k">DISTINCT</span> <span class="pl-smi">p</span>)</pre></div>
<p dir="auto">the results show  as expected:</p>
<table role="table">
<thead>
<tr>
<th>y.name</th>
<th align="center">COUNT(DISTINCT y)</th>
<th align="right">COUNT(DISTINCT p)</th>
</tr>
</thead>
<tbody>
<tr>
<td>"x"</td>
<td align="center">1</td>
<td align="right">3</td>
</tr>
</tbody>
</table>
<p dir="auto">So far I haven't found anything in the documentation or related issues. Am I missing something?<br>
I'd appreciate any help regarding this.</p>