[CASSANDRA-7415] COPY command does not quote map keys

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Component/s: Legacy/Tools

Environment

Cassandra 2.0.5, Linux

• Severity: Low
• Assignee: Unassigned
• Reporter: Nikolai Grigoriev
• Created: 18/Jun/14 15:00
• Updated: 16/Apr/19 09:31
• Resolved: 18/Jun/14 15:17

Description

cqlsh:myks> create table test (pk text primary key, props map<ascii, blob>);
cqlsh:myks> insert into test (pk, props) values ('aaa', {'prop1': 0x1020, 'prop2': 0x4050});
cqlsh:myks> copy test to 't.csv';
1 rows exported in 0.056 seconds.
cqlsh:myks> copy test from 't.csv';
Bad Request: line 1:74 no viable alternative at input ':'
Aborting import at record #0 (line 1). Previously-inserted values still present.
0 rows imported in 0.012 seconds.
cqlsh:myks>

t.csv:

# cat t.csv
aaa,"{prop1: 0x1020, prop2: 0x4050}"

I believe the missing quotes in the CSV file cause INSERT to fail.

Issue Links

• duplicates: CASSANDRA-7407 COPY command does not work properly with collections causing failure to import data