Re: [Neo4j] LOAD CSV: Ignore missing values.

[Michael Hunger]

you have to be careful with typos:

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'file:/Users/sunitj/Neo4j/IMG/Staging/multiGene_scaffold_testRun2.tsv' AS line FIELDTERMINATOR '\t'
WITH line
WHERE line.Sci_Name IS NOT NULL
....	
MERGE (org: Organism {name:LOWER(line.SciName)})

the header column is actually line.Sci_Name with an underscore

Am 13.03.2015 um 15:57 schrieb Sunit Jain <sun...@umich.edu>:

Hi

I'm trying to load a tab-delimited data set with some missing values to a neo4j database. I tried following Mike Hunger's blog on "LOAD CSV into Neo4j quickly and successfully", but I still get the following error:

LoadCsvStatusWrapCypherException: Cannot merge node using null property value for name (Failure when processing URL 'file:/Users/sunitj/Neo4j/IMG/Staging/multiGene_scaffold_testRun2.tsv' on line 2. No rows seem to have been committed. Note that this information might not be accurate.)

Sample Data: https://gist.github.com/sunitj/1634bdc13c93c26ca018

Cypher Query: https://gist.github.com/sunitj/4a47fa3a9eac226ba190

Error Stack Trace: https://gist.github.com/sunitj/44ae12b29fcd6351cc74

Any ideas what I might be doing wrong?

---------------------------

Mac OS X 10.10.2

RAM: 20GB

Intel core i7 processor

Neo4j v2.1.7

JVM 1.8

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sunit Jain]

I was able to correct it. Thanks!