[ https://issues.apache.org/jira/browse/CASSANDRA-12959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefania updated CASSANDRA-12959: --------------------------------- Fix Version/s: 3.x 3.0.x 2.2.x 2.1.x Reproduced In: 3.9, 3.8 (was: 3.8, 3.9) Status: Patch Available (was: In Progress) > 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)