[CASSANDRA-11375] COPY FROM fails when importing blob

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.14
• Component/s: Legacy/CQL
• Severity: Normal
• Since Version: 2.1.13
• Assignee: Stefania Alborghetti
• Reporter: Philippe Thibaudeau

Authors

Stefania Alborghetti

Reviewers

Paulo Motta

• Created: 17/Mar/16 17:34
• Updated: 16/Apr/19 09:30
• Resolved: 29/Mar/16 17:00

Description

When we try to COPY TO a table containing a blob, we get this error
COPY test.blobTable FROM '/tmp/test1.csv' WITH NULL='null' AND DELIMITER=',' AND QUOTE='"';

/opt/apache-cassandra-2.1.13.4/bin/../pylib/cqlshlib/copyutil.py:1602: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
/opt/apache-cassandra-2.1.13.4/bin/../pylib/cqlshlib/copyutil.py:1850: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
Failed to import 5 rows: ParseError - fromhex() argument 1 must be unicode, not str - given up without retries
Failed to process 5 rows; failed rows written to import_test_blobTable.err

Same COPY TO function worked fine with 2.1.9
The csv is generated by doing a COPY FROM on the same table.
Is there any work around this issue?

Issue Links

• is broken by: CASSANDRA-9302 Optimize cqlsh COPY FROM, part 3