Rikkuru commented on issue #1803:
URL:
https://github.com/apache/cassandra-gocql-driver/issues/1803#issuecomment-2320933671
```
SELECT event_id, time, args
FROM my.events
WHERE user = ? AND project_id = ?
AND year = ? AND week = ?
ORDER BY time DESC
LIMIT ?
```
Something like that on read
with
```
CREATE TABLE my.events (
user text,
year smallint,
week tinyint,
project_id smallint,
time timeuuid,
args map<text, text>,
event_id smallint,
ip inet,
PRIMARY KEY ((user, year, week, project_id), time)
```
I will try to find time on weekends to create an easier example in some
sandbox
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
