cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Reddy <rahulreddy1...@gmail.com>
Subject Re: New column
Date Mon, 19 Aug 2019 20:23:34 GMT
Jon,

If we expect non of  our partition key to have more than 100 records and
pass partition key in where clause we wouldnt see issues using new column
and allow filtering?  Can you please point me to any doc how allow
filtering works. I was in assumption of it goes through all the partitions


On Sun, Aug 18, 2019, 4:33 PM Jon Haddad <jon@jonhaddad.com> wrote:

> If you're giving the partition key you won't scan the whole table. The
> overhead will depend on the size or the partition.
>
> Would be an interesting workload for our tlp-stress tool, I'll code
> something up for the next release.
>
> On Sun, Aug 18, 2019, 12:58 PM Rahul Reddy <rahulreddy1234@gmail.com>
> wrote:
>
>> Hello,
>>
>> We have a table and want to add column and select based on existing
>> entire primary key plus new column using allow filtering. Since my where
>> clause has all the primary key + new column does the allow filtering scan
>> only the partions which are listed or does it has to scan whole table? What
>> is the best approach add new column and query it based on existing primary
>> key plus new column?
>>
>

Mime
View raw message