[
https://issues.apache.org/jira/browse/CASSANDRA-17200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-17200:
-----------------------------------------
Bug Category: Parent values: Correctness(12982)
Complexity: Normal
Component/s: CQL/Interpreter
Discovered By: User Report
Fix Version/s: 3.11.x
Severity: Normal
Status: Open (was: Triage Needed)
> " as first char of a text column (and unique occurrence) during COPY with
> DELIMITER set to |
> --------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-17200
> URL: https://issues.apache.org/jira/browse/CASSANDRA-17200
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Dominique Hermsdorff
> Priority: Normal
> Fix For: 3.11.x
>
>
> Connected to Test Cluster at 127.0.0.1:9042.
> [cqlsh 5.0.1 | Cassandra 3.11.11 | CQL spec 3.4.4 | Native protocol v4]
> During an import using | as delimiter, e.g.:
> COPY cy4secure_company_demo.demo_contacts_clear
> (record_id,state,city,first_name,last_name,email,salary,credit_rating,debt,ssn,liabilities,comments,picture)
> FROM '/var/www/cy4secure/csv/001_demo_contacts_clear_100000.csv' WITH
> DELIMITER='|' AND NUMPROCESSES=2 AND MAXBATCHSIZE=1 AND CHUNKSIZE=50 AND
> SKIPROWS=2;
> Yep you can have double-quotes and quotes in a text column, no problem,
> example:
> {{<other fields>...|Earth
> {color:#FF0000}"{color}observation{color:#FF0000}"{color} taken
> {color:#FF0000}'{color}during{color:#FF0000}'{color} a day pass
> by...|...<other fields>}}
> BUT if you have a unique " at the beginning it fails, example:
> <other fields>...|{color:#FF0000}"{color}Earth observation taken during a day
> pass by...|...<other fields>
> This results in my case with: Failed to import 1 rows: ParseError - Invalid
> row length 12 should be 13, given up without retries
> And the rows part of the chunk are not imported.
> My workaround: filter text values that starts with a ".
> Otherwise, you'll probably want to take a look at it.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
