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 <[email protected]>:
>
> 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
> <http://jexp.de/blog/2014/06/load-csv-into-neo4j-quickly-and-successfully/>
> 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
> <https://gist.github.com/sunitj/1634bdc13c93c26ca018>
> Cypher Query: https://gist.github.com/sunitj/4a47fa3a9eac226ba190
> <https://gist.github.com/sunitj/4a47fa3a9eac226ba190>
> Error Stack Trace: https://gist.github.com/sunitj/44ae12b29fcd6351cc74
> <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 [email protected]
> <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
