[
https://issues.apache.org/jira/browse/CASSANDRA-12959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15767946#comment-15767946
]
Paulo Motta commented on CASSANDRA-12959:
-----------------------------------------
Patch and tests look good! 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)?
Agreed this should go in 2.1 since it's a very simple fix and also bit critical
since it can cause silent corruption if the import results are not verified.
2.1 tests did not run, I resubmitted and will mark as ready to commit if it
looks good.
> 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)
