Agreed, but... in this case the table has ONE row, so what exactly could be causing this timeout? I mean, it can’t be the row count, right?
-- Jack Krupansky From: DuyHai Doan Sent: Wednesday, August 13, 2014 9:01 AM To: user@cassandra.apache.org Subject: Re: range query times out (on 1 node, just 1 row in table) Hello Ian Secondary index performs poorly with inequalities (<, ≤, >, ≥). Indeed inequalities forces the server to scan all the cluster to find the requested range, which is clearly not optimal. That's the reason why you need to add "ALLOW FILTERING" for the query to be accepted. "ALLOW FILTERING" means "beware of what you're doing, we C* developers do not give any guarantee about performance of such query". As Robert Coli used to say on this list, ALLOW FILTERING is synonym to PROBABLY TIMEOUT :D On Wed, Aug 13, 2014 at 2:56 PM, Ian Rose <ianr...@fullstory.com> wrote: Confusingly, it appears to be the presence of an index on int_val that is causing this timeout. If I drop that index (leaving only the index on foo_name) the query works just fine. On Tue, Aug 12, 2014 at 10:25 PM, Ian Rose <ianr...@fullstory.com> wrote: Hi - I am currently running a single Cassandra node on my local dev machine. Here is my (test) schema (which is meaningless, I created it just to demonstrate the issue I am running into): CREATE TABLE foo ( foo_name ascii, foo_shard bigint, int_val bigint, PRIMARY KEY ((foo_name, foo_shard)) ) WITH read_repair_chance=0.1; CREATE INDEX ON foo (int_val); CREATE INDEX ON foo (foo_name); I have inserted just a single row into this table: insert into foo(foo_name, foo_shard, int_val) values('dave', 27, 100); This query works fine: select * from foo where foo_name='dave'; But when I run this query, I get an RPC timeout: select * from foo where foo_name='dave' and int_val > 0 allow filtering; With tracing enabled, here is the trace output: http://pastebin.com/raw.php?i=6XMEVUcQ (In short, everything looks fine to my untrained eye until 10s elapsed, at which time the following event is logged: "Timed out; received 0 of 1 responses for range 257 of 257") Can anyone help interpret this error? Many thanks! Ian