Hi Asad,
Seems to me that your development team will need to remodel the tables
sooner than later. This problem can't be left unattended for long once it
starts hitting severely.
The way Cassandra is, you may want to have them replicate the same table
with different PK / structure to suitably embed
t; Date: Thursday 25 July 2019 at 15:49
JB> To: "user@cassandra.apache.org"
JB> Subject: Performance impact with ALLOW FILTERING clause.
JB> Hello Folks,
JB> I was going thru documentation and saw at many places saying ALLOW
FILTERING causes performance unpredictabil
atum: Donnerstag, 25. Juli 2019 um 20:05
An: "user@cassandra.apache.org"
Betreff: RE: Performance impact with ALLOW FILTERING clause.
Thank you all for your insights.
When spark-connector adds allows filtering to a query, it makes the query to
just ‘run’ no matter if it is expensive for lar
luence connector not to use
> allow filtering.
>
>
>
> Thanks again.
>
> Asad
>
>
>
>
>
>
>
> *From:* Jeff Jirsa [mailto:jji...@gmail.com]
> *Sent:* Thursday, July 25, 2019 10:24 AM
> *To:* cassandra
> *Subject:* Re: Performance impact with ALLOW FILTERING cl
Jirsa [mailto:jji...@gmail.com]
Sent: Thursday, July 25, 2019 10:24 AM
To: cassandra
Subject: Re: Performance impact with ALLOW FILTERING clause.
"unpredictable" is such a loaded word. It's quite predictable, but it's often
mispredicted by users.
"ALLOW FILTERING"
"unpredictable" is such a loaded word. It's quite predictable, but it's
often mispredicted by users.
"ALLOW FILTERING" basically tells the database you're going to do a query
that will require scanning a bunch of data to return some subset of it, and
you're not able to provide a WHERE clause that'
.
Regards,
Jacques-Henri Berthemet
From: "ZAIDI, ASAD A"
Reply to: "user@cassandra.apache.org"
Date: Thursday 25 July 2019 at 15:49
To: "user@cassandra.apache.org"
Subject: Performance impact with ALLOW FILTERING clause.
Hello Folks,
I was going thru documentation
Hello Folks,
I was going thru documentation and saw at many places saying ALLOW FILTERING
causes performance unpredictability. Our developers says ALLOW FILTERING
clause is implicitly added on bunch of queries by spark-Cassandra connector
and they cannot control it; however at the same time w