[
https://issues.apache.org/jira/browse/CASSANDRA-12959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15747194#comment-15747194
]
Stefania commented on CASSANDRA-12959:
--------------------------------------
Thanks for taking the review [~pauloricardomg]! Hopefully you haven't looked at
the patch yet, and so it makes no difference, but I just modified it slightly
so that we can handle missing UDT fields as well. The patch is still quite
small and it applies without conflicts to all branches. CI is pending.
> 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)
