I was able to correct it. Thanks!
On Friday, March 13, 2015 at 5:04:51 PM UTC-4, Michael Hunger wrote:
>
> 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] <javascript:>
> >:
>
> 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
> 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 [email protected] <javascript:>.
> For more options, visit 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.
