[CASSANDRA-11549] cqlsh: COPY FROM ignores NULL values in conversion

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.15, 2.2.7, 3.0.6, 3.6
• Component/s: Legacy/Tools
• Severity: Normal
• Assignee: Stefania Alborghetti
• Reporter: Stefania Alborghetti

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 12/Apr/16 01:45
• Updated: 09/Jul/19 02:13
• Resolved: 21/Apr/16 02:25

Description

COPY FROM fails to import empty values.

For example:

$ 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';

Imports:

select * from test.test";
 t | i1 | i2
---+----+----
 a | 10 | 20
 c | 50 | 60
(2 rows)

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:

cqlsh> select * from test.test";
 t | i1 | i2
---+----+------
 a | 10 |   20
 c | 50 |   60
 b | 30 | null
(3 rows)

Issue Links

• duplicates: CASSANDRA-11945 CQLSH COPY FROM attempts to parse null timestamp value representatives
• is broken by: CASSANDRA-11053 COPY FROM on large datasets: fix progress report and optimize performance part 4
• relates to: CASSANDRA-11631 cqlsh COPY FROM fails for null values with non-prepared statements