csv - Neo4j jexp/batch-import weird error: java.lang.NumberFormatException -
i'm trying import around 6m nodes using michael hunger's batch importer i'm getting weird error: java.lang.numberformatexception: input string: "78rftark42lp5f8nadc63l62r3" @ java.lang.numberformatexception.forinputstring(numberformatexception.java:65)
it weird because 78rftark42lp5f8nadc63l62r3 first value of big csv file i'm trying import , datatype set string.
these first 3 lines of file:
name:string:sessions labels:label timestamp:long:timestamps visitor_pid referrer_url 78rftark42lp5f8nadc63l62r3 session 1401277353000 cd7b76ef09b498e95b35b49de2925c5f http://someurl.com/blah?t=123 dt2gshq5pao8fg7bka8fdri123 session 1401277329000 4036ac507698e4daf2ada98664da6d58 http://enter.url.com/signup/signup.php
as can see here name:string:session datatype of column set string, why importer trying parse value long?
i'm new neo4j , ecosystem i'm sure i'm missing here.
this command ran import bunch of nodes , relations: ./import.sh \ -db-directory sessions.db \ -nodes "toimport/browser-nodes.csv.gz,toimport/country-nodes.csv.gz,toimport/device-nodes.csv.gz,toimport/ip-nodes.csv.gz,toimport/language-nodes.csv.gz,toimport/operatingsystem-nodes.csv.gz,toimport/referrertype-nodes.csv.gz,toimport/resolution-nodes.csv.gz,toimport/session-nodes.csv" \ -rels "toimport/rel-session-browser.csv.gz,toimport/rel-session-country.csv.gz,toimport/rel-session-device.csv.gz,toimport/rel-session-ip.csv.gz,toimport/rel-session-language.csv.gz,toimport/rel-session-operatingsystem.csv.gz,toimport/rel-session-referrertype.csv.gz,toimport/rel-session-resolution.csv.gz"
the file fails last 1 in list of nodes toimport/session-nodes.csv other files processed importer.
this content of batch.properties file:
dump_configuration=false cache_type=none use_memory_mapped_buffers=true neostore.propertystore.db.index.keys.mapped_memory=1g neostore.propertystore.db.index.mapped_memory=3g neostore.nodestore.db.mapped_memory=1g neostore.relationshipstore.db.mapped_memory=1g neostore.propertystore.db.mapped_memory=1g neostore.propertystore.db.strings.mapped_memory=1g batch_import.node_index.sessions=exact batch_import.node_index.browsers=exact batch_import.node_index.operatingsystems=exact batch_import.node_index.referrertypes=exact batch_import.node_index.devices=exact batch_import.node_index.resolutions=exact batch_import.node_index.countries=exact batch_import.node_index.languages=exact batch_import.node_index.ips=exact batch_import.node_index.timestamps=exact any thoughts? can't see what's problem here appreciated.
edit: i'm using binary: https://dl.dropboxusercontent.com/u/14493611/batch_importer_20.zip
Comments
Post a Comment