Hi All,
We are using cassandra version 2.1.2 with cqlsh 5.0.1 (cluster of three
nodes with rf 2)
I need to load around 40 million records into a table of cassandra db. I
have created batch of 1 million ( batch of 10000 records also gives the
same error) in csv format. when I use copy command to import I got this
error, which is causing problem.
cqlsh:mesh_glusr> copy
glusr_usr1(glusr_usr_id,glusr_usr_usrname,glusr_usr_pass,glusr_usr_membersince,glusr_usr_designation,glusr_usr_url,glusr_usr_modid,fk_gl_city_id,fk_gl_state_id,glusr_usr_ph2_area)
from 'gl_a' with delimiter = '\t' and QUOTE = '"';
Processed 36000 rows; Write: 1769.07 rows/s
Record has the wrong number of fields (9 instead of 10).
Aborting import at record #36769. Previously-inserted values still present.
36669 rows imported in 20.571 seconds.
cqlsh:mesh_glusr> copy
glusr_usr1(glusr_usr_id,glusr_usr_usrname,glusr_usr_pass,glusr_usr_membersince,glusr_usr_designation,glusr_usr_url,glusr_usr_modid,fk_gl_city_id,fk_gl_state_id,glusr_usr_ph2_area)
from 'gl_a' with delimiter = '\t' and QUOTE = '"';
Processed 185000 rows; Write: 1800.91 rows/s
Record has the wrong number of fields (9 instead of 10).
Aborting import at record #185607. Previously-inserted values still present.
185507 rows imported in 1 minute and 43.428 seconds.
[cqlsh 5.0.1 | Cassandra 2.1.2 | CQL spec 3.2.0 | Native protocol v3]
Use HELP for help.
cqlsh> use mesh_glusr ;
cqlsh:mesh_glusr> copy
glusr_usr1(glusr_usr_id,glusr_usr_usrname,glusr_usr_pass,glusr_usr_membersince,glusr_usr_designation,glusr_usr_url,glusr_usr_modid,fk_gl_city_id,fk_gl_state_id,glusr_usr_ph2_area)
from 'gl_a1' with delimiter = '\t' and QUOTE = '"';
Processed 373000 rows; Write: 1741.23 rows/s
('Unable to complete the operation against any hosts', {})
Aborting import at record #373269. Previously-inserted values still present.
When we remove already inserted records from file and on again starting the
command for rest data, it inserts few more records and gives the same error
without any specific.
please help if any one have some idea about this error.
Regards:
Rahul Bhardwaj
--
Follow IndiaMART.com <http://www.indiamart.com> for latest updates on this
and more: <https://plus.google.com/+indiamart>
<https://www.facebook.com/IndiaMART> <https://twitter.com/IndiaMART> Mobile
Channel:
<https://itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=668561641&mt=8>
<https://play.google.com/store/apps/details?id=com.indiamart.m>
<http://m.indiamart.com/>
<https://www.youtube.com/watch?v=DzORNbeSXN8&list=PL2o4J51MqpL0mbue6kzDa6eymLVUXtlR1&index=2>
Watch how IndiaMART Maximiser helped Mr. Khanna expand his business. kyunki
Kaam
Yahin Banta Hai
<https://www.youtube.com/watch?v=Q9fZ5ILY3w8&feature=youtu.be>!!!
