[CASSANDRA-11945] CQLSH COPY FROM attempts to parse null timestamp value representatives

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Component/s: Legacy/Tools

Environment

OSX / [cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]

• Severity: Normal
• Assignee: Stefania Alborghetti
• Reporter: craig mcmillan

Authors

Stefania Alborghetti

• Created: 02/Jun/16 12:30
• Updated: 16/Apr/19 09:30
• Resolved: 02/Jun/16 14:18

Description

CQLSH COPY FROM is broken when the table includes timestamp columns with null values

create table foo (id uuid primary key, t timestamp);
insert into foo (now(), null);
copy foo to 'foo.csv';
copy foo from 'foo.csv';

... borks with

Failed to import 1 rows: ParseError - can't interpret '' as a date with format %Y-%m-%d %H:%M:%S.%f%z or as int, given up without retries
Failed to process 1 rows; failed rows written to import_erdev_foo.err

Issue Links

• is duplicated by: CASSANDRA-11549 cqlsh: COPY FROM ignores NULL values in conversion