When I tried to submit my graphgist, I got the following error on LOAD
CSV. (Neo4j 3.1.0):
Invalid input '(': expected an identifier character, whitespace, '?', '!',
'.', node labels, '[', "=~", IN, STARTS, ENDS, CONTAINS, IS, '^', '*', '/',
'%', '+', '-', '=', "<>", "!=", '<', '>', "<=", ">=", AND, XOR, OR, AS,
',', ORDER, SKIP, LIMIT, WHERE, LOAD CSV, START, MATCH, UNWIND, MERGE,
CREATE, SET, DELETE, REMOVE, FOREACH, WITH, RETURN, ';' or end of input
(line 3, column 28 (offset: 106))
"WITH line, apoc.date.format((ToInteger(line.TME)),('s'), ('yyyy/MM/dd'),
('PST')) as dates"
Here is my script:
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM
"https://github.com/kaisesha/cdrgraph/blob/master/CDR_Gist3.csv"; As line
WITH line, apoc.date.format((ToInteger(line.TME)),('s'), ('yyyy/MM/dd'),
('PST')) as dates
WITH line, dates, REPLACE(dates, "/", "") as dt
This works:
LOAD CSV WITH HEADERS FROM
"https://raw.githubusercontent.com/kaisesha/cdrgraph/7b15f61499fc4e30102b6a5a842c72fbce655520/CDR_Gist3.csv";
As line
RETURN line LIMIT 2;
Any fix for this?
Thanks,
-Kamal
--
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.
