Issue 1:
I want to import data in csv file into neo4j with the following command:

../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

there are about 2billion nodes and 10billion edges in the csv file.

but i get the error like:

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.01B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.03B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.04B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.06B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.08B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.09B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.11B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.13B

[*RESOLVE (82 collisions):61.19 GB------------------------------------------------------------]2.14BException in thread "Thread-1302" java.lan

g.IllegalArgumentException: Collision in source with too many lines (-2143568315)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)

at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)

at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)

Import error: Collision in source with too many lines (-2143568315)

Caused by:Collision in source with too many lines (-2143568315)

java.lang.IllegalArgumentException: Collision in source with too many lines (-2143568315)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)

at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)

at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)

Input error: Collision in source with too many lines (-2143568315)

Caused by:Collision in source with too many lines (-2143568315)

java.lang.IllegalArgumentException: Collision in source with too many lines (-2143568315)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.SourceInformation.encodeSourceInformation(SourceInformation.java:52)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.buildCollisionInfo(EncodingIdMapper.java:486)

at org.neo4j.unsafe.impl.batchimport.cache.idmapping.string.EncodingIdMapper.prepare(EncodingIdMapper.java:282)

at org.neo4j.unsafe.impl.batchimport.IdMapperPreparationStep.process(IdMapperPreparationStep.java:54)

at org.neo4j.unsafe.impl.batchimport.staging.LonelyProcessingStep$1.run(LonelyProcessingStep.java:56)

Neo4j version: 3.1.2 community

Operating system: linux

is this a bug when there are too many nodes or edges?

Issue 2:
Strange behavior of aggregations, aliased in WITH clause

Neo4j Version: 3.4.0

Operating System: Fedora 26

Hello!

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.

I have the following node setup in Neo4j:

Steps to reproduce

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

Expected behavior

y.name
_count1
_count2

"x"
1
3

Actual behavior

y.name
_count1
_count2

"x"
1
1

"x"
1
1

"x"
1
1

However, when I use COUNT(...) functions in the RETURN statement instead of the _count1 and _count2 aliases from the WITH clause as follows:

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)

the results show as expected:

y.name
COUNT(DISTINCT y)
COUNT(DISTINCT p)

"x"
1
3

So far I haven't found anything in the documentation or related issues. Am I missing something?

I'd appreciate any help regarding this.