Re: Design Query Optimization for Cassandra Table with Date-based Filtering

2023-12-14 Thread Sebastian Marsching
Hi Arjun, this is strange. You should be able to use a range query on a column that is part of the clustering key, as long as all columns in the clustering key left to this column are set to fixed values. So, given the table definition that you specified, your query should work (I just tested

Design Query Optimization for Cassandra Table with Date-based Filtering

2023-12-13 Thread arjun s
Hello team, I'm new to Cassandra and I've created a table using the following command: CREATE TABLE instant_cdr ( rowid int, msisdn varchar, id bigint, date_id int, channel varchar, usage_type varchar, ac_type varchar, voice_amt int, sms_amt int, data_amt int, field1 varchar,