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 Wed, 14 Dec 2016 04:14:59 GMT

    [ 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)

Mime
View raw message