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.
>
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
nodetool cfstats (estimated) key count? Or... what?
>
> Are the tokens for the missing rows is the same range and a distinct range
> from the rest of the data in the original cluster?
>
> How many nodes in the original cluster?
>
> -- Jack Krupansky
>
> On Fri,
>
> 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 replication = {'class' : '
15:14, Romain Hardouin 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 13h4
6 at 13:39, Kai Wang wrote:
> Arindam,
>
> what's the table schema and what 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 i
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
