ldbc / ldbc_snb_interactive_v1_impls

Reference implementations for LDBC Social Network Benchmark's Interactive workload.
https://ldbcouncil.org/benchmarks/snb-interactive
Apache License 2.0
101 stars 86 forks source link

Cypher implementation IMPORT FAILED #133

Closed djnakabaale closed 4 years ago

djnakabaale commented 4 years ago

Hi, I am having trouble when I run ./import-to-neo4j.sh for the Cypher(Neo4j driver)implementation for SNB. The script ./convert-csvs.sh that handles preprocessing runs fine but when I try to import the data set, I get this error:

IMPORT FAILED in 57ms. 
Data statistics is not available.
Peak memory usage: 0B
Error in input data
Caused by:ERROR in input
  data source: BufferedCharSeeker[source:/Users/davidnakabaale/Desktop/_ldbc-snb/ldb_snb_datagen_v0.3.3/ldbc_snb_datagen/social_network/dynamic/comment_0_0.csv, position:14, line:0]
  in field: creationDate:datetime:1
  for header: [creationDate:datetime, id:ID(Comment), locationIP:string, browserUsed:string, content:string, length:long]
  raw field value: 1236950581249
  original error: Text cannot be parsed to a DateTime
"1236950581249"
 ^

WARNING Import failed. The store files in /Users/davidnakabaale/Desktop/_ldbc-snb/ldb_snb_datagen_v0.3.3/ldbc_snb_implementations/cypher/neo4j-server/data/databases/neo4j are left as they are, although they are likely in an unusable state. Starting a database on these store files will likely fail or observe inconsistent records so start at your own risk or delete the store manually
org.neo4j.internal.batchimport.input.InputException: ERROR in input
  data source: BufferedCharSeeker[source:/Users/davidnakabaale/Desktop/_ldbc-snb/ldb_snb_datagen_v0.3.3/ldbc_snb_datagen/social_network/dynamic/comment_0_0.csv, position:14, line:0]
  in field: creationDate:datetime:1
  for header: [creationDate:datetime, id:ID(Comment), locationIP:string, browserUsed:string, content:string, length:long]
  raw field value: 1236950581249
  original error: Text cannot be parsed to a DateTime
"1236950581249"

I am using the ldbc_datagen v0.3.3 I am wondering if I am missing something or if anyone would be willing to provide me with some direction here?

szarnyasg commented 4 years ago

Hi @dmj2x, try the stable branch of this repo. That should be compatible with v0.3.3's format.

djnakabaale commented 4 years ago

Thanks @szarnyasg