Re: missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
<romainh...@yahoo.fr> wrote: > Hi, > > I assume a RF > 1. Right? > What is the consistency level you used? cqlsh use ONE by default. > Try: > cqlsh> CONSISTENCY ALL > And run your query again. > > Best, > Romain > > > Le Vendredi 29 janvier 2016 13h45, A

Re: missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
gt; > > -- Jack Krupansky > > On Fri, Jan 29, 2016 at 9:34 AM, Arindam Choudhury < > arindam.choudh...@ackstorm.com> wrote: > >> Hi Romain, >> >> The RF was set to 2. >> >> I changed it to one. >> >> CREATE KEYSPACE mordor WITH replic

Re: missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
pansky > > On Fri, Jan 29, 2016 at 10:12 AM, Arindam Choudhury < > arindam.choudh...@ackstorm.com> wrote: > >> I will check the output of nodetool cfstats. >> >> Its from version 2.1.2 to version 2.1.9. >> >> On 29 January 2016 at 16:02, Jack Krupansk

Re: missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
does your query to retrieve the rows look > like? > > On Fri, Jan 29, 2016 at 7:33 AM, Arindam Choudhury < > arindam.choudh...@ackstorm.com> wrote: > >> Hi, >> >> I am importing data to a new cassandra cluster using sstableloader. The >> sstableloa

missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
Hi, I am importing data to a new cassandra cluster using sstableloader. The sstableloader runs without any warning or error. But I am missing around 1000 rows. Any feedback will be highly appreciated. Kind Regards, Arindam Choudhury

Re: missing rows while importing data using sstable loader

2016-01-29 Thread Arindam Choudhury
Why in cqlsh when I query "select count(*) from mordor.things_values_meta ;" it says: 4692 But in nodetool cfstats it says Number of keys (estimate): 4720? On 29 January 2016 at 16:25, Arindam Choudhury < arindam.choudh...@ackstorm.com> wrote: > I am counting the rows with &q

Re: missing rows while importing data using sstable loader

2016-02-01 Thread Arindam Choudhury
What is the best practise to create sstables? On 1 February 2016 at 15:21, Romain Hardouin wrote: > Did you run "nodetool flush" on the source node? If not, the missing rows > could be in memtables. >