title: how to import csv file to cassandra
body: <p>I wanted to import csv file to cassandra so, first I created keyspace and columnfamily like this</p>
  
  <pre><code>CREATE COLUMNFAMILY Consumer_complaints(
      Date_received varchar,
      Product varchar,
      Sub_product varchar,
      Issue varchar,
      Sub_issue varchar,
      Consumer_complaint_narrative varchar,
      Company_public_response varchar,
      Company varchar,
      State varchar,
      ZIP_code varint,
      Tags varchar,
      Consumer_consent_provided varchar,
      Submitted_via varchar,
      Date_sent_to_company varchar,
      Company_response_to_consumer varchar,
      Timely_response varchar,
      Consumer_disputed varchar,
      Complaint_ID varint,
      PRIMARY KEY(Complaint_ID)
  );
  </code></pre>
  
  <p>I got a csv file from www.data.gov called consumer complaints
  and then I typed the command line</p>
  
  <pre><code>COPY consumer_complaints (Date_received,Product,Sub_product, Issue, Sub_issue, Consumer_complaint_narrative, Company_public_response, Company, State, ZIP_code, Tags, Consumer_consent_provided, Submitted_via, Date_sent_to_company, Company_response_to_consumer, Timely_response, Consumer_disputed, Complaint_ID) FROM 'consumer_complaints.csv';
  </code></pre>
  
  <p>Sample Input</p>
  
  <pre><code>3/21/2017,Credit reporting,,Incorrect information on credit report,Information is not mine,,Company has responded to the consumer and the CFPB and chooses not to provide a public response,EXPERIAN DELAWARE GP,TX,77075,Older American,N/A,Phone,03/21/2017,Closed with non-monetary relief,Yes,No,2397100
  04/19/2017,Debt collection,"Other (i.e. phone, health club, etc.)",Disclosure verification of debt,Not disclosed as an attempt to collect,,,"Security Credit Services, LLC",IL,60643,,,Web,04/20/2017,Closed with explanation,Yes,No,2441777
  </code></pre>
  
  <p>Error</p>
  
  <pre><code>Failed to import 1 rows: ParseError - Failed to parse 797XX : invalid lit for int() with base 10: '797XX',  given up without retries
  Failed to import 1 rows: ParseError - Failed to parse 354XX : invalid lit for int() with base 10: '354XX',  given up without retries
  Failed to import 2 rows: ParseError - Failed to parse 313XX : invalid lit for int() with base 10: '313XX',  given up without retries
  Failed to import 2 rows: ParseError - Failed to parse 054XX : invalid lit for int() with base 10: '054XX',  given up without retries
  </code></pre>
  
  <p>how can I fix it??</p>