You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Nikolai Grigoriev (JIRA)" <ji...@apache.org> on 2014/06/18 17:01:31 UTC
[jira] [Updated] (CASSANDRA-7415) COPY command does not quote map
keys
[ https://issues.apache.org/jira/browse/CASSANDRA-7415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikolai Grigoriev updated CASSANDRA-7415:
-----------------------------------------
Description:
{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.
was:
{code}
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.
> 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)