How to insert a newline(\n) inside a String(text) into Cassandra by CQLSH command?

Question

Update: Newline is working if I insert the same line by python driver script.

session.execute("INSERT INTO ctable" + " (cid, cstring) VALUES (%s, %s)", ('2', 'row1\nrow2'))

Still don't understand why the CQLSH command doesn't work.

Original Question: I am trying to insert a very long string into Cassandra by CQLSH command, and add a '\n' to split the string into two lines when display.

I tried

insert into ctable (cid, cstring ) values('2', 'row1\nrow2');
insert into ctable (cid, cstring ) values('2', 'row1\\nrow2');
insert into ctable (cid, cstring ) values('2', 'row1\r\nrow2');

None of above statements worked, all \n had been treated as a regular chracter. Can anyone help?

score 4 · Accepted Answer · answered Dec 09 '15 at 16:01

4

Short answer: cqlsh does not handle escape characters in strings in any way. If you want to insert non-printable characters like newline \n, use cassandra drivers for your language. For a long answer, see discussion for issue CASSANDRA-8790

answered Dec 09 '15 at 16:01

shutty

3,298
16
27

Thanks! I was using python driver for Cassandra and it works. – Haifeng Zhang Dec 09 '15 at 16:25

score 3 · Answer 2 · answered Nov 24 '16 at 00:29

Well you can do it directly in CQLSH if you actually press enter while typing the string. instead of entering the characters '\n' just press enter. CQLSH should show 3 dots indicating its adding content on the new line.

I know its too late to reply but leaving the answer here for someone like me who searches this question in the future.

score 0 · Answer 3 · answered Jan 15 '19 at 08:17

0

You can try this SQL, just use enter:

insert into ctable (cid, cstring ) values('2', 'row1
row2');

answered Jan 15 '19 at 08:17

Sumrise

71
7

there is a same answer from FocusBlast - why duplicate? – Alex Ott Jan 15 '19 at 09:07

How to insert a newline(\n) inside a String(text) into Cassandra by CQLSH command?

3 Answers3