Use senttime as part of primary key
CREATE TABLE services.messagepayload_by_date (
record_date timestamp
partition_id uuid,
messageid bigint,
senttime timestamp,
PRIMARY KEY (record_date, senttime )
)
Partition id itself should be chronological say a date. Then you put
partition id in yo
In this use case you don't need the secondary index. Instead use Primary
key(partition_id, senttime)
Thanks
Jabbar Azam
On 12 Jun 2014 23:44, "Roshan" wrote:
> Hi
>
> Cassandra - 2.0.8
> DataStax driver - 2.0.2
>
> I have create a keyspace and a table with indexes like below.
> CREATE TABLE ser
As far as I can tell, the problem is that you're not using a partition key
in your query. AFAIK, you always have to use partition key in where clause.
And ALLOW FILTERING option is to let cassandra filter data from the rows it
found using the partition key.
One way to solve it is to make partition
