[jira] [Resolved] (CASSANDRA-7415) COPY command does not quote map keys

["Brandon Williams (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-7415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams resolved CASSANDRA-7415.
-----------------------------------------

    Resolution: Duplicate

> COPY command does not quote map keys
> ------------------------------------
>
>                 Key: CASSANDRA-7415
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7415
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: Cassandra 2.0.5, Linux
>            Reporter: Nikolai Grigoriev
>            Priority: Minor
>
> {code}
> 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>
> {code}
> t.csv:
> {code}
> # cat t.csv
> aaa,"{prop1: 0x1020, prop2: 0x4050}"
> {code}
> I believe the missing quotes in the CSV file cause INSERT to fail. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)