[ https://issues.apache.org/jira/browse/CASSANDRA-16372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ostico updated CASSANDRA-16372: ------------------------------- Summary: Import from csv of empty strings in list fails with a ParseError: Empty values are not allowed, given up without retries (was: Import from csv of empty strings in list fails with a ParseError) > Import from csv of empty strings in list fails with a ParseError: Empty > values are not allowed, given up without retries > ------------------------------------------------------------------------------------------------------------------------- > > Key: CASSANDRA-16372 > URL: https://issues.apache.org/jira/browse/CASSANDRA-16372 > Project: Cassandra > Issue Type: Bug > Components: Legacy/Tools > Reporter: Ostico > Priority: Normal > > > 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: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org