incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clint Kelly <clint.ke...@gmail.com>
Subject Re: Read timeouts with ALLOW FILTERING turned on
Date Tue, 05 Aug 2014 18:42:18 GMT
Hi Rob,

Thanks for your feedback.  I understand that use of ALLOW FILTERING is
not a best practice.  In this case, however, I am building a tool on
top of Cassandra that allows users to sometimes do things that are
less than optimal.  When they try to do expensive queries like this,
I'd rather provide a higher limit before timing out, but I can't seem
to change the behavior of Cassandra by tweaking any of the parameters
in the cassandra.yaml file or in the DataStax Java driver's Cluster
object.

FWIW these queries are also in batch jobs where we can tolerate the
extra latency.

Thanks for your help!

Best regards,
Clint


On Tue, Aug 5, 2014 at 10:54 AM, Robert Coli <rcoli@eventbrite.com> wrote:
> On Tue, Aug 5, 2014 at 10:01 AM, Clint Kelly <clint.kelly@gmail.com> wrote:
>>
>> Allow me to rephrase a question I asked last week.  I am performing some
>> queries with ALLOW FILTERING and getting consistent read timeouts like the
>> following:
>
>
> ALLOW FILTERING should be renamed PROBABLY TIMEOUT in order to properly
> describe its typical performance.
>
> As a general statement, if you have to ALLOW FILTERING, you are probably
> Doing It Wrong in terms of schema design.
>
> A correctly operated cluster is unlikely to need to increase the default
> timeouts. If you find yourself "needing" to do so, you are, again, probably
> Doing It Wrong.
>
> =Rob

Mime
View raw message