{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/6","repository_url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl","labels_url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/6/comments","events_url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/6/events","html_url":"https://github.com/neo4j-contrib/neo4j-etl/issues/6","id":282516822,"node_id":"MDU6SXNzdWUyODI1MTY4MjI=","number":6,"title":"Import from PostgreSql fails on boolean data type","user":{"login":"davidlrosenblum","id":21196824,"node_id":"MDQ6VXNlcjIxMTk2ODI0","avatar_url":"https://avatars1.githubusercontent.com/u/21196824?v=4","gravatar_id":"","url":"https://api.github.com/users/davidlrosenblum","html_url":"https://github.com/davidlrosenblum","followers_url":"https://api.github.com/users/davidlrosenblum/followers","following_url":"https://api.github.com/users/davidlrosenblum/following{/other_user}","gists_url":"https://api.github.com/users/davidlrosenblum/gists{/gist_id}","starred_url":"https://api.github.com/users/davidlrosenblum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidlrosenblum/subscriptions","organizations_url":"https://api.github.com/users/davidlrosenblum/orgs","repos_url":"https://api.github.com/users/davidlrosenblum/repos","events_url":"https://api.github.com/users/davidlrosenblum/events{/privacy}","received_events_url":"https://api.github.com/users/davidlrosenblum/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2017-12-15T18:56:11Z","updated_at":"2018-09-11T17:22:02Z","closed_at":null,"author_association":"NONE","body":"If one of the tables has a boolean data type, the Import using Cypher Shell fails when the data is written to the csv.  The error is:\r\n- Command failed due to error (RuntimeException: org.postgresql.util.PSQLException: Bad value for type byte : t). Rerun with --debug flag for detailed diagnostic information.\r\n\r\nThe complete error from the log is attached here:\r\n[etl_err_psql_boolean.txt](https://github.com/neo4j-contrib/neo4j-etl/files/1563667/etl_err_psql_boolean.txt)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/comments/420352280","html_url":"https://github.com/neo4j-contrib/neo4j-etl/issues/6#issuecomment-420352280","issue_url":"https://api.github.com/repos/neo4j-contrib/neo4j-etl/issues/6","id":420352280,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMDM1MjI4MA==","user":{"login":"grubytolman","id":34391903,"node_id":"MDQ6VXNlcjM0MzkxOTAz","avatar_url":"https://avatars3.githubusercontent.com/u/34391903?v=4","gravatar_id":"","url":"https://api.github.com/users/grubytolman","html_url":"https://github.com/grubytolman","followers_url":"https://api.github.com/users/grubytolman/followers","following_url":"https://api.github.com/users/grubytolman/following{/other_user}","gists_url":"https://api.github.com/users/grubytolman/gists{/gist_id}","starred_url":"https://api.github.com/users/grubytolman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grubytolman/subscriptions","organizations_url":"https://api.github.com/users/grubytolman/orgs","repos_url":"https://api.github.com/users/grubytolman/repos","events_url":"https://api.github.com/users/grubytolman/events{/privacy}","received_events_url":"https://api.github.com/users/grubytolman/received_events","type":"User","site_admin":false},"created_at":"2018-09-11T17:22:02Z","updated_at":"2018-09-11T17:22:02Z","author_association":"NONE","body":"I got similar problem in etl 1.2.1:\r\n\r\n./bin/neo4j-etl export --rdbms:url jdbc:postgresql://myurl:5432/public --rdbms:schema example --rdbms:user my_user --rdbms:password pass --destination /var/lib/neo4j/data/databases/graph.db/ --import-tool /usr/share/neo4j/bin --csv-directory /var/lib/neo4j/import --force\r\n\r\nand getting:\r\nPeak memory usage: 0.00 B', Stderr: 'WARNING: neo4j-import is deprecated and support for it will be removed in a future\r\nversion of Neo4j; please use neo4j-admin import instead.\r\nError in input data\r\nCaused by:ERROR in input\r\n  data source: BufferedCharSeeker[source:/var/lib/neo4j/import/csv-003/example/NODE_xxxxxxxxxx.xxxx_1703350c-43dc-48ad-a059-4a5d36d4e5f8.csv, position:225, line:0]\r\n  in field: success:byte:10\r\n  for header: [:ID(xxxxxxxxxx.xxxx), installedRank:long, installedBy:string, description:string, script:string, installedOn:string, executionTime:long, version:string, checksum:long, success:byte, type:string, :LABEL]\r\n  raw field value: true\r\n  original error: Not an integer: \"true\"\r\n\r\nsuccess column is boolean in postgresql"}}
{"actor":{"display_login":"grubytolman"}}