Lex Lythius created CASSANDRA-8675: -------------------------------------- Summary: COPY TO/FROM broken for newline characters Key: CASSANDRA-8675 URL: https://issues.apache.org/jira/browse/CASSANDRA-8675 Project: Cassandra Issue Type: Bug Components: Core Environment: [cqlsh 5.0.1 | Cassandra 2.1.2 | CQL spec 3.2.0 | Native protocol v3] Ubuntu 14.04 64-bit Reporter: Lex Lythius
Exporting/importing does not preserve contents when texts containing newline (and possibly other) characters are involved: {{code}} cqlsh:test> create table if not exists copytest (id int primary key, t text); cqlsh:test> insert into copytest (id, t) values (1, 'This has a newline ... character'); cqlsh:test> insert into copytest (id, t) values (2, 'This has a quote " character'); cqlsh:test> insert into copytest (id, t) values (3, 'This has a fake tab \t character (typed backslash, t)'); cqlsh:test> select * from copytest; id | t ----+--------------------------------------------------------- 1 | This has a newline\ncharacter 2 | This has a quote " character 3 | This has a fake tab \t character (entered slash-t text) (3 rows) cqlsh:test> copy copytest to '/tmp/copytest.csv'; 3 rows exported in 0.034 seconds. cqlsh:test> cqlsh:test> copy copytest to '/tmp/copytest.csv'; 3 rows exported in 0.034 seconds. cqlsh:test> copy copytest from '/tmp/copytest.csv'; 3 rows imported in 0.005 seconds. cqlsh:test> select * from copytest; id | t ----+------------------------------------------------------- 1 | This has a newlinencharacter 2 | This has a quote " character 3 | This has a fake tab \t character (typed backslash, t) (3 rows) {{/code}} I tried replacing \n in the CSV file with \\n, which just expands to \n in the table; and with an actual newline character, which fails with error since it prematurely terminates the record. It seems backslashes are only used to take the following character as a literal Until this is fixed, what would be the best way to refactor an old table with a new, incompatible structure maintaining its content and name? -- This message was sent by Atlassian JIRA (v6.3.4#6332)