title: No rows inserted in table when import from CSV in Cassandra
body: <p>I am trying to import a CSV file to a Cassandra table however I am facing a problem.
  When inserted successfully, at least this is what Cassandra tells, I still can't see any record. Here is a little more details :</p>
  
  <pre><code>qlsh:recommendation_engine&gt; COPY row_historical_game_outcome_data  FROM '/home/adelin/workspace/docs/re_raw_data2.csv' WITH DELIMITER='|';
  
  2 rows imported in 0.216 seconds.
  cqlsh:recommendation_engine&gt; select * from row_historical_game_outcome_data;
  
   customer_id | game_id | time | channel | currency_code | game_code | game_name | game_type | game_vendor | progressive_winnings | stake_amount | win_amount
  -------------+---------+------+---------+---------------+-----------+-----------+-----------+-------------+----------------------+--------------+------------
  
  (0 rows)
  cqlsh:recommendation_engine&gt; 
  </code></pre>
  
  <p>And this is how my data looks like </p>
  
  <pre><code>'SomeName'|673|'SomeName'|'SomeName'|'TYPE'|'M'|123123|0.20000000000000001|0.0|'GBP'|2015-07-01 00:01:42.19700|0.0|
  'SomeName'|673|'SomeName'|'SomeName'|'TYPE'|'M'|456456|0.20000000000000001|0.0|'GBP'|2015-07-01 00:01:42.19700|0.0| 
  </code></pre>
  
  <p><strong>This is cassandra version apache-cassandra-2.2.0</strong> </p>
  
  <p>EDITED: </p>
  
  <pre><code>CREATE TABLE row_historical_game_outcome_data (
      customer_id int,
      game_id int,
      time timestamp,
      channel text,
      currency_code text,
      game_code text,
      game_name text,
      game_type text,
      game_vendor text,
      progressive_winnings double,
      stake_amount double,
      win_amount double,
      PRIMARY KEY ((customer_id, game_id, time))
  ) 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'}
      AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
      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 = '99.0PERCENTILE';
  </code></pre>
  
  <p>I've also tried the following as suggested by <strong>uri2x</strong>  </p>
  
  <p>But still nothing : </p>
  
  <pre><code>select * from row_historical_game_outcome_data;
  
   customer_id | game_id | time | channel | currency_code | game_code | game_name | game_type | game_vendor | progressive_winnings | stake_amount | win_amount
  -------------+---------+------+---------+---------------+-----------+-----------+-----------+-------------+----------------------+--------------+------------
  
  (0 rows)
  cqlsh:recommendation_engine&gt; COPY row_historical_game_outcome_data ("game_vendor","game_id","game_code","game_name","game_type","channel","customer_id","stake_amount","win_amount","currency_code","time","progressive_winnings")  FROM '/home/adelin/workspace/docs/re_raw_data2.csv' WITH DELIMITER='|';
  
  2 rows imported in 0.192 seconds.
  cqlsh:recommendation_engine&gt; select * from row_historical_game_outcome_data;
  
   customer_id | game_id | time | channel | currency_code | game_code | game_name | game_type | game_vendor | progressive_winnings | stake_amount | win_amount
  -------------+---------+------+---------+---------------+-----------+-----------+-----------+-------------+----------------------+--------------+------------
  
  (0 rows)
  </code></pre>