I am trying to insert 1030 rows in cassandra database but but after the a successful execution of code when i check for entries, then it shows only 280 rows.
I have attached images showing how i am inserting the rows and the number of rows i got into database.
This is the link to csv file which i am trying to insert Cassandra DB
I have shared the link of file above. Please check and share the solution to make it work.
I have tried again using csv reader to read and then using query to insert the data. Again i am getting only 280 rows.
I would like to post the answer then, which is what I assumed. Your primary key was not unique for each entry and so the entries were overwriting and not inserting new rows. That is easy to fix, just change the primary key so that all values in the primary key are unique.
The issue you described sounds like you got the data model wrong. In Cassandra, there is a big difference between number of records (CQL partitions) and rows.
A CQL partition can contain one or more rows depending on the data model. For example, a table with a simple primary key (there is only one column) will only ever have one row. Whereas a table with a compound primary key (more than one column) can have one or more rows.
In your case, it sounds like you've defined the table with a compound primary key instead of a simple primary key so you are not getting the results you expected. Cheers!
8 People are following this question.
