Hi!
Try remove the , sign in the multiple operations (MERGE and CREATE) in the
FOREACH loop i.e
MERGE (allele:Allele:Locus
{contig:a.contig,lower:a.lower,upper:a.upper,pattern:a.pattern,lesion:a.lesion})
CREATE
(sd)-[:HAS_ALLELE]->(allele));"
Den måndagen den 31:e mars 2014 kl. 14:02:34 UTC+2 skrev Alex Frieden:
>
> Formatted poorly, arrow should be pointing to parenthesis immediately
> after FOREACH
>
> Neo.ClientError.Statement.InvalidSyntax, message:Invalid input '(':
> expected whitespace, comment, '=', node labels, MapLiteral, a parameter, a
> relationship pattern, ',', START, MATCH, MERGE, CREATE, SET, DELETE,
> REMOVE, FOREACH, WITH, RETURN, UNION, ';' or end of input (line 1, column
> 242)
> "MATCH (vcfFile:VcfFile {name:{_vcfFileName}}) MERGE (s:Sample
> {name:{sample}.name}) CREATE (vcfRecord {vcfRecord}),(sd:SampleData
> {sampleData}),(vcfRecord)-[:IN_FILE]->(vcfFile),(sd)-[:COMES_FROM]->(vcfRecord),(sample)-[:HAS]->(sd),
>
> FOREACH ( a in {alleles} | MERGE (allele:Allele:Locus
> {contig:a.contig,lower:a.lower,upper:a.upper,pattern:a.pattern,lesion:a.lesion}),CREATE
>
> (sd)-[:HAS_ALLELE]->(allele));"
>
>
>
> ^]]]
>
>
> On Mon, Mar 31, 2014 at 7:55 AM, Alex Frieden <[email protected]<javascript:>
> > wrote:
>
>> MATCH (vcfFile:VcfFile {name:{_vcfFileName}}) MERGE (s:Sample
>> {name:{sample}.name}) CREATE (vcfRecord {vcfRecord}),(sd:SampleData
>> {sampleData}),(vcfRecord)-[:IN_FILE]->(vcfFile),(sd)-[:COMES_FROM]->(vcfRecord),(sample)-[:HAS]->(sd),
>>
>> FOREACH ( a in {alleles} | MERGE (allele:Allele:Locus
>> {contig:a.contig,lower:a.lower,upper:a.upper,pattern:a.pattern,lesion:a.lesion}),CREATE
>>
>> (sd)-[:HAS_ALLELE]->(allele))
>>
>>
>>
>> errors:[[code:Neo.ClientError.Statement.InvalidSyntax, message:Invalid
>> input '(': expected whitespace, comment, '=', node labels, MapLiteral, a
>> parameter, a relationship pattern, ',', START, MATCH, MERGE, CREATE, SET,
>> DELETE, REMOVE, FOREACH, WITH, RETURN, UNION, ';' or end of input (line 1,
>> column 242)
>> "MATCH (vcfFile:VcfFile {name:{_vcfFileName}}) MERGE (s:Sample
>> {name:{sample}.name}) CREATE (vcfRecord {vcfRecord}),(sd:SampleData
>> {sampleData}),(vcfRecord)-[:IN_FILE]->(vcfFile),(sd)-[:COMES_FROM]->(vcfRecord),(sample)-[:HAS]->(sd),
>>
>> FOREACH ( a in {alleles} | MERGE (allele:Allele:Locus
>> {contig:a.contig,lower:a.lower,upper:a.upper,pattern:a.pattern,lesion:a.lesion}),CREATE
>>
>> (sd)-[:HAS_ALLELE]->(allele))"
>> ^]]]
>>
>>
>> What is the source of this error? Thanks!
>>
>>
>> --
>> 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.
>>
>
>
>
> --
> Alexander Frieden
>
>
--
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.
