[jira] [Updated] (CASSANDRA-16372) Import from csv of empty strings in list fails with a ParseError: Empty values are not allowed, given up without retries

["Ostico (Jira)" <ji...@apache.org>]

     [ 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org