DSBulk interprets newline characters `\n` in text columns and writes multiple lines per record to output file about dsbulk HOT 4 CLOSED

CREATE TABLE test.dsbulk (
    pk int PRIMARY KEY,
    c1 text
);

$ cat dsbulk.csv
pk,c1
1,'First line.\nSecond line.'
2,First line.\nSecond line.

$ ./dsbulk --version
DataStax Bulk Loader v1.7.0

$ ./dsbulk load -k test -t dsbulk -header true -url ./dsbulk.csv 
Operation directory: /Users/madhavan.sridharan/Data/Tools/DSBulk/dsbulk-1.7.0/bin/logs/LOAD_20201014-143653-997467
total | failed | rows/s | p50ms | p99ms | p999ms | batches
    2 |      0 |      7 |  5.89 |  8.59 |   8.59 |    1.00
Operation LOAD_20201014-143653-997467 completed successfully in less than one second.
Last processed positions can be found in positions.txt

cqlsh:test> select * from test.dsbulk ;

 pk | c1
----+-----------------------------
  1 | 'First line.\nSecond line.'
  2 |   First line.\nSecond line.

(2 rows)

$ ./dsbulk unload -k test -t dsbulk -header true -url ./dsbulk_unload
Operation directory: /Users/madhavan.sridharan/Data/Tools/DSBulk/dsbulk-1.7.0/bin/logs/UNLOAD_20201014-144238-583471
total | failed | rows/s | p50ms | p99ms | p999ms
    2 |      0 |      4 |  7.62 | 12.98 |  12.98
Operation UNLOAD_20201014-144238-583471 completed successfully in less than one second.

$ ls dsbulk_unload/output-00000
output-000001.csv  output-000002.csv

$ cat dsbulk_unload/output-00000*.csv
pk,c1
2,First line.\nSecond line.
pk,c1
1,'First line.\nSecond line.'

import java.net.InetSocketAddress;

import com.datastax.oss.driver.api.core.CqlSession;
import com.datastax.oss.driver.api.core.cql.ResultSet;

public class DAT617 {
    public static void main(String... args) {
	try (CqlSession session = CqlSession.builder().addContactPoint(new InetSocketAddress("localhost", 9042))
		.withLocalDatacenter("dc1").build()) { // Change values to match your environment
	    ResultSet rs = session.execute("insert into test.dsbulk(pk,c1) values (3,'First line.\\nSecond line.')");
	}
    }
}

cqlsh:test> select * from test.dsbulk ;

 pk | c1
----+-----------------------------
  1 | 'First line.\nSecond line.'
  2 |   First line.\nSecond line.
  3 |   First line.\nSecond line.

(3 rows)

$ ./dsbulk unload -k test -t dsbulk -header true -url ./dsbulk_unload
Operation directory: /Users/madhavan.sridharan/Data/Tools/DSBulk/dsbulk-1.7.0/bin/logs/UNLOAD_20201014-150212-234300
total | failed | rows/s | p50ms | p99ms | p999ms
    3 |      0 |      9 |  1.41 |  1.49 |   1.49
Operation UNLOAD_20201014-150212-234300 completed successfully in less than one second.

$ cat dsbulk_unload/output-00000*.csv
pk,c1
1,'First line.\nSecond line.'
pk,c1
3,First line.\nSecond line.
pk,c1
2,First line.\nSecond line.