You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Aleksey Yeschenko (JIRA)" <ji...@apache.org> on 2013/06/25 09:13:21 UTC
[jira] [Reopened] (CASSANDRA-5698) Confirm with cqlsh of
Cassandra-1.2.5, the behavior of the export/import
[ https://issues.apache.org/jira/browse/CASSANDRA-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Yeschenko reopened CASSANDRA-5698:
------------------------------------------
> Confirm with cqlsh of Cassandra-1.2.5, the behavior of the export/import
> ------------------------------------------------------------------------
>
> Key: CASSANDRA-5698
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5698
> Project: Cassandra
> Issue Type: Bug
> Components: Tools
> Affects Versions: 1.1.2, 1.1.3
> Environment: Using the Copy of cqlsh, the data included the “{“ and “[“ (= CollectionType) case,
> I think in the export / import process, data integrity is compromised.
> Reporter: Hiroshi Kise
> Assignee: Aleksey Yeschenko
> Priority: Minor
>
> Concrete operation is as follows.
> ---------*---------*---------*---------*---------*---------*---------*---------*
> (1)map type's export/import
> <export>
> [root@castor bin]# ./cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 3.0.2 | Cassandra 1.2.5 | CQL spec 3.0.0 | Thrift protocol 19.36.0]
> Use HELP for help.
> cqlsh> create keyspace maptestks with replication = { 'class' : 'SimpleStrategy', 'replication_factor' : '1' };
> cqlsh> use maptestks;
> cqlsh:maptestks> create table maptestcf (rowkey varchar PRIMARY KEY, targetmap map<varchar,varchar>);
> cqlsh:maptestks> insert into maptestcf (rowkey, targetmap) values ('rowkey',{'mapkey':'mapvalue'});
> cqlsh:maptestks> select * from maptestcf;
> rowkey | targetmap
> --------+--------------------
> rowkey | {mapkey: mapvalue}
> cqlsh:maptestks> copy maptestcf to 'maptestcf-20130619.txt';
> 1 rows exported in 0.008 seconds.
> cqlsh:maptestks> exit;
> [root@castor bin]# cat maptestcf-20130619.txt
> rowkey,{mapkey: mapvalue}
> <------------------------(a)
> <import>
> [root@castor bin]# ./cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 3.0.2 | Cassandra 1.2.5 | CQL spec 3.0.0 | Thrift protocol 19.36.0]
> Use HELP for help.
> cqlsh> create keyspace mapimptestks with replication = { 'class' : 'SimpleStrategy', 'replication_factor' : '1' };
> cqlsh> use mapimptestks;
> cqlsh:mapimptestks> create table mapimptestcf (rowkey varchar PRIMARY KEY, targetmap map<varchar,varchar>);
> cqlsh:mapimptestks> copy mapimptestcf from ' maptestcf-20130619.txt ';
> Bad Request: line 1:83 no viable alternative at input '}'
> Aborting import at record #0 (line 1). Previously-inserted values still present.
> 0 rows imported in 0.025 seconds.
> ---------*---------*---------*---------*---------*---------*---------*---------*
> (2)list type's export/import
> <export>
> [root@castor bin]#./cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 3.0.2 | Cassandra 1.2.5 | CQL spec 3.0.0 | Thrift protocol 19.36.0]
> Use HELP for help.
> cqlsh> create keyspace listtestks with replication = { 'class' : 'SimpleStrategy', 'replication_factor' : '1' };
> cqlsh> use listtestks;
> cqlsh:listtestks> create table listtestcf (rowkey varchar PRIMARY KEY, value list<varchar>);
> cqlsh:listtestks> insert into listtestcf (rowkey,value) values ('rowkey',['value1','value2']);
> cqlsh:listtestks> select * from listtestcf;
> rowkey | value
> --------+------------------
> rowkey | [value1, value2]
> cqlsh:listtestks> copy listtestcf to 'listtestcf-20130619.txt';
> 1 rows exported in 0.014 seconds.
> cqlsh:listtestks> exit;
> [root@castor bin]# cat listtestcf-20130619.txt
> rowkey,"[value1, value2]"
> <------------------------(b)
> <export>
> [root@castor bin]# ./cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 3.0.2 | Cassandra 1.2.5 | CQL spec 3.0.0 | Thrift protocol 19.36.0]
> Use HELP for help.
> cqlsh> create keyspace listimptestks with replication = { 'class' : 'SimpleStrategy', 'replication_factor' : '1' };
> cqlsh> use listimptestks;
> cqlsh:listimptestks> create table listimptestcf (rowkey varchar PRIMARY KEY, value list<varchar>);
> cqlsh:listimptestks> copy listimptestcf from ' listtestcf-20130619.txt ';
> Bad Request: line 1:79 no viable alternative at input ']'
> Aborting import at record #0 (line 1). Previously-inserted values still present.
> 0 rows imported in 0.030 seconds.
> ---------*---------*---------*---------*---------*---------*---------*---------*
> Reference: (correct, or error, in another dimension)
> Manually, I have rewritten the export file.
> [root@castor bin]# cat nlisttestcf-20130619.txt
> rowkey,"['value1',' value2']"
> ....
> cqlsh:listimptestks> copy listimptestcf from 'nlisttestcf-20130619.txt';
> 1 rows imported in 0.035 seconds.
> cqlsh:listimptestks> select * from implisttestcf;
> rowkey | value
> --------+------------------
> rowkey | [value1, value2]
> cqlsh:implisttestks> exit;
> [root@castor bin]# cat nmaptestcf-20130619.txt
> rowkey,”{'mapkey': 'mapvalue'}”
> [root@castor bin]# ./cqlsh
> Connected to Test Cluster at localhost:9160.
> [cqlsh 3.0.2 | Cassandra 1.2.5 | CQL spec 3.0.0 | Thrift protocol 19.36.0]
> Use HELP for help.
> cqlsh> use mapimptestks;
> cqlsh:mapimptestks> copy mapimptestcf from 'nmaptestcf-20130619.txt';
> 1 rows imported in 0.023 seconds.
> cqlsh:mapimptestks> select * from mapimptestcf;
> rowkey | targetmap
> --------+--------------------
> rowkey | {mapkey: mapvalue}
> (It appears to be as normal processing.)
> ---------*---------*---------*---------*---------*---------*---------*---------*
> Please confirm from the operation described above.
> Comparing the above (a) and (b), in the data format of export file,
> only the presence or absence of ("),
> it suggests a lack of consistency of the treatment(?).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira