I have in the past tried to delete SSTables manually, but have noticed bits
and pieces of that data still remain, even though the sstables of that
window is deleted. So always wondered if playing directly with the
underlying filesystem is a safe bet?
On Mon, Feb 11, 2019 at 1:01 PM Jonathan
Hi,
I have a data model where the partition key for a lot of tables is based on
time
(year, month, day, hour)
Would this create a hotspot in my cluster, given all the writes/reads would
go to the same node for a given hour? Or does the cassandra storage engine
also takes into account the table
Hi,
I see that when I try to access /snapshot/{clusterName} API endpoint, I get
a 404 while all the other endpoints /cluster, /repair_run and
/repair_scheduler work for me. I am using version 1.2.1
It appears as if the /snapshot endpoint is not there
API doc that I am referring
ferent TTL than
> the base tables. There was patch released at some point to not allow TTL
> setting on MV (https://issues.apache.org/jira/browse/CASSANDRA-12868).
> MV's should inherit the TTL of the base table.
>
> Valentina
>
> On Fri, Feb 23, 2018 at 6:42 PM, Akash Gangil <akashg1.
Hi,
I had a couple of questions:
1. Can I create a materialized view on a table with a TTL longer than the
base table? For ex: my materialized view TTL is 1 month while my base table
TTL is 1 week.
2. In the above scenario, since the data in my base table would be gone
after a week, would it
To provide more context, I was going through this
https://docs.datastax.com/en/cql/3.3/cql/cql_using/useWhenIndex.html#useWhenIndex__highCardCol
On Thu, Feb 22, 2018 at 9:35 AM, Akash Gangil <akashg1...@gmail.com> wrote:
> Hi,
>
> I was wondering if there are recomme
Hi,
I was wondering if there are recommendations around the cardinality of
secondary indexes.
As I understand an index on a column with many distinct values will be
inefficient. Is it because the index would only direct me to the specfic
sstable, but then it sequentially searches for the target
I would second Jon in the arguments he made. Contributing outside work is
draining and really requires a lot of commitment. If someone requires
features around usability etc, just pay for it, period.
On Wed, Feb 21, 2018 at 2:20 PM, Kenneth Brotman <
kenbrot...@yahoo.com.invalid> wrote:
> Jon,
>