title: Cassandra: Unable to import null value from csv
body: <p>I am trying to import a csv file to Cassandra. The csv file has been generated from Postgres and it contains some null values.</p>
  
  <p>Cassandra version:</p>
  
  <blockquote>
    <p>[cqlsh 5.0.1 | Cassandra 3.5 | CQL spec 3.4.0 | Native protocol v4]</p>
  </blockquote>
  
  <p>I am using this query to import:</p>
  
  <blockquote>
    <p>copy reports
    (id,name,user_id,user_name,template_id,gen_epoch,exp_epoch,file_name,format,refile_size,is_sch,job_id,status,status_msg)
    from '/home/reports.csv' with NULL='' and header=true and DELIMITER =
    ',';</p>
  </blockquote>
  
  <p>I keep on receiving this error:</p>
  
  <blockquote>
    <p>Failed to import 66 rows: ParseError - invalid literal for int() with
    base 10: '',  given up without retries</p>
  </blockquote>
  
  <p>However, when I changed all the null values to some random value, I was able to import that row using the same command. I have already tried all the solutions I found on internet.
  Please advise.</p>