title: Migrating tables from Hive to Cassandra - using COPY
body: <p>I'm migrating tables from Hive/HDFS (Using Presto to speed up migration) to Cassandra v3.11.3, my question - Can I use any other method which will be easy? as I have less time and lot of tables to move.</p>
  
  <p>I have tried exporting tables from hive to cassandra as .csv files... but I'm running into other issues, like when I run COPY command it is not importing all the rows. It does not give me any error for this... but it fails to copy all the rows or records in that .csv file.</p>
  
  <p>Like I have 1074 rows in the .csv file but I end up seeing only 130 rows after running COPY from command in cassandra.</p>
  
  <p>Can I have some examples which I can use for better COPY command and also have complete rows copied from .csv file. </p>
  
  <p>I have tried below command for COPY ... it gives me good results but not showing all that records which I need.</p>
  
  <hr>
  
  <blockquote>
    <p>COPY table1
    ("domainid","value","description","siteid","orgid","testid","valueid","rowstamp","pluspcustomer")
    FROM '/tmp/csv_files/csv_table1.csv' with HEADER = true AND DELIMITER
    = ',' ; Using 7 child processes</p>
    
    <p>Starting copy of test_db.table1 with columns [domainid, value,
    description, siteid, orgid, testid, valueid, rowstamp, pluspcustomer].
    Processed: 1042 rows; Rate:     906 rows/s; Avg. rate:    1542 rows/s
    1042 rows imported from 1 files in 0.676 seconds (0 skipped).</p>
  </blockquote>
  
  <hr>
  
  <pre><code>SELECT count(*) FROM table1 ;
  </code></pre>
  
  <blockquote>
    <h2> count</h2>
    
    <p>130</p>
    
    <p>(1 rows)</p>
  </blockquote>
  
  <hr>
  
  <p>Please help...</p>