cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Romain Hardouin <romainh...@yahoo.fr>
Subject Re: missing rows while importing data using sstable loader
Date Fri, 29 Jan 2016 14:14:00 GMT
Hi,
I assume a RF > 1. Right?What is the consistency level you used? cqlsh use ONE by default. Try: cqlsh>
CONSISTENCY ALLAnd run your query again.
Best,Romain 

    Le Vendredi 29 janvier 2016 13h45, Arindam Choudhury <arindam.choudhury@ackstorm.com>
a écrit :
 

 Hi Kai,

The table schema is:

CREATE TABLE mordor.things_values_meta (
    thing_id text,
    key text,
    bucket_timestamp timestamp,
    total_rows counter,
    PRIMARY KEY ((thing_id, key), bucket_timestamp)
) WITH CLUSTERING ORDER BY (bucket_timestamp ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'min_threshold': '4', 'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32'}
    AND compression = {'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99.0PERCENTILE';


I am just running "select count(*) from things_values_meta ;" to get the count.

Regards,
Arindam

On 29 January 2016 at 13:39, Kai Wang <depend@gmail.com> 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.choudhury@ackstorm.com>
wrote:

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






  
Mime
View raw message