KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
using CF: CREATE TABLE history ( domain text, iid text, timeid timeuuid, data text, comments text, PRIMARY KEY (domain, iid, timeid) ); I'd like to query it like this: select domain, iid, timeid, data, comments from mappings where domain = 'a' and iid = 'b' order by timeid desc; But it fails with the following error (cassandra 1.1.5): Bad Request: Order by currently only support the ordering of columns following their declared order in the PRIMARY KEY Am I doing it wrong? What could be the workaround? Thx PS I got it working with the single EQ restriction and ORDER BY but I need at least 2 restrictions and order by.
Tags (comma-separated)
Save Edits
Cancel