This is not the right data model for Cassandra. Strong encouragement to
watch one of Patrick McFadin's data modeling videos on youtube.
You very much want to always query where a WHERE clause, which usually
means knowing a partition key (or set of partition keys) likely to contain
your data, and
Hi Jeff - yes, I'm doing a select without where - specifically: select
uuid from table limit 1000;
Not inserting nulls, and nothing is TTL'd.
At this point with zero rows, the above select fails.
Sounds like my application needs a redesign as doing 1 billion inserts,
and 100 million deletes
The tombstone threshold is "how many tombstones are encountered within a
single read command", and the default is something like 100,000 (
https://github.com/apache/cassandra/blob/trunk/conf/cassandra.yaml#L1293-L1294
)
Deletes are not forbidden, but you have to read in such a way that you
touch
If the table has zero rows you could truncate it
On Mon, Oct 25, 2021 at 6:29 PM Joe Obernberger <
joseph.obernber...@gmail.com> wrote:
> Update - after 10 days, I'm able to use the table again; prior to that all
> selects timed out.
> Are deletes basically forbidden with Cassandra? If you have
Update - after 10 days, I'm able to use the table again; prior to that
all selects timed out.
Are deletes basically forbidden with Cassandra? If you have a table
where you want to do lots of inserts and deletes, is there an option
that works in Cassandra? Even thought the table now has zero
I'm not sure if tombstones is the issue; is it? Grace is set to 10
days, that time has not passed yet.
-Joe
On 10/14/2021 1:37 PM, James Brown wrote:
What is gc_grace_seconds set to on the table? Once that passes, you
can do `nodetool scrub` to more emphatically remove tombstones...
On
What is gc_grace_seconds set to on the table? Once that passes, you can do
`nodetool scrub` to more emphatically remove tombstones...
On Thu, Oct 14, 2021 at 8:49 AM Joe Obernberger <
joseph.obernber...@gmail.com> wrote:
> Hi all - I have a table where I've needed to delete a number of rows.
>
Hi all - I have a table where I've needed to delete a number of rows.
I've run repair, but I still can't select from the table.
select * from doc.indexorganize limit 10;
OperationTimedOut: errors={'172.16.100.37:9042': 'Client request
timeout. See Session.execute[_async](timeout)'},