cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefania (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12959) copy from csv import wrong values with udt having set when fields are not specified in correct order in csv
Date Thu, 22 Dec 2016 02:18:58 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-12959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15768782#comment-15768782
] 

Stefania commented on CASSANDRA-12959:
--------------------------------------

Thank you for the review! :)

bq. I'm a bit impressed parsing 'first_field' to frozen<set<text>> did not error
out, but was actually parsed as {'irst_fiel'}, is this something we should look into (maybe
in a separate ticket)?

I've created CASSANDRA-13071 for this.

bq. oops, I missed your earlier comment about 2.1 dtests not running. 

The cqlsh tests do not run, but I did run the full dtests, which include cqlsh dtests but
not cqlshlib tests and do not test cython. I think this is safe enough for this patch (we
never run cqlshlib tests for 2.1, not even on the main branches).

I will commit shortly.

> copy from csv import wrong values with udt having set when fields are not specified in
correct order in csv
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-12959
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12959
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Quentin Ambard
>            Assignee: Stefania
>             Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x
>
>
>  {quote}
> create KEYSPACE test WITH replication = \{ 'class': 'SimpleStrategy', 'replication_factor':
1\};
> CREATE TYPE test.my_udt (
>     first_field text,
>     second_field frozen<set<text>>
> );
> CREATE TABLE test.test ( key text, value my_udt, PRIMARY KEY (key));
> {quote}
> The following works as expected : 
> {quote}
> INSERT INTO test.test (key , value ) VALUES ( 'key1', \{second_field: \{'test1', 'test2'\},
first_field: 'first_field'\});
>  key  | value
> ------+----------------------------------------------------------------
>  key1 | \{first_field: 'first_field', second_field: \{'test1', 'test2'\}\}
> {quote}
> but when inserted using a .csv the result is wrong:
> {quote}"key1","\{second_field: \{'test1', 'test2'\}, first_field: 'first_field'\}"
> COPY test.test FROM '~/test.csv';
>  key  | value
> ------+----------------------------------------------------------------------
>  key1 | \{first_field: '\{''test1'', ''test2''\}', second_field: \{'irst_fiel'\}\}
> {quote}
> it works as expected if the keys are in order: 
> bq. "key1","\{first_field: 'first_field', second_field: \{'test1', 'test2'\}\}")



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message