Re: Cassandra Needs to Grow Up by Version Five!

2018-02-21 Thread Akash Gangil
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, >

Secondary Indexes C* 3.0

2018-02-22 Thread Akash Gangil
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

Re: Secondary Indexes C* 3.0

2018-02-22 Thread Akash Gangil
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

Materialized Views and TTLs

2018-02-23 Thread Akash Gangil
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

Re: Materialized Views and TTLs

2018-02-23 Thread Akash Gangil
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.

Re: Reaper 1.2 released

2018-07-31 Thread Akash Gangil
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

Modeling Time Series data

2019-01-11 Thread Akash Gangil
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

Re: Max number of windows when using TWCS

2019-02-11 Thread Akash Gangil
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