Ostico created CASSANDRA-16372:
----------------------------------
Summary: Import from csv of empty strings in list fails with a
ParseError
Key: CASSANDRA-16372
URL: https://issues.apache.org/jira/browse/CASSANDRA-16372
Project: Cassandra
Issue Type: Bug
Components: Legacy/Tools
Reporter: Ostico
Cqlsh fail to import an empty string which is present in a list data type.
*Conditions*
{code:java}
CREATE TABLE test.test_1 (
uid uuid PRIMARY KEY,
texts list<text>
) WITH bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '64', 'class':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';
insert into test.test_1 ( uid, texts ) VALUES(
833fee3f-d4f9-418b-9387-84ac2cda5cb7, ['But if you now try to wash your
hands,', ''] );
{code}
Now exporting and and re-importing data fails:
{code:java}
cqlsh> select * from test.test_1;
uid | texts
--------------------------------------+------------------------------------------------
833fee3f-d4f9-418b-9387-84ac2cda5cb7 | ['But if you now try to wash your
hands,', '']
cqlsh> COPY test.test_1 (uid, texts) TO 'ctm.csv'; Using 7 child
processesStarting copy of test.test_1 with columns [uid, texts]. Processed: 1
rows; Rate: 9 rows/s; Avg. rate: 9 rows/s 1 rows exported to 1 files in 0.148
seconds.
cqlsh> truncate table test.test_1;
cqlsh> COPY test.test_1 (uid, texts) FROM 'ctm.csv';
Using 7 child processesStarting copy of test.test_1 with columns [uid, texts].
Failed to import 1 rows: ParseError - Failed to parse ['But if you now try to
wash your hands,', ''] : Empty values are not allowed, given up without retries
Failed to process 1 rows; failed rows written to import_test_test_1.err
Processed: 1 rows; Rate: 2 rows/s; Avg. rate: 2 rows/s
1 rows imported from 1 files in 0.415 seconds (0 skipped).
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
