My list of things I need for predicate queries across column and supercolumn names:
- bitmask (OR AND1 AND2 AND3 ...). This would make my life easier and take load off our Cassandra servers. Currently I have to scan the result sets on the client side to find the things I need. - date matching on Long supercolumns (find the last Friday, for example; the Calendar fields could be a good query language). This is not so important. FWIW I'd like an entirely text-based query language like SQL with the whole query in one string, accessible at the top keyspace level and not requiring other binary types. Then you don't have to worry about overengineering it one way or another, it simply supports whatever is necessary. You've already got some of the parser written for the cassandra-cli stuff. Another approach is to implement a JDBC driver with very limited query functionality. Ted