cassandra中，按照索引查询，报rpc timeout,且整个集群的负载很高。

[suhuadong888]

hi,请教个问题。 表的数据量大概3千万左右，我这根据二级索引的查询，报rpc_timeout且集群负载好高。 cassandra 版本：2.2.4

执行的sql: select city,price from device where city = '201' and price >=10 and price <=100 limit 20000 allow filtering

报的错： Request did not complete within rpc_timeout

我是按照city建的索引。city='201'的数据量大概为500百万左右。 行中的price,city会经常update.

我的建表语句如下： CREATE TABLE device ( key text, city text, createtime bigint, deviceid text, firstfreshtimestamp bigint, freshcount int, newtagweightdict blob, price int, recommendinglisttimestamp bigint, recommendtime bigint, serialpricedict blob, tagweightdict blob, updatetime bigint, PRIMARY KEY (key) ) WITH bloom_filter_fp_chance=0.010000 AND caching='{"keys":"ALL", "rows_per_partition":"ALL"}' AND comment='' AND dclocal_read_repair_chance=0.100000 AND gc_grace_seconds=864000 AND read_repair_chance=0.000000 AND default_time_to_live=0 AND speculative_retry='99.0PERCENTILE' AND memtable_flush_period_in_ms=0 AND compaction={'class': 'SizeTieredCompactionStrategy'} AND compression={'sstable_compression': 'LZ4Compressor'};