{"action":"created","issue":{"url":"https://api.github.com/repos/scylladb/scylla/issues/1750","repository_url":"https://api.github.com/repos/scylladb/scylla","labels_url":"https://api.github.com/repos/scylladb/scylla/issues/1750/labels{/name}","comments_url":"https://api.github.com/repos/scylladb/scylla/issues/1750/comments","events_url":"https://api.github.com/repos/scylladb/scylla/issues/1750/events","html_url":"https://github.com/scylladb/scylla/issues/1750","id":181899549,"number":1750,"title":"Bulk copy fails - copy data from CSV to Scylla","user":{"login":"nirmaayan","id":18263247,"avatar_url":"https://avatars2.githubusercontent.com/u/18263247?v=3","gravatar_id":"","url":"https://api.github.com/users/nirmaayan","html_url":"https://github.com/nirmaayan","followers_url":"https://api.github.com/users/nirmaayan/followers","following_url":"https://api.github.com/users/nirmaayan/following{/other_user}","gists_url":"https://api.github.com/users/nirmaayan/gists{/gist_id}","starred_url":"https://api.github.com/users/nirmaayan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nirmaayan/subscriptions","organizations_url":"https://api.github.com/users/nirmaayan/orgs","repos_url":"https://api.github.com/users/nirmaayan/repos","events_url":"https://api.github.com/users/nirmaayan/events{/privacy}","received_events_url":"https://api.github.com/users/nirmaayan/received_events","type":"User","site_admin":false},"labels":[{"id":160570958,"url":"https://api.github.com/repos/scylladb/scylla/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/scylladb/scylla/milestones/22","html_url":"https://github.com/scylladb/scylla/milestone/22","labels_url":"https://api.github.com/repos/scylladb/scylla/milestones/22/labels","id":2263646,"number":22,"title":"x-ray","description":"","creator":{"login":"slivne","id":3465480,"avatar_url":"https://avatars3.githubusercontent.com/u/3465480?v=3","gravatar_id":"","url":"https://api.github.com/users/slivne","html_url":"https://github.com/slivne","followers_url":"https://api.github.com/users/slivne/followers","following_url":"https://api.github.com/users/slivne/following{/other_user}","gists_url":"https://api.github.com/users/slivne/gists{/gist_id}","starred_url":"https://api.github.com/users/slivne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slivne/subscriptions","organizations_url":"https://api.github.com/users/slivne/orgs","repos_url":"https://api.github.com/users/slivne/repos","events_url":"https://api.github.com/users/slivne/events{/privacy}","received_events_url":"https://api.github.com/users/slivne/received_events","type":"User","site_admin":false},"open_issues":243,"closed_issues":20,"state":"open","created_at":"2017-01-19T09:54:08Z","updated_at":"2017-06-18T10:34:31Z","due_on":"2017-12-31T08:00:00Z","closed_at":null},"comments":5,"created_at":"2016-10-09T17:32:34Z","updated_at":"2017-06-23T07:12:56Z","closed_at":"2017-03-16T10:26:15Z","body":"_Installation details_\nScylla version (or git commit hash): 1.3\nCluster size: 1\nOS (RHEL/CentOS/Ubuntu/AWS AMI): ami-6c21427b\n\nTrying to load data using CSV, operation fails \nScenario\nCreate simple table:\nCREATE TABLE training.test (name text PRIMARY KEY) ;\n\nOn the same instance create file with one row no headers.\n\n> $ sudo vi load.csv\n\nEnter value to the file 'nir'\n\n> cqlsh \n> use training;\n> cqlsh:training> COPY test FROM 'kk.csv';\n> 'QueryMessage' object has no attribute 'to_binary'\n> Aborting import at record #1. Previously inserted records are still present, and some records after that may be present as well\n\nCopy fails with the error above, if any file manipulite is needed we should better instruct what need to be done.\n\nTested the same scenario in C\\* it works\n"},"comment":{"url":"https://api.github.com/repos/scylladb/scylla/issues/comments/310590547","html_url":"https://github.com/scylladb/scylla/issues/1750#issuecomment-310590547","issue_url":"https://api.github.com/repos/scylladb/scylla/issues/1750","id":310590547,"user":{"login":"superdzen","id":26591210,"avatar_url":"https://avatars2.githubusercontent.com/u/26591210?v=3","gravatar_id":"","url":"https://api.github.com/users/superdzen","html_url":"https://github.com/superdzen","followers_url":"https://api.github.com/users/superdzen/followers","following_url":"https://api.github.com/users/superdzen/following{/other_user}","gists_url":"https://api.github.com/users/superdzen/gists{/gist_id}","starred_url":"https://api.github.com/users/superdzen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/superdzen/subscriptions","organizations_url":"https://api.github.com/users/superdzen/orgs","repos_url":"https://api.github.com/users/superdzen/repos","events_url":"https://api.github.com/users/superdzen/events{/privacy}","received_events_url":"https://api.github.com/users/superdzen/received_events","type":"User","site_admin":false},"created_at":"2017-06-23T07:12:56Z","updated_at":"2017-06-23T07:12:56Z","body":"I tested on rpm-version scylla-enterprise-2017.1.0-20170614.9e18942.el7.centos.x86_64 + Centos 7.3 and i had the same error:\r\n\r\ncqlsh:test> copy test.sample1 TO 'a.csv'  WITH HEADER=TRUE;\r\n\r\n4 rows exported in 0.004 seconds.\r\ncqlsh:test> truncate test.sample1;\r\ncqlsh:test> select * from test.sample1;\r\n\r\n foo | bar | baz | faz\r\n-----+-----+-----+-----\r\n\r\n(0 rows)\r\ncqlsh:test> copy test.sample1 FROM 'a.csv'  WITH HEADER=TRUE;\r\n\r\n'QueryMessage' object has no attribute 'to_binary'\r\nAborting import at record # 1. Previously inserted records are still present, and some records after that may be present as well.\r\n\r\n4 rows imported in 0.067 seconds.\r\n\r\n\r\nTRACING ON shows the same message.\r\n"}}
{"actor":{"display_login":"superdzen"}}