Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
12-05-2020 08:02 AM
Hey! I have asked this same question in the other topic but I suppose replies to other topics are not as visible as a standalone question and I am kind of lost here.
I am running a locally deployed Kubernetes Neo4j cluster with 3 cores and 3 replicas. I copied my .csv files with docker cp command to /var/lib/neo4j/import inside of core 0 docker container. Then I go to the CLI and start cypher-shell:
> pwd
/var/lib/neo4j/import # the import folder
> ls
USAir_edges.csv USAir_nodes.csv # so my files are here
> cypher-shell
Connected to Neo4j 4.2.0 at neo4j://localhost:7687.
Type :help for a list of available commands or :exit to exit the shell.
Note that Cypher queries must end with a semicolon.
@neo4j> load csv with headers from 'file:///USAir_nodes.csv' as row
create (n:Node {id: toInteger(row.id)});
# the error I get:
Couldn't load the external resource at: file:/var/lib/neo4j/import/USAir_nodes.csv
I do not quite get why it can't be loaded and why the resource is "external" in this case.. Could you take a look at the issue please?
12-06-2020 06:19 AM
I did manage to load the data to my Kubernetes cluster after all:
dbms.security.allow_csv_import_from_file_urls=true
> cypher-shell
Connected to Neo4j 4.2.0 at neo4j://localhost:7687.
Type :help for a list of available commands or :exit to exit the shell.
Note that Cypher queries must end with a semicolon.
@neo4j> load csv with headers from 'https://my-content-url.com/USAir_nodes.csv' as row
create (n:Node {id: toInteger(row.id)});
# Added 332 nodes, Set 332 properties, Added 332 labels
All the sessions of the conference are now available online