cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lokesh Ceeba - Vendor <Lokesh.Ce...@walmart.com>
Subject Unable to perform COUNT(*) on CASSANDRA table
Date Mon, 18 Apr 2016 23:38:35 GMT
Hello Team
                           The Kafka-Storm is running and the logs says, it processed 500,000
records.

But the table count(*) fails – timeout  -- Do you know why ??


cqlsh:sandbox> select count(*) from events;
OperationTimedOut: errors={}, last_host=10.226.68.248


DDL –setting parameters


AND bloom_filter_fp_chance = 0.01
AND comment = ''
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'
AND caching = {
                'keys' : 'ALL',
                'rows_per_partition' : 'NONE'
}
AND compression = {
                'chunk_length_kb' : 64,
                'crc_check_chance' : 1.0,
                'sstable_compression' : 'LZ4Compressor'
}
AND compaction = {
                'bucket_high' : 1.5,
                'bucket_low' : 0.5,
                'class' : 'LeveledCompactionStrategy',
                'cold_reads_to_omit' : 0.05,
                'enabled' : true,
                'max_threshold' : 32,
                'min_sstable_size' : 50,
                'min_threshold' : 4,
                'tombstone_compaction_interval' : 86400,
                'tombstone_threshold' : 0.2,
                'unchecked_tombstone_compaction' : false
};





Thanks
Lokesh

This email and any files transmitted with it are confidential and intended solely for the
individual or entity to whom they are addressed. If you have received this email in error
destroy it immediately. *** Walmart Confidential ***
Mime
View raw message