title: Failed to import 3 rows: ParseError - Invalid row length 1 should be 3, given up without retries
body: <p>I am trying to import csv file with delimiter=’|’. I am getting this repeated error, I am struggling like this for two days. Any help will be appreciated. Below are details.</p>
  
  <pre><code>Cassandra Version:
  [cqlsh 5.0.1 | Cassandra 3.0.9 | CQL spec 3.4.0 | Native protocol v4]
  </code></pre>
  
  <p>This is my csv:</p>
  
  <pre><code>row_nr|PRD_ID|X_01
  
  1|3170428144631014|25603.24
  2|3170428144632015|25606.24
  4|3170428144633017|25602.24
  </code></pre>
  
  <p>Created Keyspace:</p>
  
  <pre><code>create keyspace newpqp with replication = {'class:''simplestrategy', 'replication_factor':1};
  </code></pre>
  
  <p>Create Table:</p>
  
  <pre><code>CREATE TABLE againcheckdel(row_nr int primary key,PRD_ID bigint, X_01 decimal);
  </code></pre>
  
  <p>Copy command:</p>
  
  <pre><code>COPY againcheckdel(row_nr,PRD_ID,X_01) FROM 'C:\Users\skum\Documents\mytrial.csv' WITH  HEADER = 'true' AND DELIMITER = '|';
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>cqlsh:samplepqp&gt; COPY againcheckdel(row_nr,PRD_ID,X_01) FROM 'C:\Users\skum\Documents\mytrial.csv' WITH  HEADER = 'true' AND DELIMITER = '|';
  
  Using 7 child processes
  
  Starting copy of samplepqp.againcheckdel with columns [row_nr, prd_id, x_01].
  Failed to import 3 rows: ParseError - Invalid row length 1 should be 3,  given up without retries
  Failed to process 3 rows; failed rows written to import_samplepqp_againcheckdel.err
  Processed: 3 rows; Rate:       2 rows/s; Avg. rate:       3 rows/s
  3 rows imported from 1 files in 1.091 seconds (0 skipped).
  </code></pre>
  
  <p>What am I doing wrong? Please correct me.</p>