incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Confirm with cqlsh of Cassandra-1.2.5, the behavior of the export/import
Date Fri, 21 Jun 2013 08:40:58 GMT
That looks like it may be a bug, can you raise a ticket at https://issues.apache.org/jira/browse/CASSANDRA

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 21/06/2013, at 1:56 AM, hiroshi.kise.rk@hitachi.com wrote:

> 
> Dear everyone.
> 
> I'm Hiroshi Kise.
> I will confirm with cqlsh of Cassandra-1.2.5, the behavior of the export / import of
data.
> Using the Copy of cqlsh, the data included the “{“ and “[“ (= CollectionType)
case,
> I think in the export / import process, data integrity is compromised.
> How about?
> 
> Such as the definition of create table, if there is an error in courtesy, 
> please tell me the right way.
> 
> 
> 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(?).
> 
> 
> 
> Yours sincerely
> ----------
> Hiroshi Kise 
> 
> 
> 
> 
> 
> 
> 
> 
> 


Mime
View raw message