{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/815","repository_url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures","labels_url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/815/labels{/name}","comments_url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/815/comments","events_url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/815/events","html_url":"https://github.com/neo4j-contrib/neo4j-apoc-procedures/issues/815","id":326421553,"node_id":"MDU6SXNzdWUzMjY0MjE1NTM=","number":815,"title":"NullPointerException  while load csv using apoc.periodic.iterate ","user":{"login":"macroxmu","id":8890761,"node_id":"MDQ6VXNlcjg4OTA3NjE=","avatar_url":"https://avatars2.githubusercontent.com/u/8890761?v=4","gravatar_id":"","url":"https://api.github.com/users/macroxmu","html_url":"https://github.com/macroxmu","followers_url":"https://api.github.com/users/macroxmu/followers","following_url":"https://api.github.com/users/macroxmu/following{/other_user}","gists_url":"https://api.github.com/users/macroxmu/gists{/gist_id}","starred_url":"https://api.github.com/users/macroxmu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/macroxmu/subscriptions","organizations_url":"https://api.github.com/users/macroxmu/orgs","repos_url":"https://api.github.com/users/macroxmu/repos","events_url":"https://api.github.com/users/macroxmu/events{/privacy}","received_events_url":"https://api.github.com/users/macroxmu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2018-05-25T08:06:52Z","updated_at":"2018-11-06T12:29:46Z","closed_at":null,"author_association":"NONE","body":"I'm loading csv file using apoc.periodic.iterate  and apoc.load.csv, but I always fail and said there are NullPointerException :\r\n```\r\nneo4j> CALL apoc.periodic.iterate('\r\n       CALL apoc.load.csv(\"http://128.194.9.150:9999/On_Time_On_Time_Performance_2018_1.csv\", {}) yield map as row return row\r\n       ','\r\n       MATCH (sc:City {name: row.OriginCityName}), (tc:City {name: row.DestCityName})\r\n       MERGE (sc)-[f:Flight {flightDate: row.FlightDate, flightNum: toInt(row.FlightNum)}]->(tc)\r\n       ', {batchSize:200, iterateList:true, parallel:true});\r\n+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| batches | total  | timeTaken | committedOperations | failedOperations | failedBatches | retries | errorMessages | batch                                                                                          | operations                                                   | wasTerminated |\r\n+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n| 2851    | 570131 | 888       | 313800              | 256400           | 1282          | 0       |               | {total: 2851, committed: 1569, failed: 1282, errors: {`java.lang.NullPointerException`: 1282}} | {total: 570131, committed: 313800, failed: 256400, errors: } | FALSE         |\r\n+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\r\n\r\n```\r\n\r\nBUT, while I using neo4j's load csv command to load this file, they are correct:\r\n```\r\nneo4j> LOAD CSV WITH HEADERS FROM \"http://128.194.9.150:9999/On_Time_On_Time_Performance_2018_1.csv\" as row\r\n       MATCH (sc:City {name: row.OriginCityName}), (tc:City {name: row.DestCityName}) \r\n       MERGE (sc)-[f:Flight {flightDate: row.FlightDate, flightNum: toInt(row.FlightNum)}]->(tc)\r\n       ;\r\n0 rows available after 3395077 ms, consumed after another 0 ms\r\nCreated 255988 relationships, Set 511976 properties\r\n```\r\n\r\nthe csv file come from the website: https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time    \r\nIt's a bug of apoc package?"},"comment":{"url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/comments/436236093","html_url":"https://github.com/neo4j-contrib/neo4j-apoc-procedures/issues/815#issuecomment-436236093","issue_url":"https://api.github.com/repos/neo4j-contrib/neo4j-apoc-procedures/issues/815","id":436236093,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNjIzNjA5Mw==","user":{"login":"jexp","id":67427,"node_id":"MDQ6VXNlcjY3NDI3","avatar_url":"https://avatars1.githubusercontent.com/u/67427?v=4","gravatar_id":"","url":"https://api.github.com/users/jexp","html_url":"https://github.com/jexp","followers_url":"https://api.github.com/users/jexp/followers","following_url":"https://api.github.com/users/jexp/following{/other_user}","gists_url":"https://api.github.com/users/jexp/gists{/gist_id}","starred_url":"https://api.github.com/users/jexp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jexp/subscriptions","organizations_url":"https://api.github.com/users/jexp/orgs","repos_url":"https://api.github.com/users/jexp/repos","events_url":"https://api.github.com/users/jexp/events{/privacy}","received_events_url":"https://api.github.com/users/jexp/received_events","type":"User","site_admin":false},"created_at":"2018-11-06T12:29:46Z","updated_at":"2018-11-06T12:29:46Z","author_association":"MEMBER","body":"Did you try to run it without apoc.periodic.iterate just a regular load csv and a limit say of 100k rows?"}}
{"actor":{"display_login":"jexp"}}