[ https://issues.apache.org/jira/browse/CASSANDRA-11549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15241983#comment-15241983 ]
Paulo Motta commented on CASSANDRA-11549: ----------------------------------------- I tried executing the dtest locally on trunk and found some errors (they do not fail on 2.1), so I re-triggered another [dtest run|http://cassci.datastax.com/view/Dev/view/stef1927/job/stef1927-11549-dtest/lastCompletedBuild/testReport/] with the new tests so you can have a look. > cqlsh: COPY FROM ignores NULL values in conversion > -------------------------------------------------- > > Key: CASSANDRA-11549 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11549 > Project: Cassandra > Issue Type: Bug > Components: Tools > Reporter: Stefania > Assignee: Stefania > Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x > > > COPY FROM fails to import empty values. > For example: > {code} > $ cat test.csv > a,10,20 > b,30, > c,50,60 > $ cqlsh > cqlsh> create keyspace if not exists test with replication = {'class': > 'SimpleStrategy', 'replication_factor':1}; > cqlsh> create table if not exists test.test (t text primary key, i1 int, i2 > int); > cqlsh> copy test.test (t,i1,i2) from 'test.csv'; > {code} > Imports: > {code} > select * from test.test"; > t | i1 | i2 > ---+----+---- > a | 10 | 20 > c | 50 | 60 > (2 rows) > {code} > and generates a {{ParseError - invalid literal for int() with base 10: '', > given up without retries}} for the row with an empty value. > It should import the empty value as a {{null}} and there should be no error: > {code} > cqlsh> select * from test.test"; > t | i1 | i2 > ---+----+------ > a | 10 | 20 > c | 50 | 60 > b | 30 | null > (3 rows) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)